Microsoft Excel 2016 Course Overview

Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spreadsheet program in many business activities, classwork and even personal data organisation. Excel was first released in the year 1985. Since then, it has played a vital role in performing formula based arithmetic and calculations, and other activities that may require mathematical calculations. Many businesses, personal and institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for different applications. To possess the excel skills, we provide three different classes for three different levels. Which are Basic, Intermediate and Advance.

Microsoft Excel 2016 - Basic

If you have little or no experience with Microsoft Excel, this 1-day Excel course will provide you with a comprehensive introduction to use all features in Excel. You will gain practical skills to use immediately in the workplace. Learn to create, edit, format, and print basic Microsoft Excel worksheets. Our Excel master will share tips that will help you save time and better display your data on screen and in print. At the end of this course, you will be able to:

  1. Create basic worksheets using Microsoft Excel
  2. Modify and manage Excel workbooks
  3. Learn to insert the right data
  4. Manage to format and align the data
  5. Print the content of an Excel worksheet

Basic Excel Course Outline

Basic 1 - Becoming Acquainted with Excel

  • What is Excel?
  • Excel Navigation Basics
  • Creating, Saving, and Opening Workbooks
  • Using Dialog Box Launchers
  • Quick Access Toolbar
  • Switch between Touch and Mouse Mode
  • Screen Tips
  • Excel’s Tell Me What You Want to Do Feature

Basic 2 - Navigating and Working with Worksheets

  • Moving Between Cells Using the Keyboard
  • Select Cells by Using Their Cell References in the Name Box
  • Going Directly to Any Cell
  • Worksheets
  • Reordering and Copying Worksheets
  • Using Tab Buttons to Move through the Worksheets

Basic 3 - Best Ways to Enter and Edit Data

  • Data Types
  • Correcting Typing Mistakes
  • Returning a Cell to Its Original Value
  • Creating, Viewing, Editing, Deleting, and Formatting Cell Comments
  • Clearing the Contents of a Cell That Has Already Been Accepted
  • How to View all the Comments at the Same Time
  • How to Change the Default Name for Comments

Basic 4 - Formatting and Aligning Data

  • Formatting Your Text Using the Font Group
  • Using the Font Group’s Dialog Box Launcher
  • Formatting with Color
  • Check Which Formats Have Been Applied to the Current Cell
  • Accessing the Format Cell Dialog Box

Basic 5 - Different Ways of Viewing and Printing Your Workbook

  • Views
  • Page Break Preview
  • Page Layout View
  • Printing
  • Freezing Rows and Columns
  • Synchronizing Scrolling
  • Custom Views How to Create, Show, and Delete

Microsoft Excel 2016 - Intermediate

Choose this Excel level if you are comfortable doing basic tasks in spreadsheets and want to learn to create more powerful and dynamic spreadsheets. This level trains you to streamline and analyze data. Learn to keep data organized by managing large data sets with lists and tables especially Pivot tables and Vlookup functions. At the end of this course, you will be able to:

  1. Create and understand the concept of formula
  2. Insert and modify other function in worksheets
  3. Learn and work with table and charts
  4. Learn to use conditional formatting and styles
  5. Utilise the Pivot tables to obtain a desired report

Intermediate Excel Course Outline

Intermediate 1: Excel’s Pre-existing Functions

  • Excel’s Built-in Functions
  • Function Construction
  • Functions That Sum Values
  • SUM Function
  • Using the Insert Function Option
  • Adds the Cells That Meet a Specified Criteria
  • Adds the Cells That Meet Multiple Criteria
  • Returns Different Values Depending upon If a Condition Is True or False
  • Returns TRUE if All of Its Arguments Are TRUE
  • Returns TRUE If Any Argument Is TRUE
  • Returns the Current Date
  • Returns the Current Date and Time
  • Returns the Serial Number of the DATE
  • Returns the Number of Days Between Two Dates

Intermediate 2 - Using Hyperlinks, Combining Text, and Working with the Status Bar 39

  • Working with Hyperlinks
  • Concatenation and Flash Fill
  • Using the Status Bar
  • Flash Fill Blank Cells and Flash Fill Changed Cells
  • Scroll Lock
  • Fixed Decimal
  • Macro Recording
  • Average, Count, Numerical Count, Minimum, Maximum, Sum
  • View Shortcut
  • Zoom and Zoom Slider

Intermediate 3 - Transferring and Duplicating Data to Other Locations

  • Moving and Copying Data
  • Moving and Copying Cells Using the Drag-and-Drop Method, Cut and Copy Buttons , Keyboard
  • Copy Data to Other Worksheets Using Fill Across Worksheets
  • Copy Data from One Workbook to Another
  • Using Paste Special
  • Using Paste Special to Transpose Rows and Columns
  • Using Paste Special to Perform Calculations
  • Inserting Copied or Moved Cells
  • Using the Microsoft Office Clipboard
  • Entering Data into Multiple Worksheets at the Same Time

Intermediate 4 - Working with Tables

  • Creating and Formatting Tables
  • Sort and Filter a Table
  • Adding to the Excel Table
  • Filtering Data with a Slicer
  • Applying and Defining Cell Styles
  • Conditional Formatting

Intermediate 5 - Working with Charts

  • Chart Types
  • Creating and Modifying Charts
  • Pie Charts
  • The Standard Pie Chart
  • Pie of Pie Subtype
  • Combination Chart
  • Hierarchical Charts
  • Treemap Chart
  • Sunburst Chart
  • Sparklines

Intermediate 6 - Using PivotTables and PivotCharts

  • Working with PivotTables
  • Creating a PivotChart
  • Creating PivotTable on a Relational Database

Microsoft Excel 2016 – Advanced

Already comfortable using Microsoft Excel? Take your skills to the next level in this Advanced Excel course. Our Excel master will share Excel’s most powerful and advanced tools, including Advanced Formula, PivotTables, Macros, and more. You will gain skills for better collaboration, including tracking changes, learn to audit worksheets, validate data to ensure consistency, and use other essential business tools in Microsoft Excel. At the end of this course, you will be able to:

  1. Enhance Formula in Worksheets
  2. Learn to auditing, validating and protecting workbook
  3. Create advanced charts, graphs and Pivot tables
  4. Import and export data
  5. Create, use, edit and manage Macros

Advance Excel Course Outline

Advance 1 - Creating and Using Formulas

  • Introducing Formulas
  • Auto Calculate Tools
  • Average, Count Numbers, Max, Min
  • Viewing Formulas
  • Creating Named Ranges and Constants
  • Naming Ranges and Noncontiguous Ranges
  • Using Column or Row Headings for Range Names
  • Selecting Named Ranges Rather Than Typing Them into Formulas
  • Absolute Cell References
  • Mixed Cell References
  • Order of Precedence

Advance 2 - Auditing, Validating, and Protecting Your Data

  • Validating Your Data and Preventing Errors
  • Data Validation
  • Using IFERROR
  • Formula Auditing
  • Tracing Precedents and Dependents
  • Using the Watch Window
  • Using the Evaluate Formula Feature to Evaluate a Nested Function One Step at a Time
  • Proofreading Cell Values—Have Excel Read Back Your Entries
  • Spell Checking
  • Thesaurus

Advance 3 - Transferring and Duplicating Data to Other Locations

  • Moving and Copying Data
  • Moving and Copying Cells Using the Drag-and-Drop Method
  • Moving and Copying Cells Using the Cut and Copy Buttons
  • Moving and Copying Cells Using the Keyboard
  • Paste Button Gallery
  • Copy Data to Other Worksheets Using Fill Across Worksheets
  • Copy Data from One Workbook to Another
  • Paste Special
  • Using Paste Special to Transpose Rows and Columns
  • Using Paste Special to Perform Calculations
  • Inserting Copied or Moved Cells
  • Insert Copied Cells
  • Insert Cut Cells
  • Using the Microsoft Office Clipboard
  • Entering Data into Multiple Worksheets at the Same Time

Advance 4 - Working with Tables

  • Creating and Formatting Tables
  • Sort and Filter a Table
  • Adding to the Excel Table
  • Filtering Data with a Slicer
  • Using Themes
  • Applying and Defining Cell Styles
  • Conditional Formatting

Advance 5 - Working with Charts

  • Chart Types
  • Creating and Modifying Charts
  • Pie Charts
  • The Standard Pie
  • Chart Pie of Pie Subtype
  • Combination Chart
  • Hierarchical Charts
  • Treemap Chart
  • Sunburst Chart
  • Sparklines

Advance 6 - Importing Data

  • Importing Data into Excel
  • Importing Text Files
  • Delimited Text Files
  • Fixed-Width Text Files
  • Importing Data from an Access Database
  • Importing Data from a Web Site
  • Importing Data Using a Query

Advance 7 - Using PivotTables and PivotCharts

  • Working with PivotTables
  • Creating a PivotChart
  • Creating PivotTable on a Relational Database

Advance 8 - Enhancing Workbooks with Multimedia

  • Adding Pictures to the Worksheet
  • Using Screenshot
  • Working with WordArt
  • Adding and Modifying Shapes
  • Using SmartArt
  • Inserting Sound into a Worksheet
  • Inserting Video into a Worksheet
  • Using Bing Maps

Advance 9 - Automating Task with Macros

  • Creating (Recording) a Macro
  • The Problem with Absolute Cell References
  • Saving a Macro-Enabled Workbook
  • Creating a Macro Using Relative Cell References
  • Adding Macros to the Quick Access Toolbar and Other Objects
  • Sharing the Personal Workbook with Others
  • Looking at VBA Code
  • Creating Macros from Code

Find Out More About Us!