Excel Timesaving Features – Part 1 is the first half of our productivity-focused Excel training. This session introduces powerful tools and shortcuts that help you work faster and smarter in Excel. You’ll learn how to manage multiple worksheets, link spreadsheets, and use conditional logic and formatting to automate your work.

This course is ideal for users who have completed Excel Essential Skills and are ready to take their spreadsheet design and efficiency to the next level.

All Excel users who want to save time and reduce manual effort. If you use Excel regularly, this course will introduce you to practical hacks that can transform your workflow.

You should:

• Understand the different shapes of the mouse pointer in Excel
• Be confident with formulae including AutoSum, absolute references, and percentage calculations
• Know how to use AutoFill and drag-and-drop to copy and move data

By the end of Part 1, you’ll be able to:

• Work across multiple worksheets efficiently
• Link data between spreadsheets to reduce duplication
• Use conditional logic and formatting to automate decisions and highlight key data

Module 1: Recapping Formula and Table Essentials

• Excel Calculations
• Excel Functions
• Excel Tables and their Impact on Formulas
• Absolute Referencing and Cell Naming

Module 2: Linking and Protecting Files

• Internal and External Linking of Cells
• Preventing Links from Breaking
• Protecting Workbook
• Protecting specific parts of a Worksheet

Module 3: Logical/Conditional Functions

• IF Functions
• AND, OR & NOT Functions
• Nested IF vs IFS