MS Excel Course Series (COSIMEEC18)

Maximize your productivity by leveraging the different Excel features

Mike Thomas
Language: English | Duration: 6 Hrs | CPE - 6.0 CPE Credits |
Loading the player...


Microsoft Excel is one of the most commonly used tools at work. It is a powerful, sophisticated tool and can be used in many ways. It’s not just restricted to creating tables and documentation, – it’s most common use. It has a lot more to offer and can help you solve complex problems at work within a small amount of time. This course with Excel expert Mike Thomas has been specifically created to take you through all those Excel features and formulas that can boost your productivity at work and make you keep everything in order, just as you want it.

This course will discuss the different features in Excel that can help you enhance your performance at work. This course will provide individual sessions that will cover the different features, formulas, charts and more available in Excel. You will gain a detailed understanding of these features, their usage, and benefits to enhance your productivity.

Learning Points:
  • Excel Beginners Plus: Basics
  • Excel Beginners Plus: Formulas
  • Excel Beginners Plus: Charts and Visualizations
  • Excel Beginners Plus: Managing List-Based Data
Mike Thomas

Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with Mac OSX and Mac-related software since 2006; however, his passion is for all-things-Excel and in 2012 he founded the website

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes.


MS Excel Course

As a professional, Microsoft Excel is one of your best friends at work. Its very purpose is to make your life easier by organizing the data you work on categorically and making it easily accessible for use. However, you may be missing out on many of its features and formulas that can improve your productivity at work. Right from data entry shortcuts, creating formulas, using functions, to conditional formatting, filters, and more, Excel has so much to offer that you could use at work. This course has been created to address those areas where Excel can help you become more productive.

Session 1


Almost everyone around the world uses Excel for several reasons. However, most Excel users have a very limited knowledge of Excel and just how effective this tool can be. They do know what a spreadsheet is, and how they can navigate around and enter and edit data in it. Yet, there’s so much that they can still learn, to improve their productivity. In this session, Excel expert Mike Thomas will take on the critical features of this application to get you up-and-running, including some data entry shortcuts designed to save you a ton of time, formatting your spreadsheets to make them presentable and easy-to-read and printing out your data. The session will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel.

Course Highlights:
  • Key differences between Excel versions (2010, 2013, 2016)
  • Excel Online
  • Excel as part of Office 365
  • Shortcuts for selecting ranges
  • Use AutoFill and Flash Fill to automate list creation
  • Create and maintain Custom Fill Lists
  • Resolve the Leading Zero Problem
  • Creating cell comments
  • Resize, insert, delete and hide columns and rows
  • Change the appearance of data: Font, size, color, borders, alignment
  • Change the way numbers and dates are displayed
  • Use the Format Painter to quickly copy formatting from one cell to another
  • Use Conditional Formatting to apply formatting based on defined criteria
  • Use protection to "bullet-proof" your spreadsheets
  • Insert, delete, rename and move worksheets within a workbook
  • Working with multiple worksheets
  • Previewing before you print
  • Choosing what to print
  • Defining Headers, Footers and other print settings
  • How to print cell comments

Session 2


Formulas are calculations so whether you need to calculate loan repayments, generate a profit-and-loss account or solve maths or engineering problems, formulas are your friend. In fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you’ll find the need to use formulas in Excel. In this session, Excel expert Mike Thomas will explain how although it is perfectly possible to use Excel without ever creating a formula or using a function, if you don’t, you’re missing out on a huge part of the application’s power. You can use formulas and functions to automate your calculations and save a ton of time. No more using your fingers. No more mental arithmetic. No more using the calculator app on your Smartphone! Let Excel do the work for you!

Course Highlights
  • Create formulas to perform addition, subtraction, division and multiplication
  • How to copy a formula
  • The difference between absolute and relative references
  • Create an absolute cell reference in a formula
  • Create a relative cell reference in a formula
  • Create a mixed cell reference in a formula
  • Ways of using Paste Values to paste the result of a copied formula
  • The process for assigning names to cells and using them in formulas
  • Introduction to Functions: SUM, COUNT and AVERAGE
  • Create functions that extract part of a text entry (LEFT, RIGHT, MID)
  • Create functions that convert the case of a text entry (UPPER, LOWER, PROPER)
  • Create functions that combine text entries (CONCATENATE, CONCAT and TEXTJOIN)

Session 3


Until a few years ago, it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like data visualization and infographics. It's time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world. In this session, Excel expert Mike Thomas will help you learn how to create and enhance the appearance of traditional charts such as bar charts. You’ll also learn how to create Sparkline charts (really useful in dashboards), infographic-style charts and how to represent data in a visual way without using the charting features at all.

Course Highlights
  • How to select the right chart: Bar, line, pie or one of the many others
  • Charting 101:Create a basic chart
  • From drab to fab: Enhance and customize a chart
  • Combination charts: Line and bar in a single chart
  • Creating in-cell Sparkline charts
  • Creating infographics with the Excel People Graph
  • Use conditional formatting to create a heat map
  • Use conditional formatting icon sets to represent change visually

Session 4


If you think that Excel is all about working with numbers then think again. More and more people are turning to Excel to help them manage list-based and tabular data. In many cases they receive, download or import data from elsewhere and before that data can be used within their business and treated as a credible source of information, it needs to be seriously checked and cleaned – duplicate entries, non-printing characters, extra spaces and capitalization inconsistencies are all-too-often present in downloaded and imported data. In this session, Excel expert Mike Thomas will train you to deal with and fix all these issues. You'll also get to learn about managing list and tabular based data in terms of sorting (into different orders) and applying and saving filters (that let you display only certain items).

Course Highlights
  • Sort a column of items into order (alphabetically or numerically)
  • Sort a row of items into order (alphabetically or numerically)
  • Sort a list of date-based items into order
  • Filter a list to display only certain items
  • Save a filter for re-use
  • Prevent list headings disappearing as you scroll
  • Remove duplicates from a list
  • Create a table
  • Table styles
  • Create table-based formulas and functions
  • Use a table to create an automatically-updating chart
  • Attach a slicer to a table

6.0 CPE Credits

Online Course

$699 $399


  • One year access
  • Access on Mobile
  • Certificate of Completion
  • 6.0 CPE Credits
  • 4 Session's 90 minutes each
  • Assignment
  • Quiz

Coming Soon

  • Intermediate Course
  • Advance Course