This course forms part of the Microsoft Office Fundamental: Outlook, Word and Excel Training Course.

The Microsoft Office Fundamental: Outlook, Word and Excel Training Course teaches you how to create and edit Word documents, Excel spreadsheets, and emails with Microsoft Office.

This is the second part of the 3 in 1 course and in this training course, you will learn basic to advance Excel skills.

In this training, you will learn how to create and edit Excel spreadsheets, perform calculations on data, visualize and present information effectively by using charts, graphics, and formatting.


Today, employers across many industries and fields expect candidates to have Microsoft Office skills, as it is the most universally utilized software in business. Having these skills, even at a basic level, will help with your job prospects and increase your chances to be considered for most roles.

What you’ll learn

  • Master Microsoft Excel from Beginner to Advance
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Learn how to use dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Create aggregate reports using formula based techniques
  • Learn about data model creation
  • Explore, analyze, and visualize data

Course Curriculum

Excel Fundamentals
Set Up A Workbook – Introduction Details 00:05:00
Create Workbooks Details 00:20:00
Modify Workbooks Details 00:15:00
Modify Worksheets Details 00:15:00
Merge and Unmerge Cells Details 00:15:00
Work with Data and Excel Tables
Lesson Introduction Details 00:03:00
Enter and Revise Data Details 00:15:00
Manage Data By Using Flash Fill Details 00:15:00
Move Data Within A Workbook Details 00:15:00
Find and Replace Data Details 00:15:00
Define Excel Tables Details 00:15:00
Sort Worksheet Data Details 00:15:00
Perform Calculations On Data
Lesson Introduction Details 00:03:00
Name Groups of Data Details 00:15:00
Create Formulas to Calculate Values Details 00:30:00
Summarize Data That Meets Specific Conditions Details 00:30:00
Find and Correct Errors in Calculations Details 00:20:00
Module Assessment Exam
Module Assessment Exam 00:20:00
Advanced Skills in Excel
Change Workbook Appearance Details 00:05:00
Format Cells Details 00:15:00
Define Styles Details 00:15:00
Apply Workbook Themes and Excel Table Styles Details 00:15:00
Make Numbers Easier To Read Details 00:15:00
Change The Appearance of Data based on Its Value Details 00:20:00
Add Images to Worksheets Details 00:10:00
Create Charts and Graphics
Lesson Introduction Details 00:05:00
Create Charts Details 00:30:00
Customize Chart Appearance Details 00:25:00
Print Worksheets and Charts
Lesson Introduction Details 00:05:00
Add Headers and Footers to Printed Pages Details 00:20:00
Prepare Worksheets for Printing Details 00:20:00
Print Worksheets Details 00:15:00
Print Charts Details 00:15:00
OPTIONAL: Create Dynamic Worksheets by using PivotTables
Lesson Introduction Details 00:05:00
Analyze Data Dynamically by using PivotTables Details 00:20:00
Filter, Show, and Hide PivotTable Data Details 00:20:00
Edit PivotTables Details 00:20:00
Format PivotTables Details 00:20:00
Module Assessment Exam
Module Assessment Exam 00:20:00
Final Course Exam
Corporate Soft Skills Training Vol. 1 – Final Course Exam 00:30:00

SmithTips is a human capital organization that is aimed at being the bridge between academia and industry by working to build and develop the capacity of individuals and groups.

 Dansoman Atico, Accra, Ghana

(00) 233 260 734 574

Last Tweets

Who’s Online

There are no users currently online
Skip to toolbar