Description

Intermediate 1

the most necessary functions to manage files and file cleansing.
This course includes detailed videos on how to use the formulas, and functions a proposed exercise with solutions,
and deliverables with reference information.

lesson 1
– introduction to formulas and functions in Excel 365.
– The most important functions to managing files and data cleansing.

In this Excel course, you will learn the most used formulas in Excel 365, how to take advantage of conditional formats, table management, use nested functions to perform multiple validations, Pivot Tables, Pivot Charts, and Macros Introduction for Excel 365.

This course includes detailed videos and exercises on how to use the functions.

 

Excel Intermediate Level  2 Topic:

1. The most used formulas in Excel 365

2. Conditional formats

3. Management of tables and data

4. Built-in or nested functions in Excel

5. Assigning range names to cells

6. Cell validation

7. Pivot tables

8.Management of links

Advanced with AI

Excel with AI Mod 1, we will explore in this module: introduction, what is AI, types of AI, Generative AI, How can help us chatGTP in Excel, basic prompts in ChatGPT, ChatGPT and VBA code, Understanding scenario and goal seek, how works checkboxes

Advanced with AI II – III

Excel features and techniques that will take your spreadsheet skills to new heights, while also integrating the power of Artificial Intelligence (AI) to supercharge your productivity.

We start by diving into Forms and Slicers, two powerful tools that enhance data input and visualization. Learn how to create user-friendly forms that simplify data entry and streamline your workflow. Discover the magic of slicers, enabling you to filter and analyze data with just a few clicks, giving you unprecedented control and insights.

Next, we delve into Recommended Pivot Tables, an AI-driven feature that assists in creating dynamic and insightful pivot tables effortlessly. Discover how Excel’s AI algorithms analyze your data and suggest pivot table configurations that best suit your needs. Uncover the hidden potential of pivot tables and master the art of data analysis and reporting