Microsoft Excel Basic
Course overview
Delegates will learn the Excel basics: It will allow you to be able to perform basic calculations with confidence using formulas, be able to navigate around Excel much quicker and learn the shortcuts. It will show you how to create and format professional spreadsheets, build simple formulas, calculate totals and lots more.
Topics covered
Fundamentals
- Starting Excel
- What’s new in Excel
- Understanding the Excel screen
- Giving commands and using command shortcuts
- Creating workbooks
- Opening a workbook
- Previewing and printing a worksheet
- Saving workbooks
- Closing a workbook
- Using help
- Exiting a workbook
Editing a worksheet
- Editing cell contents
- Copying and moving cells
- Controlling how cells are moved or copied
- Collecting items to move or copy
- Checking 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
Getting started with worksheets
- Navigating worksheets
- Entering labels and values
- Selecting a cell range and entering data in a cell range
- Overview of Formulas and cell references
- Entering formulas including Sum, Average & Count
- Entering content automatically
- Referencing external data
- Freeze Panes
- Absolute Cell References
Formatting a worksheet
- 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
Delivery methodology
(Face-to-face or virtual delivery available)
Small groups
Ideally 6-8 delegates to maximise engagement and interaction levels.
One-to-one
We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).
Tailored sessions
Talk to us about designing bespoke workshops for your team
Course guide
Download our training course guide and find out more.
Book this course
Call Us: +44 (0)1623 409 824
Email Us: info@futureproof-training.com
