Excel Topic 1: Conditional Formatting, Multiple Sheets & External Linking
Course Duration: 90 Minutes
Target Audience:
This session is intended for Excel users who wish to use conditional formatting and other features in their Workbooks.
Course Objectives:
This session allows the Excel user to broad the complexity of functionality within their spreadsheet. It covers automatic formatting data in a sheet based on key values or criteria. How to manage multiple sheets as a group and link formula/cells through multiple sheets and across different workbooks.
Course Outline:
Course Introduction
Using Conditional Formatting
Standard Conditional Formatting vs. Customised Conditions
Grouping and Ungrouping Sheets
Working the Formulas Through Multiple Worksheets
Copying and Pasting Links
Creating Links between Workbooks
Finding and Exploring External Links in a Workbook
Discussion and Question Time
Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.