MS Excel Course Content

INTRODUCTION

• Getting started
• Entering text and numbers
• Copy, Cut and Paste
• Simple calculations
• Formatting Cells and Ranges
• Printing Spreadsheets
• Working with Worksheets
• Saving and opening files
• More formulae
• Absolute Cell referencing
• Sorting data
• Creating Graphs and Charts

INTERMEDIATE

• Working with text and numbers
• Copy, Cut and Paste
• Using formulae
• Formatting text and numbers
• Aligning text and numbers
• Conditional Formatting
• Working with Worksheets
• Date and time calculations
• Working with Rows and Columns
• Using Headers and Footers
• Using Comments
• Printing options
• Using Excel as a Database
• Using If statements
• Using Graphs and Charts
• Saving Worksheets

ADVANCED

• Review and refresh exercise
• Manipulating text
• Useful formulae and functions
• Linking Worksheets and Workbooks
• Lookup tables
• Absolute Cell referencing
• Goal Seeking
• Formatting options
• Date and Time calculations
• Data manipulation
• Data Validation
• Scenarios
• Protection and passwords
• Macros
• Auditing a Spreadsheet