Microsoft Excel Training (Introduction)

Microsoft Excel training for beginners, teaching key techniques to get you up and running.

This course provides a thorough grounding in the application, showing you how to turn disorganised data into useful information and quickly make spreadsheets your friends. 

Sessions Include:

• Program fundamentals.
• Opening, saving and closing a spreadsheet.
• Basic formulae.
• Editing worksheets.
• Formatting worksheets.

Who Should Attend?

• This course is ideal for anyone who needs to use Excel in their day-to-day work.

How Will I Learn?

• Excel training is hands-on and practical.
• Our trainers teach the necessary theory then demonstrate techniques step-by-step. You then practice the techniques taught on a computer running Excel.
• There is plenty of time to ask questions, and you can keep all the files you create.

Course Content:

• Program Fundamentals
• Starting Excel
• Understanding the Excel Program Screen
• Giving Commands
• Using Command Shortcuts
• Creating a New Workbook
• Opening a Workbook
• Previewing and Printing a Worksheet
• Saving a Workbook
• Closing a Workbook
• Using Help
• Exiting Excel
• Getting Started with Worksheets
• Navigating a Worksheet
• Entering Labels and Values
• Selecting a Cell Range and Entering Data in a Cell Range
• Overview of Formulas and Cell References
• Entering Formulas
• Entering Content Automatically
• Referencing External Data
• Editing Worksheets
• Editing Cell Contents
• Copying and Moving Cells
• Controlling How Cells Are Moved or Copied
• Collecting Items to Move or Copy
• Checking Your Spelling
• Inserting Cells, Rows, and Columns
• Deleting Cells, Rows, and Columns
• Using Undo and Redo
• Finding and Replacing Content
• Adding Comments to Cells
• Tracking Changes
• Formatting Worksheets
• Formatting Text
• Formatting Values
• Adjusting Row Height and Column Width
• Working with Cell Alignment
• Adding Cell Borders and Background Colours
• Copying Formatting
• Applying and Removing Cell Styles
• Creating and Modifying Cell Styles
• Using Document Themes
• Applying Conditional Formatting
• Creating and Managing Conditional Formatting Rules
• Finding and Replacing Formatting