Summary
An Online Training & Certificate on Advanced Excel. Also, learn ChatGPT Applications in Excel, Automate Functions, Dashboard Creation, Automation with Macros & VBA. Reduce your workload by Automation.
ONLINE Timing
Sunday Only (4th Feb, 11th Feb, 18th Feb and 25th Feb). Live 11 AM To 1 PM. After 2 hours of training, we will provide you with recordings and practice data sheets for a lifetime.
Total 4 Sundays. If you miss any class, you will be using the recordings and can ask doubts in the session.
Trainer Experience
16+ Years
Who Should Attend
If you want to grow in your career, Automate your tasks in Excel and impress the boss and clients. You can not ignore this course because it not only gives you career growth but also helps you save your job. The sooner you learn ChatGPT applications & Advanced Excel, the better for your performance on the job.
Course Curriculum (Modules)
Module 1
Power Query - Advanced Data Cleaning & Automation
Data Import: Importing data from various sources (Excel, CSV, Folders, PDF, databases, web).
Data Transformation: Cleaning, reshaping, and preparing data with Power Query.
Merging and Appending Data: Combining & Consolidation data from different sources.
Use Case Example: Automating data preparation for monthly reports.
Module 2
Advanced Excel Formulas & Functions
Logical Functions, Statistical Functions, Financial Functions, Date and Time, Functions, Lookup Functions, Text Functions, Array Formulas, Dynamic Array, and Functions (Excel 365).
Module 3
Pivot Tables & Power Pivot - Advanced Pivot Techniques and Dashboards
Pivot Tables for Reporting & Summarization: Different reports & layouts, Automating & updating pivots on data modification.
Data visualization: Advanced charting techniques, Slicers, Sparklines and Timelines.
PivotTables with Power Pivot: Creating advanced PivotTables using the Power Pivot mode.
Data Modelling: Creating relationships between different data tables.
Creating Calculated Columns and Measures: Using DAX (Data Analysis Expressions).
Use Case Example: Building a dynamic dashboard.
Module 4
Automation with Macros and VBA
Automating repetitive tasks and data processes
Module 5
ChatGPT and its integration with Excel
Practical applications of ChatGPT in various Excel scenarios
Recordings after each class
Lifetime access to recordings, practice material and certification after the completion.
Check full course details here
https://edu4sure.com/advanced-excel-live-batch
