MS Office Excel (Online Session (Zoom))

If you are looking for information on using Excel, look no further! We’ve designed a comprehensive one-level Office Excel Core Essentials programme that covers all the essentials of working with Excel.
Topics covered in this course include using basic formulas and functions; time-saving tools (like AutoFill, AutoComplete, AutoSum, and the new Flash Fill); PivotTables and PivotCharts; workbook formatting techniques; inserting objects (like SmartArt, charts,and text boxes); exporting a workbook as PDF or XPS; and customizing the interface.


Module 1: The Basics

  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook
  • Review Questions

Module 2: Your First Workbook

  • Selecting Data
  • Entering and Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste
  • Review Questions

Module 3: Working with Data

  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Using Paste Special
  • Using Find and Replace
  • Hiding and Unhiding Cells
  • Review Questions

Module 4: Using Basic Excel Tools

  • Understanding Cell References and Formulas
  • Using Basic Formulas
  • Using Basic Functions
  • Using Advanced Functions
  • Using Spell Check
  • Using Sort and Filter
  • Review Questions

Module 5: Using Timesaving Tools

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate
  • Review Questions

Module 6: Formatting Text

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting
  • Review Questions

Module 7: Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format
  • Review Questions

Module 8: Formatting the Workbook

  • Using Cell Styles
  • Formatting Data as a Table
  • Changing the Theme
  • Inserting Page Breaks
  • Adding a Background
  • Review Questions

Module 9: Inserting Art and Objects

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Equations
  • Drawing Shapes
  • Review Questions

Module 10: Charting Data

  • Creating Sparklines
  • Inserting Charts
  • Inserting PivotTables
  • Inserting PivotCharts
  • Using Slicers
  • Creating Timelines
  • Review Questions

Module 11: Viewing, Printing, and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF or XPS
  • Printing a Workbook
  • E-Mailing a Workbook
  • Sharing Your Workbook on SkyDrive
  • Review Questions

Module 12: Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes
  • Review Questions

Module 13: Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table
  • Review Questions

Module 14: Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields
  • Review Questions

Module 15: Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions
  • Review Questions

Module 16: Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List
  • Review Questions

Module 17: Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments
  • Review Questions

Module 18: Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes
  • Review Questions

Course Price: