Advanced Excel Training @ Aptech

(From Spreadsheets to Smart Sheets : Master Excel with AI-Powered Skills)

​

The course is crafted for professionals and students who want to turn data into powerful insights using both traditional and AI enhanced tools. You will learn how to create dynamic reports, automate workflows, and use AI aided formula suggestions, the Data Analysis ToolPak, and built-in Excel AI tools to simplify complex tasks.

​

Syllabus:

 

• Work sheet protection, allow user to edit a range

• Workbook protection and sharing on LAN/ One drive

• Excel key board shortcuts

• Filtering and sorting

• Page layout

• Using formula and functions:

       (mathematical, financial, lookup, text, statistical)

• Conditional statements (if, And, Or, XOR)

• Use VLOOKUP, HLOOKUP, Advanced Lookup

• Formula auditing

• Data analytical tools:

       (Goalseek, Solver, What if analysis, subtotal)

• Conditional formatting

• Data Validation

• Pivot table, Slicer, Time line

• Charts and pivot chart

• Creating dashboard

• Scenario manager

• AI aided formula editor

• Enhancing Pivot Tables with AI recommendations

• How to Integrate Excel and ChatGPT

• Using Using the Data Analysis Toolpak
  
  Duration: 1.5 to 2 Months
  Mode: Classroom or Live Online
  Software Used: MS Excel 2021, AI tools in Excel

 

​​​​

📺 Subscribe to our YouTube Channel: Aptech Nayapalli YouTube Watch demo classes and get a feel of our training before you join!

​