Excel Intermediate Level - Welshpool

FULLY BOOKED - Email info@mwmg.org to express interest in more courses

This course can be delivered as a full day course or as individual half day modules
* 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