Advanced Excel and Data Reporting Course
- Home
- Advanced Excel and Data Reporting Course
Advanced Excel and Data Reporting Course
Master Basic, Advanced Excel, Power Query, and VBA Macros Automation
Free Demo Class Available, 100% Job-Oriented Training, Practical & Hands-On Learning
Excel is essential for every business. From MIS reporting and HR to finance, analysis, dashboard creation, operations, and management, Excel is everywhere. While many people know the basics, few understand how to work efficiently, analyze data, create dashboards, and automate tasks professionally.
Our 3-Month Excel, Power Query, and VBA Macros Mastery Program is designed to take you from a beginner to an expert in automation. We do this step-by-step, using real business datasets and live practice sessions.
Why Learn Excel With UYS?
- Learn Excel practically with real business datasets
- Understand reporting, MIS formats, and dashboard design
- Clean and automate data using Power Query
- Automate repetitive tasks with VBA Macros
- Learn what companies expect in actual jobs, not just theory
- Build speed, accuracy, and confidence in your office work
Key Highlights
- 3 Months Duration, Free Demo Class, 100% Job-Oriented Training
- Learn Excel from Basic to Advanced in 12 Weeks, Experience teaching before joining,
- Designed for MIS/Analyst job
Course details:
Module 1: Excel – Basic & Intermediate
Excel Introduction
- Understanding spreadsheet basics
- Different ways to select cells and ranges
- Essential keyboard shortcuts
Customizing Excel
- Personalising the Ribbon
- Using and adjusting AutoCorrect
- Changing default Excel settings
Using Basic Functions
- Core functions – SUM, AVERAGE, MAX, MIN, COUNT, COUNTA
- Working with absolute, mixed and relative references
Formatting and Proofing
- Custom number formats using 0, #, ?, @ etc.
- Basic and advanced conditional formatting rules
Mathematical Functions
- SUMIF, SUMIFS, COUNTIF, COUNTIFS
- AVERAGEIF
Protecting Excel
- Workbook / file-level protection
- Worksheet and cell protection
Text Functions
- UPPER, LOWER, PROPER
- LEFT, MID, RIGHT
- TRIM, LEN
- CONCATENATE / CONCAT, FIND, SUBSTITUTE
Date and Time Functions
- TODAY, NOW
- DAY, MONTH, YEAR
- DATE, DATEDIF, DATEADD-style logic
- EOMONTH, WEEKDAY
Paste Special Techniques
- Paste formulas vs formats
- Paste validations
- Transpose rows/columns
New Tools in Excel 2016 & 365
- New charts – Treemap, Waterfall
- Sunburst, Box & Whisker charts
- Combo charts with secondary axis
- Using slicers in tables & pivots
- Power Map and Power View overview
- Forecast Sheet
- Sparklines – Line, Column & Win/Loss
- 3D Maps
- New PivotTable field/item/set controls
- Auto-complete a data range/list
- Quick Analysis tool
Basic & Advanced Filters
- Filtering text, numbers & colours
- Sorting options
- Advanced Filter using 15–20 criteria
Module 2: Advanced Excel
Printing Workbooks
- Setting up print area
- Custom header & footer options
- Repeat rows/columns as print titles
What-If Analysis
- Goal Seek
- Scenario Manager
- Data Tables (with PMT-style calculations)
- Solver tool basics
Logical Functions
- IF function
- Handling errors with IFERROR
- Nested IF conditions
- Complex logic using IF with AND / OR
Lookup Functions
- VLOOKUP and HLOOKUP
- INDEX + MATCH
- Building smooth user forms using lookups
- Nested VLOOKUPs
- Reverse lookup with CHOOSE
- Nth occurrence lookups
- Lookups using helper columns
- INDIRECT-based lookups
Pivot Tables
- Creating basic PivotTables
- Advanced value field settings
- Classic Pivot layout
- Grouping by number ranges & dates
- Calculated fields and calculated items
- Running totals, rank, percentage calculations
- “Difference from” calculations
- Using slicers with pivots
Array Functions
- Concept of array formulas and when to use them
- Core array examples (Ctrl+Shift+Enter)
- Arrays combined with IF, LEN, MID etc.
- Array formulas with lookup functions
Charts and Slicers
- Column, bar, line and pie charts
- Applying slicers to quickly filter data
Managing primary and secondary axes
Excel Dashboards
- Planning the dashboard layout
- Adding tables and charts to a dashboard sheet
- Making dashboard elements dynamic
Module 3: Power Query (Data Cleaning & Automation with UYS)
Power Query Basics
- Connecting to multiple data sources (Excel, CSV, folders)
- Removing duplicates, blanks and errors
- Splitting, merging and transforming columns
- Changing data types and formatting
- Unpivoting and pivoting data for reports
Data Automation with Power Query
- Building step-by-step query transformations
- Refreshing reports with one-click updates
- Combining multiple files from a folder
Creating reusable data-cleaning queries
Module 4: VBA Macros (Automation)
Introduction to VBA
- What VBA is and where it is used
- What you can automate with VBA
- Recording your first macro
- Understanding procedures and functions
Variables in VBA
- What variables are and why they matter
- Using undeclared vs declared variables
- Variable data types
- Using constants (Const)
MessageBox and InputBox Functions
- Customising message boxes and input boxes
- Reading cell values into messages
IF and SELECT Statements
- Simple IF statements
- ELSEIF chains
- SELECT CASE structure
- Practical SELECT CASE examples
- Nested IF vs SELECT CASE
- Using AND / OR in conditions
Looping in VBA
- Overview of loop types
- Basic DO and FOR loops
- Exiting a loop safely
- Advanced loop examples
- DO UNTIL loops
- Using OFFSET in loops
Worksheet & Workbook Operations
- Merging worksheets using macros
- Combining multiple Excel files into one sheet
- Splitting sheets with VBA and filters
- Copying and managing worksheets via code
Career Add-ons
- Interview preparation for Excel / Analytics roles
- Certification support and guidance
Outcome from UYS Advanced Excel, Power Query & VBA Macros
By the end of this program, learners will be able to:
- Build and format professional workbooks
- Analyse data using advanced formulas, PivotTables and dashboards
- Clean and automate data updates using Power Query
- Automate repetitive tasks with VBA macros
- Be better prepared for MIS, reporting, data analysis and automation roles
Advanced Excel and Data Reporting Course
- 1.Understanding spreadsheet basics
- Different ways to select cells and ranges
- Essential keyboard shortcuts
- Personalising the Ribbon
- Using and adjusting AutoCorrect
- Changing default Excel settings
Find Other Courses
- Web Designing & Full Stack Development Program
- PHP & Advanced PHP Training
- Diploma in Data Analytics
- ChatGPT & AI Tools Professional Certification Program
- Advanced Digital Marketing Program
Advanced Excel and Data Reporting Course
Please Fill the Form
Advanced Excel and Data Reporting Course – FAQs
Do I need Excel knowledge before joining?
No, the course starts from the basics and progresses to an advanced level.
Will I learn Power Query and Macros also?
Yes, Power Query for automation and VBA for scripting are included in this program.
Do we work on real Excel datasets?
Yes, we use business-related raw data for dashboards, reports, and automation tasks.
Can I get a job after completing this?
Yes, this course prepares you for roles in MIS, reporting, data analysis, and Excel automation.
Is certification provided?
Yes, a UYS Certification is given upon completion.
How long is the course?
3 Months Total with weekly practice & working sessions.
Can this help me earn as a freelancer?
Yes, there is strong freelance demand for Excel automation and dashboard building.