Automate Decisions with 
Logical Functions​ in Microsoft Excel

Overview:

This modue is designed to enhance your proficiency in using Microsoft Excel's logical functions to automate decision-making processes. Logical functions, such as IF, AND, OR, and others, are essential tools for making data-driven decisions and streamlining workflows. By the end of this module, you will be able to leverage these functions to create dynamic and efficient spreadsheets.

Target Audience:

This module is ideal for:

  • Beginners with little to no Excel experience
  • Professionals looking to refresh their basic Excel skills
  • Anyone wanting to improve their productivity with spreadsheets

By the end of this course, you'll be able to:

  • Understand the role and importance of logical functions in Excel.
  • Use IF, AND, OR, and other logical functions to automate decision-making processes.
  • Incorporate error-handling in Formulas
  • Use auditing tools to track and correct errors in formulas

Topics include:

  • Perform conditional tests using the IF function
  • Perform multiple condition evaluations using AND & OR
  • Perform multiple condition evaluations using IFs
  • Use IFERROR and IFNA to handle errors in formulas

All Microsoft Excel Modules

Automate Decisions with Logical Functions

Search and Retrieve Data from tables with Lookup Functions

Analyse and Visualise Date with Pivot Tables

Add Automation to Your Workbooks with Macros

Transform Your Data with Power Query

Use AI in Excel to Turbo Charge Your Excel Experience

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data

Back to Training Courses
Submit
Thank you! Your message has been sent.
Unable to send your message. Please fix errors then try again.
Smiling professional man giviing okay gesture and holding a laptop

Contact Us

To find out more about our products and services or to discuss how we can help  improve communications and collaboration using Microsoft 365 apps within your organisation, give us a call on the telephone number below or complete the contact form.

  01274 024 353

Last Updated : 04/08/2024