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.

CONTENT

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