Microsoft Excel Intermediate Level Course
2 sessions over 2 days - 3hrs per session
Wednesday 13th July & Thursday 21st July 2022
£65 per delegate (2 sessions)
Please include the version of Excel product used with enquiries. Office 365, 2016 or 2019 preferred.
Attendees should have attended, or have knowledge equivalent to the Introductory Level course
Module 3 - Creating Formulas
* Using the AutoSum feature to automatically add values
* Understanding Formulas and their rules
* Creating Basic Formulas
* Copying and Pasting Formulas
* Using and Creating Absolute Formulas to enable a specific value to be used many times, i.e. VAT rate
* Finding Minimum, Maximum and Average values of a list of data
* Using named ranges within a formula
* Using the Function Library
* Inserting and Formatting Dates and Times
* Using Dates within Formulas
Module 4 - Links, Graphs & Basic Conditional Logic
* Linking Workbooks
* Working with Hyperlinks
* Protecting Formulas and Worksheets
* Understanding Conditional Logic, i.e. IF statements
* Working with Multiple Worksheets within a Single Workbook, Renaming, Inserting, Copying Information and Creating Summary Worksheets
· Creating Graphs