Microsoft Excel Fundamentals Training Course

Our one day Online Microsoft Excel Fundamentals training course will provide an introductory overview to the basic use and functions of Microsoft Excel.

Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.

Our Microsoft Excel Fundamentals Training Course is designed to provide those that attend with the basics of how to use this very much used software.

Those who attend this Microsoft Excel Fundamentals Training Course will be able to:

• Produce a variety of spread sheets
• Use set up techniques and page formatting tools
• Create simple calculations and formulas
• Use basic Microsoft Excel functions

Basic Spreadsheets

• The Excel Window
• Working with the ribbon and commands
• Using the help facility

Navigating Excel, Selecting and Entering Data

• Creating, Saving and Closing Spreadsheets
• Opening existing spreadsheets
• Navigating around a spreadsheet
• Entering, editing and deleting data
• Using auto-fill and creating custom lists

Editing Data, Columns and Rows

• Inserting and deleting rows and columns
• Adjusting widths and heights of columns and rows
• Using the cut and paste options

Page Set-up and Printing

• Using the print preview option
• Changing and applying print options

Basic Formulas and Functions

• Using formulas to make a range of calculations i.e. add, subtract, divide etc
• Using the auto-sum function
• Using average, minimum and maximum functions
• Working with relevant and absolute cell references

Formatting Text and Sizes

• Adjusting cell alignment
• Changing the formats of numbers i.e. dates, percentages, currency etc
• Adding borders and shading to spreadsheets