Microsoft 365: Excel Desktop Level 1
- Course focuses on creating, editing basic Excel worksheets.
- Aims to teach Excel components, formulas, and functions.
- Targeted at those needing basic Excel knowledge.
- Prerequisites include familiarity with Windows environment.
- Objectives cover Excel environment exploration and formatting.
Overview
The Online Microsoft 365 Excel Training Course aims to enable participants to understand the basic components of Excel and learn how to create and use formulas. Targeted at individuals needing basic Excel knowledge, the course covers exploring the Excel environment, creating worksheets, using formulas and functions, formatting worksheets, managing workbooks, and setting up printing options. Prerequisites include familiarity with using a computer in a Windows environment. The course is one day long and costs £175 + Vat.
Who should attend
Anyone requiring basic knowledge of Excel.
Course Content
In this virtual Microsoft 365: Excel Desktop Level 1, Instructor-Led course you will create and edit basic Microsoft Excel worksheets and workbooks. You will learn all the basics you need to start entering your data and building organised workbooks.
You can view all of our Microsoft Office courseshere.
Who Should Attend
Location
Course Syllabus
Day 1
Getting Started with Excel
- Excel and the Excel Environment
- New Single Document Interface
- Start up, Back Stage view and Themes
- The Ribbon
- Customise the User Interface
- Navigate and Select in Worksheets
- Create a Basic Workbook
- Open, Save and Close Workbooks
- Use Search for Help and Smart Lookup
Modifying a Workbook
- Cut, Copy and Paste Commands
- Flash Fill
- AutoFill Options and AutoComplete
- Selecting Items within Excel
- Insert and Delete Options
- Column Width and Row Height
- Spell Check
- Undo and Redo
- Hide and Unhide Options
Formatting an Excel Worksheet
- Font Group
- Add Borders and Fill Colours
- Cell Alignment
- Number Formatting
- Cell Styles and Galleries
Using Formulas and Functions
- Create Relative Formulas
- Mixed Cell References
- AutoCalculate
- Create Absolute Formulas
- Using Functions
- Use SUM and AutoSum
- Commonly Used Functions
- The Insert Function
- Copy Formulas and Functions
Managing Worksheets and Workbooks
- Use Excels Quick Analysis Tools
- Format Worksheet Tabs
- Manage Worksheets
- Deleting and Inserting Worksheers
- Grouping and Ungrouping Worksheets
- Fill Across Worksheets
- View Worksheets and Workbooks
Printing Options
- Set the Page Layout Options
- Set Page Breaks
- Print Worksheets and Workbooks
- Page Setup
- Print Layout View
Additional Information
Delegates should be familiar using a computer/laptop within a Windows environment.
