Advance Excel Analytics for Kids & Teenagers
Master Excel pivots and Learn Data Analysis with Business Intelligence
- Learn how to THINK like Excel, and write powerful and dynamic Excel formulas
- How to validate and visualise data
- Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel
- Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
Course Description
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Next in line is Excel Charts & Graphs with Chart formatting & Customization
We will then cover Excel Pivot Tables, which are an absolutely essential tool for anyone working with data in Excel. Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise.
In the third level will cover Excel Dashboard and VBA Macros. This course teaches you to create well-designed Excel dashboards so you can see trends and make quick decisions informed by data and use VBA Macros to improve your work flow, save time and automate your current Excel projects.
Mode
Online / Offline
Levels
3 levels
Level Duration
48 hours
This Course Includes:
- Suggested Age: 12+ Years
- Prerequisites: Excel Basics
- Location: Online and Classroom
- Mode of Delivery: Group Session and 1:1
- Batch Size: Maximum batch size upto 5 students per faculty for online classes
- Language: English
- Credits: End of term module completion certificate & Awards based on performance
Looking For Start Date?
1:1 starts on demand
Group batches starts several times during the years, please reach out for start dates.
Bonus Features
Completion Certificate
Performance Awards
Feedback From Instructors
1:1 Parents Teacher Meeting
Special One-Off Workshops
Entrepreneurial Skills
Detailed Curriculum
Level 1
- Excel Formulas 101, Fixed and relative cell references, Formula Auditing, Data Validation
- Conditional Statements & Logical Operators
- Excel Statistiscal Functions, Lookup & Reference Functions
- Text Functions, Date & Time Functions, Formula Based Formatting, Array Formulas
- Data Visualisation 101: Best practises, Chart formatting & Customisation
- Excel Charts & Graphs, Using external Tools
Level 2
- Excel Pivot Tables 101, Formatting Data, Sorting Filtering and Grouping Data in Pivot
- PivotTable calculated values & Fields, Visualising data with Pivot Charts
- Case Studies
- Power Excel 101, Connecting & Transforming Data in Power query
- Building Table Relationships with Excel's Data Model
- Analysing Data with Power Pivot and Dax
- Dax Formulas & Functions
Level 3
- Excel Dashboard 101, Report Design Principles
- Dashboard Source Data & Formats, Formula Toolbox
- Form Controls for Interactive Excel Dashboards, Advanced Excel Chart Techniques
- KPI Dashboard - Scrolling Tables & Bars, Dynamic Headers, Top Bottom KPI Selection
- KPI Dashboard - Scrolling Lien chart, Final Product
- Excel VBA & Macro 101: Referencing Range, worksheets, & worksbooks with VBA
- Working with Variables, Looping through Collections & Making Decisions
- Uisng Build in Functions, Debuging & Error Handling
Projects You Will Work On
Excel Formulas
Pivot
Dashboard
VBA
Learning Pathways Post This Module
Post completion of the module, Students can opt for these following related modules to further their learning.
Digital Marketing
Master Digital Marketing Strategy coveringSocial Media Marketing, SEO, YouTube, Email, Facebook Marketing, Analytics & More!
Startup & Entrepreneurship
Everything you need to know about Lean Startup and Entrepreneurship strategies and how to deploy them to your business idea and project.
