Microsoft Excel - The Beginners Introduction To Excel

Course details

Are you looking to build your skills in using Microsoft Excel?

This course gives you a deep understanding of how to use some of the most popular functions in Excel. We will build you from a base skill level and assume you have no prior knowledge in using Microsoft Excel or its functions. 

In this course we will cover Excel Basics, Formatting and Manipulation, Creating Formulas and Cell Referencing, Automatic Functions, Creating and Formatting Charts, Managing and Linking Worksheets, Using AutoFill, Freeze Panes and Printing. Most lectures are 7 - 14 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.

Microsoft Excel - The Beginners Introduction To Excel Outline

• The Excel Environment
• Select and Highlighting Cells
• Entering Information
• Formatting Information
• Modifying Information - Wrap Text and Merging Cells
• Inserting/Deleting Columns and Rows
• Save, Save As and Open
• Find Opening and Closing Excel
• Creating and Copying Formulas
• Using BODMAS in Formulas
• Absolute Cell Referencing
• Using Functions - SUM, IF, COUNT, AVERAGE
• AutoSum Features
• Difference between Excel manual and automated calculations
• Creating and Formatting Charts
• Inserting, Moving and Deleting Worksheets
• Grouping Worksheets
• AutoFill Feature
• Linking formulas between Worksheets
• Freeze Panes
• Print Area and Print Preview