E-Books →Microsoft Excel 365 Intermediate [Video]

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.
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.