-
Section 1: Improving Productivity
7 Lessons-
StartDownload Resource File - Improving Productivity
-
StartReuse or copy formulas for fast turnaround
-
StartWrite smart, easy to copy formulas using absolute & relative referencing
-
StartReduce time & errors by writing Dynamic Array Formulas
-
StartRank data points using the RANK formula
-
StartAchieve more with less by writing mixed referencing formula
-
StartQuiz - Improving Productivity
-
-
Section 2: Taking Actions Based on Fulfilment of Conditions
8 Lessons-
StartDownload Resource File - Taking Actions Based on Fulfilment of Conditions
-
StartEvaluate Conditions using IF Statements
-
StartEvaluate Multiple Conditions Using Nested IF Statements + Bonus: Learn How to Evaluate Formulas?
-
StartManage Calculation Errors and Present Data without Errors
-
StartAdd Values on Fulfillment of Condition using the SUMIF Formula
-
StartAdd Values on Fulfillment of Multiple Conditions using the SUMIFS formula. BONUS: UNIQUE and TRANSPOSE
-
StartActions Based on Fulfillment of Conditions using Formulas such as COUNTIF, COUNTIFS, AVERAGEIFS, MAXIFS
-
StartQuiz - Taking Actions Based on Fulfilment of Conditions
-
-
Section 3: Managing Data
9 Lessons-
StartDownload Resource File - Managing Data
-
StartCreate Frequency Distribution using FREQUENCY and COUNTIFS Formulas
-
StartCreate a Range using MINIFS and MAXIFS Formula
-
StartMake Formula Writing Easy using Defined Names
-
StartMake Data Input Easy using Checkboxes
-
StartMake Data Input Easy using Lists or Dropdowns
-
StartMake Data Input Easy using Dependent Lists or Dropdowns
-
StartBONUS: Making Data Input Easy using Dependent Lists - Advanced Methods
-
StartQuiz - Managing Data in Excel
-
-
Section 4: Conducting Data Analysis
9 Lessons-
StartDownload Resource File - Conducting Data Analysis
-
StartExtracting Values from a Single Table or Range using VLOOKUP
-
StartExtracting Values From Related Tables/Ranges using Nested VLOOKUP
-
StartReturning Values from Ranges using VLOOKUP and Approximate Match
-
StartExtracting Values Based on Multiple Conditions using INDEX & MATCH
-
StartExtracting Values Based on Multiple Conditions using INDEX & XMATCH
-
StartExtending your reach while Extracting Data using XLOOKUP
-
StartBONUS: Write simpler and faster formulas with XLOOKUP and Format as Table option
-
StartQuiz - Conducting Data Analysis
-
-
Section 5: Data Analysis Using Pivot Tables
8 Lessons-
StartDownload Resource File - Data Analysis Using Pivot Tables
-
StartCreating Custom Pivot Tables
-
StartUsing Recommended Pivot Tables
-
StartDynamic Analysis Using Slicer
-
StartCreating Calculated Fields for Detailed Analysis
-
StartCustomize the View options in Pivot Tables
-
StartExtracting More Details from the Pivot Tables
-
StartQuiz - Data Analysis Using Pivot Tables
-
-
Section 6: Charts & Dashboards
9 Lessons-
StartDownload Resource File - Charts & Dashboards
-
StartCreate a Column Chart for a Single Data Series
-
StartCreate Different Types of charts for Multiple Data Series
-
StartDisplay Percentage in a Pie-Chart without calculating Percentage Data
-
StartDisplay Aggregate Information for Related Data using Stacked Charts
-
StartCreating People Graph
-
StartCreate Dynamic Dashboards with Pivot Charts
-
StartBONUS: Create a Progress Bar
-
StartQuiz - Charts & Dashboards
-
-
Section 7: Conditional Formatting
9 Lessons-
StartDownload Resource File - Conditional Formatting
-
StartHighlight Cells using In-built and Custom Formatting options
-
StartHighlight Top/Bottom Cells and Modifying Pre-defined Rules
-
StartHighlight Cells using Default and Customized Settings for Data Bars
-
StartHighlight Cells using Color Scales Option and Customize Formatting
-
StartHighlight Cells using Icon Sets Option and Customize Formatting
-
StartHighlight Cells based on Values of other Cells using Formulas
-
StartCreating a Gantt Chart using Conditional Formatting
-
StartQuiz - Conditional Formatting
-
-
Section 8: Working with Text
8 Lessons-
StartDownload Resource File - Working with Text
-
StartUsing CSV files with Excel and converting Text to Columns
-
StartCleaning up data using TRIM, UPPER, LOWER and PROPER
-
StartFinding Data within Text
-
StartReplacing Existing Text with a New Text
-
StartSplitting Text based on Spaces and other Characters
-
StartJoining Multiple Elements of Text Together
-
StartQuiz - Working with Text
-
-
Section 9: Estimation and Forecasting
7 Lessons-
StartDownload Resource File - Estimation and Forecasting
-
StartMaking Forecasts Based on Past Data using the Forecast Formula
-
StartMaking Forecasts for Multiple Months Using Forecast Sheet
-
StartMaking Estimates Using Goal Seek
-
StartEvaluate Projections Using Scenario Manager
-
StartCalculate Monthly Expenditure Matrix (EMI or PMT) for loan based on Interest & Duration
-
StartQuiz - Estimation and Forecasting
-
Unlock your confidence with our Excel Masterclass
This online Excel course will help you unlock the full power of Excel and get things done more quickly. We'll teach you amazing features like dynamic arrays, analysis techniques, and the new functionality of Excel 365.
Unlock your confidence with our
Excel Masterclass
This online Excel course will help you unlock the full power of Excel and get things done more quickly. We'll teach you amazing features like dynamic arrays, analysis techniques, and the new functionality of Excel 365.
Do you secretly wish you were better at using Excel?
Enroll in our course and become an expert at using Excel
Are you feeling overwhelmed by the complexity of Excel and wish you had the skills to make sense of numbers and data quickly? If so, then you’re not alone. Many people struggle with using Excel, but there is help available. Our Excel Masterclass, an online course with a certificate, can give you the skills and confidence to take on any Excel challenge.
With this course, you will learn how to analyze data and generate business insights using formulas, functions, create charts and graphs, and create interactive dashboards. With the right training and guidance, you can greatly improve your Excel skills in no time!
Do you secretly wish you were better at using Excel?
Enroll in our course and become an expert at using Excel
Are you feeling overwhelmed by the complexity of Excel and wish you had the skills to make sense of numbers and data quickly? If so, then you’re not alone. Many people struggle with using Excel, but there is help available. Our Excel Masterclass, an online course with a certificate, can give you the skills and confidence to take on any Excel challenge.
With this course, you will learn how to analyze data and generate business insights using formulas, functions, create charts and graphs, and create interactive dashboards. With the right training and guidance, you can greatly improve your Excel skills in no time!
How do we help you get better at Excel?
How do we help you get better at Excel?
Are you ready to be an Excel champion in two weeks?
01
Make Excel your sidekick
We'll show you how to use shortcuts, tricks, and hacks to make data analysis easier and more efficient. You'll learn different ways to reduce complexity from formulas. You'll be able to write complex formulas with confidence, and learn how to work with large datasets in no time.
02
Be an expert in no time
We’ve designed this course based on experiences gathered over 25 years. We'll introduce concepts in a step-by-step manner that'll let you master them with ease. With well-defined lessons, detailed explanations, quizzes and assignments, you’ll be a master at Excel soon!
Are you ready to be an Excel champion in two weeks?
01
Make Excel your sidekick
We'll show you how to use shortcuts, tricks, and hacks to make data analysis easier and more efficient. You'll learn different ways to reduce complexity from formulas. You'll be able to write complex formulas with confidence, and learn how to work with large datasets in no time.
02
Be an expert in no time
We’ve designed this course based on experiences gathered over 25 years. We'll introduce concepts in a step-by-step manner that'll let you master them with ease. With well-defined lessons, detailed explanations, quizzes and assignments, you’ll be a master at Excel soon!
Learn how to become a master at Excel with this comprehensive course. Get insights faster and reduce errors in your work, so you can save time and get more done quickly.
Learn how to become a master at Excel with this comprehensive course. Get insights faster and reduce errors in your work, so you can save time and get more done quickly.
03
Learn what's important
We believe it is more important to learn the right skills rather than learning everything about Excel. That's why our course focuses on teaching you the most important aspects of data analysis with Excel, so you can apply them at work quickly and easily.
04
Learn through business scenarios
Excel Masterclass, includes several business scenarios to help you better understand how to apply your knowledge in a professional setting. Through this course, you’ll be able to easily solve real-life problems by leveraging the power of Excel.
03
Learn what's important
We believe it is more important to learn the right skills rather than learning everything about Excel. That's why our course focuses on teaching you the most important aspects of data analysis with Excel, so you can apply them at work quickly and easily.
04
Learn through business scenarios
Excel Masterclass, includes several business scenarios to help you better understand how to apply your knowledge in a professional setting. Through this course, you’ll be able to easily solve real-life problems by leveraging the power of Excel.
Be the go-to person in your team for Excel. This course will help you be the analysis and insights expert in your team.
Be the go-to person in your team for Excel. This course will help you be the analysis and insights expert in your team.
05
Get access to expert guidance
Our expert instructors are always available for any help and guidance you might need during your journey towards mastering Excel. You can reach out to them for advice or solutions regarding any issue you face while learning.
06
Earn a certificate and a badge
On successful completion of this online excel course, you can earn a certificate along with an exclusive badge that showcases your knowledge of Excel on your resume/social media profiles, making sure that employers recognize your expertise in this field!
05
Get access to expert guidance
Our expert instructors are always available for any help and guidance you might need during your journey towards mastering Excel. You can reach out to them for advice or solutions regarding any issue you face while learning.
06
Earn a certificate and a badge
On successful completion of this online excel course, you can earn a certificate along with an exclusive badge that showcases your knowledge of Excel on your resume/social media profiles, making sure that employers recognize your expertise in this field!
Unlimited opportunities. Unlimited success.
Excel your way to success, just like they did.
Namrata Singh
HR Professional
Through this course, I have been able to reduce hours of unproductive checks.
Vibhuti Sharma
Sales Professional
Courses are comprehensive, relevant, easy pace (helps fit in busy schedule) and up to date
Anurag Kanoongo
Entrepreneur
Would personally recommend this course. These guys are exceptionally good with what they do!
Unlimited opportunities. Unlimited success.
Excel your way to success, just like they did.
Namrata Singh
HR Professional
Through this course, I have been able to reduce hours of unproductive checks.
Vibhuti Sharma
Sales Professional
Courses are comprehensive, relevant, easy pace (helps fit in busy schedule) and up to date
Anurag Kanoongo
Entrepreneur
Would personally recommend this course. These guys are exceptionally good with what they do!
Course Curriculum
Some questions that might help you
Some questions that might help you
Is this course based on the latest version of Excel?
Yes, this course is based on the EXCEL 365 version and covers new functions and methods like XLOOKUP, XMATCH, dynamic arrays, and more. These are specifically called out and the course also mentions how to use some of these features in earlier versions.
Is this course applicable for both Windows and Mac?
Yes. The course is applicable for both Windows and Mac. Differences (if any) are displayed on the screen for both Windows and Mac.
I am new to Excel. Will this course be overwhelming for me?
Not at all. The course is designed in a way, where complexity increases with each lecture and each section. We will first explain the basics and then bring in the complex part, thus making it simple for you to understand.
I work on Excel regularly. Will this course benefit me?
This course has been refined several times over the last 12 years. It includes concepts that most working professionals require. It is likely to contain many new concepts and faster alternatives that may be useful for you. Please check the curriculum for details.
If I have a query, will I get help?
Yes. We have added a discussion forum to each lesson. In case you have a query, please use the forum to ask your question. One of our experts will respond to your query. In case you opt for the personal coaching plan, then you will have access to two live sessions (virtual) of one-on-one guidance.
Can I watch these lessons at my own pace?
Yes. You can watch these lessons at your convenience, as many times as you want.
What is the course language?
English
Why does this course follow a business scenario approach?
There are close to 25 business scenarios that are explained in this course. This approach makes it easy for you to relate your day-to-day work to these scenarios. Additionally, this approach makes it easy for you to learn and remember.
Will my assignment be reviewed? Will I receive feedback?
Yes. Your assignment will be reviewed by one of our experts and you will receive personalized feedback.
Will I get a certificate for completing the course?
Yes. Once your assignment is approved, you will receive a certificate, along with a link to add it as a credential on your LinkedIn profile.
Will I get a badge for completing the course?
Yes. We issue three badges for Excel - Intermediate, Advanced, and Expert. You will receive an Advanced badge after your assignment is approved. In case you have completed more courses with us, your badge may be upgraded to an Expert level.
Will this course be updated with new lessons? Will I be required to pay more to access those?
The course may be updated with new lessons. Any additional lessons added to the course will be on us and you will not be required to pay an additional fee to access those.
Can I get this course for my team members? Do you work with corporates?
Yes absolutely. Many organizations take this course for their employees. We can even provide you a GST bill (for India). Feel free to write to us at info@qling.net and we will respond to you.
I want to talk to you, before I make the purchase. Is it possible?
Yes absolutely. Write to us at info@qling.net with your queries and we will setup a call with you.
Can I start with a self-paced plan now and upgrade to personal coaching plan later?
Yes absolutely. You can start with the self-paced plan and when you feel the need for the personal coaching, just write to us at info@qling.net and we will help you.
Get access to the course
Excel is an essential skill for success at the workplace. Low confidence in using Excel can limit the opportunities you receive and therefore affect your progress.
The good news is, it is possible to develop this skill with the right guidance.
If you are keen on being better at Excel, and looking for an online course where you can have live interactions with an expert* for your queries, then Excel Masterclass is the right choice for you.
Come join other ambitious professionals around the world and invest in your career.
* Available with the personal coaching plan
Excel Masterclass
All you need to know about Excel - A course for the busy Professional!
Get access to the course
Excel is an essential skill for success at the workplace. Low confidence in using Excel can limit the opportunities you receive and therefore affect your progress.
The good news is, it is possible to develop this skill with the right guidance.
If you are keen on being better at Excel, and looking for an online course where you can have live interactions with an expert* for your queries, then Excel Masterclass is the right choice for you.
Come join other ambitious professionals around the world and invest in your career.
* Available with the personal coaching plan
Excel Masterclass
All you need to know about Excel - A course for the busy Professional!
Music Credit: bensound.com
