Our Microsoft Excel Introduction Course will ensure your team members have sound working knowledge of Excel. This course gives a solid introduction Microsoft Excel and its data management features. It is designed for Excel 2013, 2016, 2019 & 365.
Our Microsoft Excel Introduction course is suitable for beginners (individuals or corporate) to Microsoft Word or those that need a solid foundation to the basics of Word.
A working knowledge of Microsoft Windows. No knowledge of Excel is required
Getting Started
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks
Entering and Editing data
Best practice spreadsheet design
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
Flashfill
Modifying a Worksheet
Moving and copying data
Moving and copying formulas
Inserting and deleting ranges
Using Functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, MAX and COUNT
Absolute and Relative cell references
Formatting Worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat
Working with Large Worksheets
Viewing options
Adjusting zoom
Using Freeze Panes
Hiding and displaying data
Hiding rows and columns
Creating an outline
Printing
Preparing to print
Page Setup options
Printing large worksheets
Page Break preview
Working with page breaks
Printing multiple sheets
Using Templates
Built-in templates
Accessing and using Excel’s templates
Creating, using and modifying a custom template file
Send us a message & we will respond shortly
Enter your name, like you want it to appear on your Certificate