Course Includes
- Recorded Lessons: 10
- Recorded Hours: 8
- Duration: 8 days (Avg)
Course Features
- Access on mobile
- TDP Assessment Test
- 3 Jobs Available
Top Skills Covered
Overview
Course Description
Excel Full Course - Course for learning Key skills for business
Stay home & Learn Excel through this online Excel course!
This is a unique Fun Excel Course where you play games, solve puzzles & learn Excel!!
Master Excel quickly in a fun way to open new career options or grow fast in your career.
We make learning Excel fun and exciting.
Learn how to use FULL power of MS Excel to achieve high performance & accuracy in your Job, grow fast in your career or Open new career paths
Faculty who has studied in IIM-Ahmedabad & NIT-Surat will be taking this course.
Master Excel quickly in a fun way to open new career options or grow fast in your career.
We do not offer the regular boring Excel training course. What we offer are puzzles and games.
Whether you are a beginner in Excel or an advanced Excel user, one thing is for sure: You are going to have fun solving these puzzles and playing these games!
You also learn Excel along the way!
Here is a Sample Puzzle
Who is the Real DarkLord? - Text & Date Functions
In Koramangala, Bangalore, the police caught a gang doing movie-piracy.
The police wanted to find out their leader, known by the nickname of DarkLord and quickly narrowed down the suspects.
The police reached out to you to help them crack these clues, as you are the Excel & Data Analysis expert in town.
You have to help the police in finding out the real DarkLord using your Excel skills!!
Are You Up For The Challenge?!
Here is what you'll learn in this Course:
• Learn and add a key business tool to your CV while solving puzzles & playing games
• How to Master Excel to become a key resource in your company
• Learn the full power of Excel, the most popular Business Insights & Data Analysis Tool and get an early lead in your career
• Impress your managers with attractive charts & dashboards. Get that salary raise that you want!
• Open new career options like Data Science, Digital Marketing or Financial Analysis using the full power of Excel
• Save time by Automating repetitive Tasks with Excel Macros
• Hands-on skills by solving fun Excel puzzles.
• Improve your Efficiency, Accuracy & Productivity
Feedback from Class X Student - Sivansh on 'Fun with Excel' Course
Here is the feedback about the "Fun with Excel" Course by one of the youngest participants.
Feedback from Sivansh (Student in Class 10th)
Sivansh is in Class 10th and completed 'Fun with Excel' Course. He enjoyed the unique way of teaching Excel by using fun puzzles and activities, where he learnt Basics of Excel and moved up to advanced topics like Macros, Pivot Tables, Conditional Formatting etc and much more!
The Microsoft Excel Training Course covers the following topics:
- Learn the essentials of Microsoft Excel
- Expertly navigate the Excel user interface
- Perform basic calculations with formulas and functions
- Professionally format spreadsheets and Conditional Formatting
- Create visualizations of data through charts and graphs
- Text and Date functions
- Logical Functions
- Working with Data (filtering, sorting etc.)
- Intermediate formulae
- Lookups (VLOOKUP , HLOOKUP )
- Data validation, Dropdown lists etc
- Advanced conditional formatting
- Pivot Tables
See you in the class soon!
Full Syllabus of the Course
1. Perform basic calculations with formulas and functions
a. Addition, Subtraction and other Mathematical functions
b. Min & Max functions
c. Absolute & Relative Cell reference
d. Basic IF statements
2. Text and Date (in text format) functions
a. Working with Text
b. Date functions
3. Logic & Conditional formulae
a. Logic functions (AND, OR etc.)
b. Conditional Functions - SUMIF / COUNTIF etc.
c. IFERROR
4. Lookups (Both)
a. VLOOKUP
b. HLOOKUP
5. Working with Data (filtering, sorting etc.)
a. Filtering
b. Sorting
6. Graphs & Charts
a. Different Types of Charts
b. Making charts practically
7. Data validation, Dropdown lists etc.
a. Validation of Data
b. Dropdowns
8. Pivot Tables
a. Create basic Pivot tables
b. Apply Filters
c. Auto-refresh
9. Professionally format spreadsheets
a. Basics of Formatting
b. Number Formatting
c. Date Formats
d. Tables
e. Conditional Formatting
More Course on Excel
Excel 2016 Essential Training Online Class
Latest EXCEL Course
What you'll learn
- Learn And Add Another Tool To Your Cv While Solving Puzzles & Playing Games
- Master Excel To Become A Key Resource In Your Company
- Learn The Full Power Of Excel, The Most Popular Business Insights & Data Analysis Tool And Get An Early Lead In Your Career
- Hands-On Practical Ms Excel Skills By Solving Fun Puzzles.
- Improve Your Efficiency, Accuracy & Productivity
- Impress Your Managers With Attractive Charts & Dashboards. Get That Salary Raise That You Want!
- Open New Career Options Like Data Science, Digital Marketing Or Financial Analysis Using The Full Power Of Excel
- Learn via Our Unique 'Fun With Excel' Course Which Makes Learning Fun & Exciting
- Save Time By Automating Repetitive Tasks With Excel Macros
Requirements
- New students can join the course as we start from the basics
- Basic familiarity with using computer
- Laptop/Desktop with MS Excel installed as it is a Hands-on practical Course
Course Content
10 Lessons | 8:00 Total hours
Perform basic calculations with formulas and functions
-
Basics of Excel _ Basic Mathematical Functions
00:38:35 -
More Mathematical Functions
00:56:31
Text and Date
-
Text _ Date Functions
00:50:28
Logic & Conditional formulas
-
Logic _ Conditional Functions
00:52:08
Lookups
-
Vlookup _ Hlookup
00:55:40
Working with Data
-
Working with Data - Sorting _ Filtering
00:38:51
Graphs & Charts
-
Charts _ Graphs
00:49:02
Data validation, Dropdown lists etc.
-
Data validation _ Dropdown lists
00:40:14
Pivot Tables
-
Last priority - Workshop - Basics of Pivot Tables
00:24:01
Professionally format spreadsheets
-
Basic Formatting, Tables _ Conditional Formatting
01:04:35
Frequently asked questions
What will I learn in the Course?
In this course, you'll learn essential Excel skills including data analysis, formulas, functions, data visualization, pivot tables, and automation techniques. The course is designed to enhance your efficiency in managing and analyzing business data.
Who is this course suitable for?
This course is ideal for beginners and intermediate users looking to improve their Excel skills for business applications. It's also beneficial for professionals who want to streamline their data management and analysis processes.
Do I need to have prior knowledge of Excel before taking this course?
No prior knowledge of Excel is required. The course starts with the basics and gradually progresses to more advanced topics, making it accessible for all skill levels.
Are there any practical exercises included in the course?
Yes, the course includes hands-on exercises, real-world scenarios, and projects that allow you to apply what you learn and reinforce your skills.
What key topics are covered in the course?
Excel fundamentals (navigation, formatting, and functions), Data entry and management, Formulas and functions (SUM, AVERAGE, VLOOKUP, etc.), Data analysis tools (PivotTables, data validation), Data visualization techniques (charts and graphs), Introduction to macros and automation