
Course content
What you'll learn
The Microsoft Excel course introduces you to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look and working with formulas to manage routine tasks.
Module 1: Getting Started
Understanding the Excel screen · Navigating in a spreadsheet · Understanding worksheets, columns, rows and cells · +1 more
Module 2: Formatting a Spreadsheet
Changing column widths and row heights · Changing alignment of cells · Undoing and redoing actions · +4 more
Module 3: Formulas and Functions
Entering formulas · Copying data and formulas · Using AutoSum · +5 more
Module 4: Editing Features
Using cut , copy, and paste operations · Using paste special with values · Selection techniques · +1 more
Module 5: Working with Large Worksheets
Freezing and unfreezing panes · Splitting windows · Inserting page breaks for printing
Module 6: Working with Charts
Creating charts using Chart Wizard · Creating different types of charts · Including titles and values in charts · +1 more
Module 7: Previewing and Printing
Previewing worksheets · Page setup · Printing of worksheets in multiple pages · +2 more
Module 8: Simple Database Operations
Sorting tables · Filtering data with auto filter · Referring data from other worksheets










