For information on course costs and booking onto a course, please click here. For any queries please contact us on Training@ttslonline.com or call: 01582 550019Welcome, Guest

Microsoft Excel 365 Intermediate

Course Overview

Welcome to the "Microsoft Excel 365 Intermediate" course. In this course, you'll improve your Excel skills to manage data and efficiently make informed decisions.

You'll learn to design better spreadsheets, improve readability, and control data input with cell styles and validation. You'll streamline data analysis and comparison tasks by mastering logical functions, lookup formulas, and sorting techniques.

Additionally, you'll delve into statistical and math functions, formatting, date and time manipulation, text and array operations, pivot tables, charts, and formula auditing.

With hands-on exercises, you'll gain practical experience effectively using Excel's intermediate features.

By the end of this course, you should be equipped with the skills to handle complex data tasks confidently, enhancing your productivity and analytical abilities in both personal and professional contexts.

Learning Objectives:

In this course you will learn how to:

  • Design spreadsheets effectively using cell styles.
  • Control data input with validation techniques.
  • Utilize logical functions for decision-making tasks.
  • Perform advanced lookup operations using various formulas.
  • Master sorting and filtering techniques for data organization.
  • Apply statistical functions for data analysis.
  • Utilize pivot tables and charts for data visualization and analysis.