In this Microsoft Excel Intermediate training course you will learn how to:
- Create PivotTables
- Create & use VLookup & IF Functions
- Create Charts
- Create Essential Date & Time Functions
- Share a Spreadsheet
This 1-day course is available either at your premises or at the Cambourne training venue. If you would like to book this course, please email us, and we'll let you know the available dates. As soon as a date has been fixed the training day will be booked.
Training Delivery: Live Online Instructor Led & Classroom Face to Face
Course Duration: 1 Day 09:30 - 16:30
Excel Classes Online Instructor Led Online Training Course - All you need to know.
What are the Benefits?
- Hands on training
- Comprehensive online courseware for delegates to keep
- Online certificate of completion for each delegate
- 1 Month post training support
Microsoft Excel Intermediate
Lists, lists, lists it seems as if the whole world is a bundle of lists. It doesn't matter what industry you are associated with you will need to analyse and present data. You don't have to have attended the beginners Excel course to attend this one. However, being a little familiar with Excel will of course be a great help.
Course Outline
Introduction to Excel 365 and the Excel interface
- Understanding rows, columns, and cells
- Navigating and selecting data in a worksheet
- Entering and editing data in cells
- Basic formatting techniques (e.g. changing font size, colour, and alignment)
Basic formulas and functions within Excel 365
- Using basic arithmetic operators (e.g. +, -, *, /)
- Understanding the difference between relative and absolute cell references
- Using functions such as SUM, AVERAGE, MIN, and MAX
Working with multiple worksheets and workbooks
- Creating, renaming, and deleting worksheets
- Moving and copying data between worksheets and workbooks
- Linking data between worksheets and workbooks
Sorting and filtering data
- Sorting data alphabetically or numerically
- Filtering data using criteria
- Advanced filtering techniques (e.g. using AND/OR logic)
Working with basic charts and graphs
- Creating and formatting charts and graphs
- Adding data labels and data tables to charts
- Changing the chart type and style
Importing and exporting data
- Importing data from other sources (e.g. CSV files, databases)
- Exporting data to other formats (e.g. PDF, CSV, HTML)
Collaborating with others, including printing
- Sharing workbooks and worksheets with others
- Tracking and resolving conflicts in shared workbooks
- Protecting worksheets and workbooks with passwords
- Printing worksheets
This Live Online Instructor led Microsoft Excel Intermediate training course is available from wherever you are.
