Microsoft Power BI

    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

    View Schedule
    Contact Us