Microsoft Excel Foundation Training

Learn the basic skills you need to use Excel efficiently including how to format text and numbers, perform basic calculations and present data in a graphical format.

What will I learn?

• Our Microsoft Excel Foundation course covers the basic skills you need to use Excel efficiently. You’ll learn:
• the basics of creating spreadsheets
• how to format text and numbers
• perform basic calculations
• present data in a graphical format

No previous experience of Excel is required to attend but you should have a basic understanding of PCs, including familiarity with a keyboard and mouse.

Full Microsoft Excel Foundation Training Course Content:

• The Excel Screen
• Spreadsheet Terminology Explained
• Navigate the Excel Environment
• Access Help
• Create Basic Spreadsheets
• Enter and Edit Text, Numbers and Dates
• Delete and Clear Data and Formats
• Selection Methods
• Adjust Column Width and Row Height
• AutoFill and Custom Lists
• Work with Flash Fill
• Use Cut, Copy and Paste
• Use Find and Replace
• Format a Spreadsheet
• Apply Text Formats
• Apply Number Formats
• Apply Borders and Shading
• Merge Cells and Wrap Text
• Manage Rows and Columns
• Worksheet Views and Print Settings
• Workbook Views
• Page Setup Options
• Print Worksheets and Workbooks
• Print Titles
• Set Print Areas and Print Selection
• Introduction to Functions
• Add up values with AutoSum
• MAX, MIN, AVERAGE and COUNT
• COUNTA and COUNTBLANK
• Create Basic Formulae
• Create Basic Calculations using Operators (Add, Subtract, Multiply and Divide)
• Understand Brackets () within Formulae
• Use Relative and Absolute Cell References
• Introduction to Charts
• Create a Chart: Pie, Column or Line
• Apply a Chart Style
• Print Charts
• Manage Worksheets
• Insert, Delete, Copy and Move Worksheets
• Rename Worksheets
• Apply Tab Colour
• Work with Larger Spreadsheets
• Use Zoom Control
• Apply Freeze Panes
• Sort and Filter Data
• Collaborate with Colleagues
• Share a File
• Add Notes and Comments
• Show Changes