Best Excel Analytics Courses

Find the best online Excel Analytics Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Excel Analytics Courses.

Microsoft Excel Masterclass for Business Managers

Microsoft Excel for Business - Excel Formulas and Functions, Excel Charts, Excel Analytics, Shortcuts & Excel Macros

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 257260, Price: $29.99

Students: 257260, Price:  Paid

7 Reasons why you should choose this Excel course

  1. Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment

  2. Concise - you can complete this Microsoft Excel course within one weekend

  3. Business related examples, data analysis and case studies solved using Advanced Excel.

  4. You will learn various data analysis techniques using MS Excel

  5. Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice

  6. Downloadable resources comprising important MS Excel techniques and functionalities

  7. Your queries will be responded by the Instructor himself

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this MS Excel course.

Why should you choose this course?

This is a complete and concise tutorial on MS Excel which can be completed within 6 hours. This course will help you learn advanced Excel and various data analysis tools associated with Microsoft excel. We know that your time is important and hence we have created this fast paced MS Excel course without wasting time on irrelevant Excel operations.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced MS Excel and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content on basic Excel features, or advanced Excel functions or maybe on data analysis tools; practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Assignments are aimed at enhancing your skillsets on Microsoft Excel at an advanced level and at analysing data. Solution to Assignment is also shared so that you can review your performance.

What is covered in this course?

This course covers everything you need to crack advanced MS Excel in the professional work place.

Below are the Excel course contents of this complete and concise course on Microsoft Excel:

  • Introduction - In this video, the structure and contents of the course are discussed.

  • Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

  • Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

  • Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

  • Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

  • Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

  • Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)

  • Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.

  • Pivot Tables - This Excel lecture covers Pivot tables end-to-end.

  • Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines

  • Excel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.

  • Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)

  • Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.

  • Bonus Lectures - Waterfall chart in Excel 2016 and previous versions of Excel, Infographics 1: Cool charts, Infographics 2: Cool charts

  • And so much more!

By the end of this course, your confidence in using MS Excel will soar. You will learn how Microsoft Excel can play a pivotal role in data analysis and related field. You'll also have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ's

Why learn Microsoft Excel?

1. Microsoft Excel helps solve Business Problems

2. MS Excel has some extremely relevant and important data analysis tools.

3. Advanced MS Excel will give you an edge over other candidates in the competitive environment in schools, colleges or workplaces.

4. Microsoft Excel helps you get stuff done

5. Microsoft Excel will make you better at your job (no matter what that is)

6. Microsoft Excel know-how can instantly increase your job prospects as well as your starting salary

How much time does it take to learn Microsoft Excel?

Microsoft Excel is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Microsoft Excel quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn Microsoft Excel quickly.

What are the steps I should follow to learn Microsoft Excel?

1. Start learning from the basics of Microsoft Excel. The first 3 sections of the course cover the basics.

2. Once done with the basic try your hands on advanced MS Excel. Next 7 sections cover Advanced Excel topics

3. Next section will help you some cool new tricks of Microsoft Excel.

4. Practice your learning on the exercise provided with every lecture.

What is the difference between basic and advanced level of Excel?

At Basic level of MS Excel a person

  1. Can build excel formulas using: SUM, IF, AVERAGE, COUNT, ROUND

  2. Is comfortable building excel formulas to manipulate text and dates

  3. Understands and can use the Filter and Sort feature of Microsoft Excel.

  4. Can create basic charts like Line chart, bar chart and pie chart

At Advanced level of MS Excel a person

  1. Can implement Excel LOOKUP Formulas like VLOOKUP, HLOOKUP, Index and Match

  2. Can use conditional and logical formulas like IF, SUMIF, COUNTIF, OR, AND etc.

  3. Knows what a Pivot Table is and how to build one.

  4. Knows what an add-in is and how to install one.

  5. Can record a macro and use it later.

  6. Can successfully edit/modify simple recorded macros.

  7. Can create advanced charts like Waterfall chart and overlay chart in Microsoft Excel

  8. Can create solve analytics problem using excel solver.

Start working proficiently on Microsoft Excel and increase your office productivity.

The Authors of this Microsoft Excel course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of advanced MS Excel in today's corporate world.

Marketing Analytics: Forecasting Models with Excel

Master Marketing Analytics| Forecasting and Time Series analysis | Sales Forecasting| Build Forecasting models in Excel

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 110428, Price: $29.99

Students: 110428, Price:  Paid

You're looking for a complete course on understanding Forecasting models and forecasting analytics to drive business decisions involving production schedules, inventory management, manpower planning, demand forecasting, and many other parts of the business., right?

You've found the right Marketing Analytics: Forecasting Models with Excel! This course teaches you everything you need to know about different forecasting models and how to implement these models for devising forecasting analytics in Excel using advanced excel tool.

After completing this course you will be able to:

  • Implement forecasting analytics and forecasting models such as simple linear, simple multiple regression, Ratio to Moving Average, Winter's method for exponential smoothing with trend and seasonality, famous Bass diffusion model and many more.

  • Increase revenue/profit of your firm by implementing accurate forecasting analytics using Excel solver Add-in

  • Confidently practice, discuss and understand different Forecasting analytics strategies and forecasting models used by organizations

  • Creating demand forecasting strategies using forecasting analytics techniques and various forecasting models.

How this course will help you?

A Verifiable Certificate of Completion is presented to all students who undertake this Marketing Analytics: Forecasting Models with Excel course.

If you are a business manager or an executive, or a student who wants to learn and apply forecasting analytics and forecasting models in real world problems of business, this course will give you a solid base by teaching you the most popular forecasting models and how to implement it for effective demand forecasting and for devising forecasting analytics techniques.

Why should you choose this course?

We believe in teaching by example. This course is no exception. Every Section’s primary focus is to teach you the concepts on forecasting analytics, demand forecasting, forecasting models through how-to examples. Each section has the following components:

  • Theoretical concepts and use cases of different forecasting models and forecasting analytics techniques

  • Step-by-step instructions on implement forecasting models and forecasting analytics techniques in excel for demand forecasting

  • Downloadable Excel file containing data and solutions used in each lecture on forecasting models and forecasting analytics

  • Class notes and assignments to revise and practice the concepts on demand forecasting, forecasting models and forecasting analytics techniques

The practical classes where we create the model for each of these strategies is something which differentiates this course from any other course available online.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. As managers in Global Analytics Consulting firm, we have helped businesses solve their business problem using Analytics and we have used our experience to include the practical aspects of Marketing and data analytics in this course

We are also the creators of some of the most popular online courses - with over 170,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there are class notes attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning.

What is covered in this course?

Understanding how future sales will change is one of the key information needed by manager to take data driven decisions. In this course, we will explore how one can use forecasting models to

  • See patterns in time series data

  • Make forecasts based on models

Let me give you a brief overview of the course

  • Section 1 - Introduction

In this section we will learn about the course structure

  • Section 2 - Basics of Forecasting

In this section, we will discuss about the basic of forecasting and we will also learn the easiest way to create simple linear regression model in Excel

  • Section 3 - Getting Data Ready for Regression Model

In this section you will learn what actions you need to take a step by step to get the data and then prepare it for the analysis these steps are very important.

We start with understanding the importance of business knowledge then we will see how to do data exploration. We learn how to do uni-variate analysis and bi-variate analysis then we cover topics like outlier treatment and missing value imputation.

  • Section 4 - Forecasting using Regression Model

This section starts with simple linear regression and then covers multiple linear regression.We have covered the basic theory behind each concept without getting too mathematical about it so that you understand where the concept is coming from and how it is important. But even if you don't understand it, it will be okay as long as you learn how to run and interpret the result as taught in the practical lectures.

We also look at how to quantify models accuracy, what is the meaning of F statistic, how categorical variables in the independent variables dataset are interpreted in the results.

  • Section 5 - Handling Special events like Holiday sales

In this section we will learn how to incorporate effects of Day of Week Effect, Month Effect or any special event such Holidays, pay day etc.

  • Section 6 - Identifying Seasonality & Trend for Forecasting

In this section we will learn about trends and seasonality and how to use the Solver to develop an additive or multiplicative model to estimate trends and seasonality. We will also learn how to use moving averages to eliminate seasonality to easily see trends in sales.

  • Section 7 - Handling Changing Trend & Seasonality over time

In this section we will learn about Winter’s Method that changes trend and seasonal index estimates during each period has a better chance of keeping up with changes than other methods.

  • Section 8 - Forecasting models for New Products

In this section we will learn techniques to forecast new product sales. It is difficult to forecast when we have little or no historical data. The S curve can be used when we have little data and the famous bass diffusion model can be used to predict product sales even before the product is launched in the market.

Some of the examples in this course are from the book Marketing Analytics: Data-Driven Techniques with Microsoft Excel [Winston, Wayne L.]. We suggest this book as reading material for anyone aspiring to be a marketing analyst.

I am pretty confident that the course will give you the necessary knowledge and skills related to forecasting analytics, forecasting models and demand forecasting strategies; to immediately see practical benefits in your work place.

Go ahead and click the enroll button, and I'll see you in lesson 1 of this course on forecasting analytics and forecasting models!

Cheers

Start-Tech Academy

Data Analytics with Excel PivotTables

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples

Created by Navya Kannan - Software Asset Management Specialist

"]

Students: 90244, Price: $19.99

Students: 90244, Price:  Paid

About this course

This course will teach you how to do Data analytics with Excel PivotTables. With the help of this course, you will understand the concept, various scenarios, and types of Business analytics. Along with that, you will learn, how to use one of the strongest features of Microsoft Excel, which is the PivotTables

Target audience

Anyone with no knowledge to a basic knowledge of Microsoft Excel can take this course and get a thorough understanding of Excel PivotTables. 

Course Structure

In this short but effective course, you will understand why Data analytics is very important in today's business to make an effective business decision, and how Excel can help you with this. 

This course takes you through the details of Data analytics and with various examples, helps you understand various aspects where Data analytics plays a vital role. Then you will learn, how you can exploit the power of Excel PivotTable to make your data visually more appealing and easier to analyze. With a step by step guide and examples, this course is easy to comprehend and learn. 

 

Excel Analytics: Linear Regression Analysis in MS Excel

Linear Regression analysis in Excel. Analytics in Excel includes regression analysis, Goal seek and What-if analysis

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 77827, Price: $19.99

Students: 77827, Price:  Paid

You're looking for a complete Linear Regression course that teaches you everything you need to create a Linear Regression model in Excel, right?

You've found the right Linear Regression course!

After completing this course you will be able to:

· Identify the business problem which can be solved using linear regression technique of Machine Learning.

· Create a linear regression model in Excel and analyze its result.

· Confidently practice, discuss and understand Machine Learning concepts

How this course will help you?

A Verifiable Certificate of Completion is presented to all students who undertake this Machine learning basics course.

If you are a business manager or an executive, or a student who wants to learn and apply machine learning in Real world problems of business, this course will give you a solid base for that by teaching you the most popular technique of machine learning, which is Linear Regression

Why should you choose this course?

This course covers all the steps that one should take while solving a business problem through linear regression.

Most courses only focus on teaching how to run the analysis but we believe that what happens before and after running analysis is even more important i.e. before running analysis it is very important that you have the right data and do some pre-processing on it. And after running analysis, you should be able to judge how good your model is and interpret the results to actually be able to help your business.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. As managers in Global Analytics Consulting firm, we have helped businesses solve their business problem using machine learning techniques and we have used our experience to include the practical aspects of data analysis in this course

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there are class notes attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning.

What is covered in this course?

This course teaches you all the steps of creating a Linear Regression model, which is the most popular Machine Learning model, to solve business problems.

Below are the course contents of this course on Linear Regression:

· Section 1 - Basics of Statistics

This section is divided into five different lectures starting from types of data then types of statistics

then graphical representations to describe the data and then a lecture on measures of center like mean

median and mode and lastly measures of dispersion like range and standard deviation

· Section 2 - Data Preprocessing

In this section you will learn what actions you need to take a step by step to get the data and then

prepare it for the analysis these steps are very important.

We start with understanding the importance of business knowledge then we will see how to do data exploration. We learn how to do uni-variate analysis and bi-variate analysis then we cover topics like outlier treatment, missing value imputation, variable transformation and correlation.

· Section 3 - Regression Model

This section starts with simple linear regression and then covers multiple linear regression.

We have covered the basic theory behind each concept without getting too mathematical about it so that you

understand where the concept is coming from and how it is important. But even if you don't understand

it, it will be okay as long as you learn how to run and interpret the result as taught in the practical lectures.

We also look at how to quantify models accuracy, what is the meaning of F statistic, how categorical variables in the independent variables dataset are interpreted in the results, what are other variations to the ordinary least squared method and how do we finally interpret the result to find out the answer to a business problem.

By the end of this course, your confidence in creating a regression model in R will soar. You'll have a thorough understanding of how to use regression modelling to create predictive models and solve business problems.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

------------

Below is a list of popular FAQs of students who want to start their Machine learning journey-

What is Machine Learning?

Machine Learning is a field of computer science which gives the computer the ability to learn without being explicitly programmed. It is a branch of artificial intelligence based on the idea that systems can learn from data, identify patterns and make decisions with minimal human intervention.

What is the Linear regression technique of Machine learning?

Linear Regression is a simple machine learning model for regression problems, i.e., when the target variable is a real value.

Linear regression is a linear model, e.g. a model that assumes a linear relationship between the input variables (x) and the single output variable (y). More specifically, that y can be calculated from a linear combination of the input variables (x).

When there is a single input variable (x), the method is referred to as simple linear regression.

When there are multiple input variables, the method is known as multiple linear regression.

Why learn Linear regression technique of Machine learning?

There are four reasons to learn Linear regression technique of Machine learning:

1. Linear Regression is the most popular machine learning technique

2. Linear Regression has fairly good prediction accuracy

3. Linear Regression is simple to implement and easy to interpret

4. It gives you a firm base to start learning other advanced techniques of Machine Learning

How much time does it take to learn Linear regression technique of machine learning?

Linear Regression is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Linear regression starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to remember whatever you have learnt. Therefore, we have also provided you with another data set to work on as a separate project of Linear regression.

What are the steps I should follow to be able to build a Machine Learning model?

You can divide your learning process into 4 parts:

Statistics and Probability - Implementing Machine learning techniques require basic knowledge of Statistics and probability concepts. Second section of the course covers this part.

Understanding of Machine learning - Fourth section helps you understand the terms and concepts associated with Machine learning and gives you the steps to be followed to build a machine learning model

Programming Experience - A significant part of machine learning is programming. Python and R clearly stand out to be the leaders in the recent days. Third section will help you set up the R environment and teach you some basic operations. In later sections there is a video on how to implement each concept taught in theory lecture in R

Understanding of Linear Regression modelling - Having a good knowledge of Linear Regression gives you a solid understanding of how machine learning works. Even though Linear regression is the simplest technique of Machine learning, it is still the most popular one with fairly good prediction ability. Fifth and sixth section cover Linear regression topic end-to-end and with each theory lecture comes a corresponding practical lecture in R where we actually run each query with you.

HR Analytics using MS Excel for Human Resource Management

Use Excel for HR Analytics, calculate HR metrics, build HR dashboards & ML models for Human Resource & People Analytics

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 68148, Price: $29.99

Students: 68148, Price:  Paid

You're looking for a complete course on understanding HR Analytics using Excel to drive business decisions, right?

You've found the right HR Analytics using MS Excel course! HR analytics provides scientific support to decision-making concerning a firm's human resources. This course on HR analytics addresses the topic of HR analytics with a practical focus, focusing especially on demystifying analytics for Human Resource managers, from both statistical and computing point of view.

After completing this course you will be able to:

  • Use MS Excel to create and automate the calculation of HR metrics and devise HR analytics techniques in your workplace

  • Make HR Dashboards as per HR analytics standards and understand all the charts that you can draw in Excel

  • Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real-world HR problems using HR analytics techniques

  • Use HR analytics tools like pivot tables filtering and sorting options in Excel to summarize and derive information out of the available HR data

  • create appealing data summaries and dashboards to present the HR story in the most effective way

How this course will help you?

A Verifiable Certificate of Completion is presented to all students who undertake this HR Analytics: Strategies & Models in Excel course.

If you are a Human Resources manager or an executive, or a student who wants to learn and apply HR analytics techniques to real-world problems of the HR business function, this course will give you a solid base for that by teaching you the most popular HR analytics models and how to implement HR analytics in MS Excel.

Why should you choose this course?

We believe in teaching by example. This course is no exception. Every Section’s primary focus is to teach you the concepts through how-to examples. Each section has the following components:

  • Theoretical concepts and use cases of different HR analytics models

  • Step-by-step instructions on implementing HR analytics models in excel

  • Downloadable Excel files containing data and solutions used in each lecture on HR analytics and Human Resource Management

  • Class notes and assignments to revise and practice the concepts on HR analytics and Human Resource Management

The practical classes where we create the model for each of these strategies is something that differentiates this course from any other course available online.

What makes us qualified to teach you?

The course is taught by Abhishek (MBA - FMS Delhi, B.Tech - IIT Roorkee) and Pukhraj (MBA - IIM Ahmedabad, B.Tech - IIT Roorkee). As managers in the Global Analytics Consulting firm, we have helped businesses solve their business problem using Analytics and we have used our experience to include the practical aspects of HR analytics in this course.

We are also the creators of some of the most popular online courses - with over 600,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, HR analytics tools, human resource management, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there are class notes attached for you to follow along. You can also take quizzes to check your understanding of concepts on HR analytics and human resource management. Each section contains a practice assignment for you to practically implement your learning on HR analytics and human resource management.

What is covered in this course?

The analysis of data is not the main crux of analytics. It is the interpretation that helps provide insights after the application of analytical techniques that makes analytics such an important discipline. We have used the most popular analytics software tool which is MS Excel. This will aid the students who have no prior coding background to learn and implement HR analytics concepts to actually solve real-world HR problems.

Let me give you a brief overview of the course

  • Part 1 - Introduction

    In this section, we will learn about the course structure and the meaning of some key terms associated with HR Analytics.

  • Part 2 - Essential MS Excel formulas and using them to calculate HR metrics

    In this part, we will start with a tutorial on all the popular MS Excel formulas. Then we will see the implementation of these to calculate and automate the HR metrics. This is an important part of HR analytics of a human resource dataset. We also discuss a separate case study where we use Excel to calculate the average cost of external and internal hiring.

  • Part 3 - Visualization in Excel and HR Dashboarding

    In this part, we will begin with a tutorial on all the popular charts and graphs that can be drawn in MS Excel. Then we will see the implementation of these to create visualize HR analytics of the available HR data. We also discuss a separate case study where we use Excel to build a department-wise demographic distribution of human resources.

  • Part 4 - Data summarization using Pivot tables

    In this part, we will learn about several advanced topics in MS Excel such as Pivot tables, indirect functions, and also about data formatting. Then we will see the implementation of these to create beautiful summaries of HR analytics of the available HR data. We also discuss a separate case study where we use Excel to build a dynamic department wise demographic dashboard and format it to make it presentable.

  • Part 5 - Basics of Machine Learning and Statistics

    In this part, we introduce the students to the basics of statistics and ML. This part is for students who have no background understanding of ML and statistics concepts.

  • Part 6 - Preprocessing Data for ML models

    In this section, you will learn what actions you need to take step by step to get the data and then prepare it for analysis these steps are very important. We start with understanding the importance of business knowledge then we will see how to do data exploration. We learn how to do uni-variate analysis and bivariate analysis then we cover topics like outlier treatment, missing value imputation, variable transformation, and correlation.

  • Part 7 - Linear regression model for predicting metrics

    This section starts with a simple linear regression and then covers multiple linear regression.

We have covered the basic theory behind each concept without getting too mathematical about it so that you understand where the concept is coming from and how it is important. But even if you don't understand it, it will be okay as long as you learn how to run and interpret the result as taught in the practical lectures.

We also look discuss an HR case study where we try to predict the CTC to be offered to new recruits basis their previous experience, past CTC, job location, and qualification.

I am pretty confident that the course will give you the necessary knowledge and skills related to HR analytics and human resource management to immediately see practical benefits in your workplace.

Go ahead and click the enroll button, and I'll see you in lesson 1 of this HR analytics course!

Cheers

Start-Tech Academy

Excel Data Analysis Masterclass with Excel Dashboards

Master Advanced MS Excel topics - Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics

Created by Data Is Good Academy - An Google, Facebook, Kaggle Grandmasters team

"]

Students: 19838, Price: $19.99

Students: 19838, Price:  Paid

Welcome to the best online course on Excel.

Microsoft Excel is one of the most used software applications of all time.

Hundreds of millions of people around the world use Excel.

It is a very handy software that can be used to store and organize many datasets.

Using its features and formulas, one can use the tool to make send of the data.

This course provides you functionalities of excel used by data scientists and data analysts along with its basics.

You will learn to create interactive dashboards using excel.

In this course, you will cover:-

  • Basic formatting in excel

  • Datatypes of excel

  • Insertion and deletion of new rows and columns in excel.

  • Sorting and filtering data in excel

  • Learn about the different text functions- UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, TRIM, CONCATENATE, LEN

  • Learn about the different statistical functions- MIN, MAX, AVERAGE.

  • Finding different percentiles.

  • Finding missing values in data

  • Finding outliers in data

  • Learn about the different logical functions- IF, IFERROR, COUNTIF, SUMIF, AVERAGEIF.

  • Learn about conditional formatting.

  • Learn about lookup functions- VLOOKUP, HLOOKUP.

  • Learn about index and match

  • Learn to create pivot tables and pivot charts.

  • Learn to create interactive dashboards.

  • Learn about What-if Analysis:- Goal Seek analysis, Data Tables, Scenario Management.

  • Learn about performing linear regression in excel.

  • Advanced Filtering

Not only this, you will get to practice a lot of exercises on these topics.

We are also providing quizzes.

You will also have access to all the resources used in this course.

Instructor Support - Quick Instructor Support for any queries.

I'm looking forward to see you in the course!

Enroll now and make the best use of this course.

Microsoft Excel Data Analysis – Learn How The Experts Use It

Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts.

Created by New Horizon - An industry leading training provider for 2 decades!

"]

Students: 15847, Price: $99.99

Students: 15847, Price:  Paid

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analyst in the organization. And will lead to a much greater opportunities for you.

Excel is the number-one spreadsheet application, with a plethora of capabilities. If you're only using the basic features, you're missing out on a host of features that can benefit your business by uncovering important information hidden within raw data. This Excel Data Analysis course allows you to harness the full power of Excel to do all the heavy lifting for you.

The course, comprised of 3+ hours of video training, guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.

Excel Data Analytics With Pivot Tables & Pivot Charts – 2021

Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data Analytics, Excel, Data

Created by A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office) - 200,000+ Students | 4+ Rated | 190 + Countries

"]

Students: 6329, Price: $19.99

Students: 6329, Price:  Paid

Eight Reasons why you should choose this Excel Data Analytics With  Tables and Pivot Charts Course

  1. You will learn various data analysis techniques using MS Excel

  2. Latest updated and Doubts Are Solved in this course

  3. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  4. you can complete this course In Short time

  5. Pivot table & Pivot charts related examples and case studies Provided

  6. Practical Examples And practice exercises Are Able to Download in The Recourse Section

  7. Your queries will be responded by the Instructor With In Short time

  8. A Verifiable Certificate will Be Provided On the Completion

Excel Pivot Tables & Pivot Charts are an absolutely Fundamental tool for anyone working with data in Excel. Pivots Table allow you to quickly explore and analyze raw data in Excel. It is powerful tools to analyze Excel Data in Different perspective. Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep & comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you how to use Excel Pivot Tables & Pivot charts and introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way. After Completing This Course Your Are Able To Create Interactive & Visually Effective Pivot Charts Based On Your Pivot Table.

What is covered in this course?

Chapter -01 Introduction Of Data Analytics With Pivot Tables & Charts

  • Introduction Of Data Analytics

  • Introduction Of Pivot Table And Pivot Charts

Chapter -02 The Five Steps For Data Analytics With Pivot Tables And Charts

  • The Five Steps For Data Analytics With Pivot Table And Pivot Charts

  • Chapter -03 Pivot Table & Pivot Chart Example -01

  • Data Analytics With Pivot Table & Pivot Chart Example-01

Chapter -03 Data Analytics With Pivot tables & Pivot Charts Example -01

  • Introduction Of Data Analytics With Pivot tables & Pivot Charts Example -01

Chapter -04 Format The Raw Data For Pivot Tables (Step 01)

  • Format The Raw Data For Pivot Tables

  • Insert New Column

Chapter -05 Convert The Raw Data To Table (Step 02)

  • Create Pivot Table By Using Range

  • Convert Raw Data To Table

  • Modify The Table

Chapter -06 Create Pivot Tables (Step-03)

  • Create Pivot Table

  • Create Recommended Pivot Table

  • Change Pivot Table Name & Design

  • Pivot Table Builder & Clear & Rearrange

  • Copy , Move And Delete The Pivot Table.

  • Creating Groups In Pivot Table – Date Group

  • Creating Groups In Pivot Table – Number Group

  • Custom Calculation In Pivot Table.

  • Sorting , Filtering In Pivot Table.

  • Working With Slicer.

  • Update The Data In Pivot Table.

Chapter -07 Create Pivot Charts (Step-04)

  • Create Pivot Table For Pivot Chart

  • Create Line Charts.

  • Create Bar Charts.

  • Create Column Charts.

  • Create Pie Charts.

  • Insert Slicers & Connect With Reports

Chapter -08 Analysis The Pivot Table & Pivot Charts (Step-05)

  • Analysis The Pivot Table & Pivot Charts

Chapter -09 Pivot Table & Pivot Chart Example-02

  • Introduction Of Question

  • Answer Question 1 & 2

  • Answer Question 3

  • Answer Question 4 & 5 & 6

  • Answer Question 7

  • Answer Question 8

Ultimate Master Course for Excel Dashboard Analytics

Learn Data Analytics, build interactive Dashboards and Automate your data reports in just 6 hours!

Created by Ultimate Masters Academy - Maximizing Students' Learning in the Shortest Time.

"]

Students: 5897, Price: $19.99

Students: 5897, Price:  Paid

The Ultimate Master Course for Microsoft Excel:
Learn Data Analytics, build interactive Dashboards and Automate your data reports.
Go from an Entry Beginner to a Super Pro Expert in just 6 hours!

This Microsoft Excel course combines 4 different courses.

Beginner Series
Students will get familiarized with Excel's system interface and learn the important functions of Excel how to handle and format data across multiple data worksheets.

Intermediate Series
Students will learn to use Pivot Tables in their data analysis for summarization, sorting, filtering, reorganizing and cluster-grouping, as well as formatting techniques for enhanced data visualization.

Professional Series
Students will learn about Pivot Charts and advanced Data Charting Visualization techniques to create Professional charts for high-impact data analysis reports and presentations.

SUPER PRO Series
Students will learn my expert Excel Shortcut techniques to be 500% faster in handling large data sets and also learn how to create interactive Dashboards and use VBA Macro to automate the data reports.

(Video Lessons were recorded with Excel 2016 and 2019 but works in 2008, 2010, 2013 (Office 365)]
Concepts and Features are applicable across all versions of Excel on both Mac and Windows.

*******************************************************************************************

Recent Student Review:

"The Ultimate Master Excel Dashboard Analytics course was way too good for how much it was selling! Can't believe I learnt all those awesome Excel tricks in just 6 hours! Can't wait to show my friends and colleagues what I can do now! - Felicia

"This Instructor is definitely the best Excel Instructor I've seen so far! Super-skilled and knowledgeable in Excel and Dashboard data analytics. Really wished I took this course earlier before I joined the work force. Would have helped me so much in my professional career if I knew earlier how to build these impressive dashboards!" - Derrick Y.

*******************************************************************************************

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step-by-step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses, you will master Data Spreadsheet Analysis, learn advanced Data Visualization techniques, and be able to to build high-impact Interactive Dashboards and automate your Data Analysis Reports.

You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and more advanced level topics.

Upon course completion, you will come out with sheer confidence to handle any data analysis work with efficiency and grace.

*******************************************************************************************
So, what are you waiting for, enroll now and take the next step in mastering Excel!
Go from an Entry Beginner to a Super Pro Expert in just 6 hours!

Disclaimer:

Individual results on learning outcome will always vary and yours will depend entirely on your individual capacity, work ethics, business skills and experience, diligence in applying the techniques learnt throughout this course, level of personal motivation and other factors.

Mastering Data Analysis in Excel

Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level

Created by Vardges Zardaryan - Data Analyst, Analytics Instructor

"]

Students: 5685, Price: $44.99

Students: 5685, Price:  Paid

5 hours of professional course for everyone who wants to learn essentials of data analysis and visualization in Excel and become an Advanced Excel User. Join to over 5,000 students and unlock the power of Excel to utilize its analytical tools — no matter your experience level. Master advanced Excel formulas and tools from Vlookup to Pivot Tables, create graphs and visualizations that can summarize critical business insights, and utilize Data Analysis ToolPak for descriptive and regression analysis. Gain a competitive advantage in the job market.

WHY WOULD YOU CHOOSE TO LEARN EXCEL?

Excel is one of the most widely used solutions for analyzing and visualizing data. Excel in itself can do so much for your career. It's just one program but it's the one hiring managers are interested in. Advanced Microsoft Excel skills can get you a promotion and make you a rock star at your company.

WHY TAKE THIS SPECIFIC EXCEL COURSE?

This course is concentrated on the most important tools for performing data analysis on the job. In this course you'll play the role of data analyst at a delivery company and you'll be working with real-life data sets. You don't need to spend weeks and months to learn Excel. As you go through the course, you'll be able to apply what you learnt immediately to your job.

Author of this course has over 10 years of working experience in large financial organizations and over 5 years of experience of online and in-person trainings. He has dozens of courses on Excel, SQL, Power BI, Access, and more than 20,000 students in total. Surely he knows what you need.

HERE WHY THIS COURSE IS ONE OF THE BEST COURSES ON UDEMY:

★★★★★ Rashed Al Naamani

Probably this is one of the best course I have done for Excel ...instructor pace is very good and clearly explain each tool in details. Thumbs up?

★★★★★ Sonika Sharma

EXCELLENT WORK!! REAL EXPERIENCE WITH REAL DATA SIMULTANEOUSLY WHILE LEARNING. GREAT!!! GREAT!!! GREAT!!!! GREAT!!!

★★★★★ Vardan Danielyan

Very detailed, extremely well explained, useful information and tricks. Excel is great for organizing and presenting data, and this course has everything you might need to work with Excel, and learn all nuances. Totally recommend!

★★★★★ Urs Fehr

The structure of this course is very well done with high quality information, and rounded off with how to put the theory into practice with practical examples. This instructor has gone onto my favorites list. Thanks a lot.

WHAT ARE SOME EXCEL TOOLS AND FUNCTIONS YOU WILL LEARN IN THIS COURSE?

You'll learn:

· How to clean and prepare data by Sort, Filter, Find, Replace, Remove Duplicates, and Text to Columns tools.

· How to use drop-down lists in Excel and add Data Validation to the cells.

· How to best navigate large data and large spreadsheets.

· How to Protect your Excel files and worksheets properly.

· The most useful Excel functions like SUBTOTAL, SUMIF, COUNTIF, IF, OR, PMT, RATE, MEDIAN and many more.

· How to write advanced Excel formulas by VLOOKUP, INDEX, MATCH functions.

· How to convert raw Excel data into information you can use to create reports on.

· Excel Pivot Tables so you can quickly get insights from your data.

· Excel charts that go beyond Column and Bar charts. You'll learn how to create Combo charts, Histogram, Scatter Plot, Speedometer charts and more.

· How to create interactive dashboards in Excel by using Slicer and Pivot Charts.

· How to activate and use Data Analysis ToolPak for advanced statistical analysis.

· Work in Excel faster by using hot key shortcuts.

· Make homework and solve quizzes along the way to test your new Excel skills.

WHAT ABOUT CERTIFICATE? DO YOU PROVIDE A CERTIFICATE?

Upon completion of the course, you will be able to download a Certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.

So, what are you waiting for? Join today and get immediate, lifetime access to the following:

· 5+ hours on-demand video

· Downloadable project files

· Practical exercises & quizzes

· 1-on-1 expert support

· Course Q&A forum

· 30-day money-back guarantee

· Digital Certificate of Completion

See you in there!

Sincerely,

Vardges Zardaryan

P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Vardges Zardaryan" and complete the courses below to become a Data Analysis Rock Star:

1. Mastering Data Analysis in Excel

2. Power BI: From Zero to Hero

3. Data Analyst’s Toolbox: Excel to MySQL

4. The Complete Introduction to SQL for Data Analytics

Microsoft Excel: Practical MS Excel + MS Excel data analysis

Practical MS Excel. Fast MS Excel mastery. Fun MS Excel. Data analytics with Microsoft Excel. All MS Excel versions OK.

Created by - Six Sigma Academy Amsterdam - - BKO accredited university lecturers following ASQ guidelines

"]

Students: 5407, Price: $99.99

Students: 5407, Price:  Paid

WHY CHOOSE US?

Hi there! How are you? Thanks for considering our Microsoft Excel course. There are at least 100 MS Excel courses out there. Why choose our MS Excel? Because of the following reasons:

  1. We pre-selected the important Microsoft Excel elements that are highly used in practice. So you do not spend 40 hours on a massive MS Excel course, only to find that what you really need 99% of the time, could be explained in a fraction of that time. We respect your time.

  2. We mix the MS Excel course with story telling. We integrate interesting stories to give Microsoft Excel some context. So do not expect a boring ride. Instead, expect an exciting ride. So expect context about for instance:

    • Kellog's cornflakes' weird history

    • Dutch Christmas traditions

    • Tasty Brazilian fast food

    • Albrecht brothers who founded Aldi supermarkt

    • Atari and Nintendo 

    • The Navy SEALs

    • Dutch theme park 'The Efteling'

And much much more....

STRUCTURE

This course is 2 courses in 1

PART 1

In the first part you learn how MS Excel works. What exactly?

  • MS Excel: Pivot charts and pivot tables

  • MS Excel: Nested IF functions

  • MS Excel: AND function

  • MS Excel: Combining IF & AND function

  • MS Excel: Cross sheet referencing

  • MS Excel: Vlookup

  • MS Excel: Freeze panes

  • MS Excel: List functions

  • MS Excel: Absolute and relative cell references

  • MS Excel: Histograms

  • MS Excel: Pareto charts

  • MS Excel: Multiple line charts

  • MS Excel: Bar charts

  • Chart theory

PART 2

In part two, you will learn the theory of statistical techniques for data analysis. You do not need any statistical or mathematical background. Subsequently, you learn how to execute these theories in Excel. The tools of data analytics which you will learn include for instance:

  • Correlation with MS Excel

  • Single OLS regression with MS Excel

  • Multiple OLS regression with MS Excel

  • Non linear regression with MS Excel

At the end of this course, you obtain a certification of completion.

Note: We use Microsoft Excel 2016, but other versions are fine too.

Thanks for considering us. Have a great day, wherever you are.

Team SSAA

R Tidyverse Reporting and Analytics for Excel Users

From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours

Created by Jonathan Ng - Data Science and BI Strategy

"]

Students: 5296, Price: $99.99

Students: 5296, Price:  Paid

If you use Excel for any type of reporting or analytics then this course is for you. There are a lot of great courses teaching R for statistical analysis and data science that can sometimes make R seem a bit too advanced for every day use. Also since there are many different ways of using R that can often add to the confusion. The reality is that R can be used to make your every day reporting analytics that you do in Excel much faster and easier without requiring any complex statistical techniques while at the same time giving you a solid foundation to expand into those areas if you so wish. This course uses the Tidyverse standards for using R which provides a single, comprehensive and easy to understand method for using R without complicating things via multiple methods. It's designed to build upon the the skills you are already familiar with in Excel to shortcut your learning journey. 

When I first started using R I thought that it could be a good replacement for the automation type processes I used to write in VBA. This can be quite off putting for a lot of Excel users as VBA often adds an extra layer of complexity to your work and is often only something which is done to automate a process which has already been established in Excel. One of the key benefits of Excel is that you are working directly with the data without having to go through the complexity and overhead of using a programming language. 

Programming languages such as VBA are actually very difficult for working with data as there isn't even any concise way of referencing common data elements such as named table columns. To carry out an operation on every row would take several lines of code which runs slow and ends up hiding your formula which actually contains your business logic. 

Despite all of this people use VBA anyway as once you invest the time to setup your processes you can run the exact same steps thousands of times with a click of a button. 

What if there were a way to work directly with your data as simply as Excel but also have more programming power than VBA? That's what R can do for you. 

Since I've started using R people have asked me when it would be beneficial to use R instead of Excel. Here are some examples

1. vlookups and sumifs on large datasets can run very slowly in Excel. I've helped people to replace multiple lines of vlookups that take 80 minutes to run in Excel with a single function in R that takes less than 1/10th of a second. 

2. Exploring and analysing your data in R can be Viewed in a simple table like Excel but also has a wide range of other methods which can be more effective.

3. Dashboards and visualisations are much richer and easier to construct than in Excel

4. Distributing your work in Excel can be beneficial since almost everyone has Excel installed. The problems with this are that not everyone always has the same version of Excel or addins installed which means your work might not be compatible. Also files are usually emailed around which can very quickly lead to hundreds of untracked copies of your Excel files with slight variations in them. The outputs from R can be simple Excel or csv files however your output can also be a web app that can be centrally stored and tracked on a server compatible with any web browser on your computer or smart phone. 

5. Team collaboration and version control in Excel is done via shared workbooks and track changes. Turning on these features in Excel disables some of Excels best features and still results in file locking. Team collaboration in R is done on github which allows you to easily work across teams without file locking issues and full audit histories of your work. 

The beauty of R is that once you start using it you will no longer have to make a special investment of time to automate your processes after your analysis is done. Practically anything that you can do in Excel you'll be able to do faster and better for even your first round of analysis and will leave you with an script which means your work is reproducible and automated from the very beginning. 

Even though your existing Excel skills will help you to pick up R one of the hardest things is that you're so familiar with Excel that it's too easy to keep on using it. I used Excel for years and spent thousands of hours studying how to use it more efficiently, I even taught advanced courses in it. It seemed obvious to me at the time that it was one of the most efficient ways to work with data. Even though working with a programming language might be more powerful it often had too much over head and was too removed from the actual data analysis. R is the programming language I wish I learnt 20 years ago. Perhaps somewhat counter intuitively you'll end up spending less time thinking about how to put a piece  of work together than Excel and more time looking at your data in new ways that you've probably never even thought of. 

Advance Analytics with Excel – data analysis toolpak/ Solver

Advanced data analysis in excel: Data Analysis tools (toolpak add-in) for statistics / solver for linear optimization

Created by Gopal Prasad Malakar - Trains Industry Practices on data science / machine learning

"]

Students: 2500, Price: $19.99

Students: 2500, Price:  Paid

What is this course all about?

  1. This course demonstrates how to use "Data Analysis ToolPak".
  2. It explains the business scenario and then shows application of statistical procedure using data analysis tool pack on the given data.
  3. The course also shows how to use Goal Seek and Solver (to solve linear optimization problems)
  4. It gives clue about what is the most important portion of statistical procedure output and how to interpret it with respect to problem at hand.

Tags

  • Statistical Analysis using Excel
  • Linear optimization using Excel
  • Data Analysis toolpak (Excel Add-in)
  • Statistical Analysis case studies
  • Data Analysis examples
  • Data analysis using Excel

What Kind of Material is included

  • All the excel files that has been used in videos are available to download.
  • These excel contains data files, so that students can practice it on their own.

How long it should take to complete the course

It should take roughly 10 hours to practice and master all the procedure.

How is the course structured

The course first explains a business context and the data. Then it demonstrates how to use statistical procedure using data analysis tool pack. It Also explains how to solve linear programming problem using solver. It demonstrates how th use goal seek. The content of the course will be

  1. Numeric data Analysis
  2. Categorical data Analysis
  3. Chi square test of independence
  4. Simple Linear regression / Multiple linear regression
  5. F test for equality of variances
  6. T- Test for Comparing two sample means
  7. Pair t test
  8. ANOVA – single factor
  9. ANOVA – two factor with / without replication
  10. Generating random numbers with uniform / normal / poison distr.
  11. Rank and Percentile
  12. Histogram and pareto charts
  13. Goal seek
  14. Linear programming problem - Solver example

Why Take this course

  1. To quickly understand how to perform statistical analysis using excel.
  2. The understand, which are the most important portion of statistical procedure output and how to interpret it for a given context.
  3. To understand the process of formulating linear programming cases in solver and getting solution.

Microsoft Excel Business Data Analytics

Learn Business Data Analytics Using Microsoft Excel including Pivot Tables, Vlookups and much more

Created by Sean J. Thompson - Analyst

"]

Students: 2342, Price: $94.99

Students: 2342, Price:  Paid

The goal of the course is to build you into an Business Data Analyst from the ground up. We do this by giving you the necessary training through hands-on practical exercises. The Data Analyst Training Course will prepare you for real-world data analysis and analytics and put you a step ahead.

Whether you are starting out, or well into your career and looking for a change, this course is for you. This course is for those who are hungry to learn and enhance their value. Regardless of your background, your level of education or the industry you currently work – this course is for you.

Microsoft Excel – Data Analytics Power Query and PivotTables

Clean, Transform and Summarize Microsoft Excel Data Quickly with Excel's Power Query and PivotTable Tools

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 2187, Price: $89.99

Students: 2187, Price:  Paid

Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.

In Excel 2016, 2019 and Office 365, Power Query is built directly in the Excel interface through the GET AND TRANSFORM command on the Data tab. (Power Query is NOT available on the MAC release of Excel)

Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.

Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:

  • Finding the Data each time you need a report

  • Cleaning Columns of Data

    • Splitting or Joining Column Values

    • Removing unnecessary characters and extra spaces

    • Formatting data correctly

  • Filtering data needed for the report

  • Combining multiple Datasets into a master list

  • Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts

In just 3 easy steps, you'll have a final report ready for presentation and your next raise.

  1. Get Data

  2. Transform/Clean Data

  3. Report on Data

Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.

Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.

This Excel Power Query Course Includes:

  • 6+ hours of video content

  • Downloadable exercise files to follow along

  • Access to the instructor through the QA section

The Complete Data Analytics Course in Excel

A complete data analysis course using the tools you already have.

Created by Michael Parent - Managing Director - Michael Parent Consulting

"]

Students: 1118, Price: $19.99

Students: 1118, Price:  Paid

Do you think you need to learn new software to perform data analysis, statistics, simulations? You don't! Everything you need to get started in the world of data analytics is already on your computer in the wonderful application called Excel.

This course will first acquaint you with the Excel environment including how to use simple and complex functions, hot-key shortcuts and navigation tips to make sure you work efficiently and effectively. From there, I lead you in lectures and practice exercises on the fundamental topics of data analytics.

Data Visualizations - Visualizing data is an important part in analyzing data as well as presenting and explaining what it means. Lectures in this course Included how to craft and use bar charts, line charts, radial charts, histograms, box and whisker charts, pie charts, conditional formatting and Sparklines.

Pivot Tables - Pivot Tables are very powerful, simple to use tools built into excel. The lectures will include how to structure data to get the most out of pivot tables, and then a few use cases including root cause analysis, comparative analysis, along with other visualization tools specific to pivot tables.

Statistics - The Statistics module is by far the most densely packed module in this course. As a statistician by training, I present a deep dive into the data behind the statistics and how to use different statistical tests based on different circumstances. The module is filled with different lectures and exercises involving ANOVA tests, T Tests, Chi-Squared Tests, Tests for Normality, Regression Analysis and more.

Forecasting - Organizations have to be able to anticipate the future. The forecasting tools presented in this course help us accomplish this feat. Forecasting is presented in two different ways - Factor forecasting and Time Series forecasting. For each approach to forecasting, many tools and techniques are introduced and reviewed including Regression analysis, Monte Carlo Simulation, Simple Moving Averages, and Auto-Regressive techniques.

Excel Tools - Excel has a lot of useful tools that don't quite fit neatly into any of the other modules. The last module of this course explores the use cases of using these tools. In particular, several archetypal problems are introduced and solved using the miscellaneous data analysis tools found in excel, including Excel Solver.

Best Excel Course: Data Cleaning – For further Data Analysis

Learn Advanced Excel tricks on Data Cleaning Analytic - Go To, Date Correction, Replace using Wildcards, Text to Columns

Created by Yoda Learning - Data Analyst |MS Office Expert & PMP | Instructor/Programmer

"]

Students: 1021, Price: $39.99

Students: 1021, Price:  Paid

Before you read what I have to say, see what my students are saying about my courses on Excel:

"I would like to tell you that I am very impressed with your courses so far - I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one's attention span). The other gem in your training are the shortcuts, I found no other course with the same insights." by Peter Klugsberger, Australia, ex-McKinsey & Co., served various senior roles (CEO, COO) in various companies

“I thought you knew me - You solved the exact problem which I face at my office in your course” by Rajesh Dhoot, India, ex-Sr. Manager, Finance and Accounts, Ultratech Cements – An Aditya Birla Group Co.

-------------------------------------------------------------------------------------------------------------------

We get data from various sources like ERP, SAP and in different formats. In order to make it useful to analyse, we have to clean this and put them in a structured format. It's a pure time-consuming activity. In order to save time and effort on cleaning and put the structure in place, We need few important data cleaning techniques as mentioned below which are part of this course. Check the list of Topics being covered in this course on Data Cleaning in Excel:

  • Go To (Special) with Errors 
  • Go To (Special) without Errors
  • Go To (Special) with Ctrl + Enter
  • Go To (Special) –  Fill Intermittent Black Cells
  • Go To (Special) –Visible Cells vs Shortcuts  
  • Text Formulas – Change Case using UPPER(), PROPER() & LOWER()
  • Text Formulas – Remove Leading, Trailing & excess Intermittent spaces using TRIM()
  • Text Formulas – Using LEN() & TRIM() together
  • Text Formulas – T(), N() & VALUE()
  • Text Formulas – REPT() for artificial Column Chart in a Cell
  • Text Formulas – REPT() & LEN() for adding leading zero before incomplete Cheque Nos.
  • Find & Replace – Using Wildcard character (  )
  • Find & Replace – Neutralising Wildcard characters to remove them from data
  • Find & Replace – Word vs. Excel
  • Find & Replace – Cell Format
  • Text to Columns – Basics (Delimited)
  • Text to Columns – Basics (Fixed Width) + Hidden Trick
  • Text to Columns – Cleaning up numbers w. trailing minus sign
  • Text to Columns – Cleaning up numbers w. leading DrCr text
  • Text to Columns – Correcting invalid Dates (DMY)
  • Text to Columns – Correcting invalid Dates (YMD)
  • Text Formulas – LEFT(), RIGHT() & SEARCH()
  • Text Formulas – MID() & LEN()

We have 26 videos of duration 1.5 hrs. Through practical examples, they start from the foundation and take you to the Ninja level application.

-------------------------------------------------------------------------------------------------------------------

Your Question - Why should I take this mini-course on Excel?

Our Response - Because we cover the following -

  1. WHY should we use a certain formula or technique in a given situation
  2. What are the alternative approaches to solving the same problem
  3. Formulae and hidden tricks to truly make you a Master of Excel Data Cleaning Functions.

Example -  Fill thousands of blank cells with desired value or text like 0 to do the calculation, using Go To (Special) formula Techniques.

------------------------------------------------------------------------------------------------------------------ 

Your Question – So will I learn Pivot table, Lookup & What-if Analysis?

Our Response – No. This course covers Basic to Intermediate level tips & tricks on Excel Data Cleaning like Go To Special, Find & Replace and more.

------------------------------------------------------------------------------------------------------------------

"The courses are really helpful whether in terms of saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda" by Arundhati Raychaudhuri, Finance Professional, India

-------------------------------------------------------------------------------------------------------------------

Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I'll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Guided practice - over worksheets included for immediate practice
  • Access to all videos 24 x 7 - learn online from anywhere
  • 30-day money back guarantee (we want you to be 100% satisfied) 

-----------------------------------------------------------------------------------------------------------------

If you have read this far, next action is JOINING this course. Invest 1.5 hrs. for a benefit of lifetime Ninja status on Excel Advanced Data Cleaning functions!  

Excel Statistics / Data Analytics

Get Marketable Data Analytic Skills Using the Microsoft Excel Data Analysis ToolPak

Created by Quantitative Specialists - Specializing in Statistics, Research Design, and Measurement

"]

Students: 574, Price: $74.99

Students: 574, Price:  Paid

Get marketable data analytic skills in this course using Microsoft Excel. This course will substantially increase your knowledge of data analytics using the extremely popular Microsoft Excel software program, with a focus in the area of significance testing, an important tool for A/B testing and product assessment.

Many tests covered, including different t tests, ANOVA, post hoc tests, correlation, and regression. 

This course is great for professionals, as it provides step by step instruction of tests with clear and accurate explanations. Get ahead of the competition and make these tests important parts of your data analytic toolkit!

Students will also have the tools needed to succeed in their statistics and experimental design courses. 

In this course, a number statistical procedures will be covered in Microsoft Excel using the Data Analysis TookPak.

The following statistical procedures will be covered in this course:

  • Central Tendency (Mean, Median, Mode)
  • Variability (Standard Deviation, Variance, Range)
  • t tests (Independent t and Dependent t)
  • Analysis of Variance (ANOVA)
  • Post Hoc Tests
  • Correlation
  • Multiple Regression 

For each test, we will cover:

  1. How to perform the analysis step-by-step in Microsoft Excel
  2. What the results mean in clear, yet accurate language
  3. How to effectively, accurately, and professionally communicate the results to others, clearly demonstrating your understanding of the material.

Enroll in this course and obtain important marketable data analytic skills today!

Mastering Excel Analytics – Excel Data Analytics from A to Z

Excel Analytics Techniques - Mastering Data Analysis in Excel with Pivot Tables, Visualization, and What-if Analysis

Created by Jack Tan - Dr.

"]

Students: 459, Price: $19.99

Students: 459, Price:  Paid

Want a one-stop course that provide you step-by-step guidance in leveraging Excel Analytics  to its full potential? This is will be the course that you need on knowing everything on Excel Analytics.

Why Excel Analytics?

This is because Excel Analytics offers you:

  • Easiest and Fastest way of doing Exploratory Data Analysis (EDA).
  • Efficient - Be able to answer EDA questions in seconds.
  • Intuitive - The EDA answers can be intuitively visualized in a beautiful way.
  • Professional - Be able to show the results to your management and/or your audience professionally with the least amount of work.
  • Zero Programming - Almost zero programming skill is needed

What we are covering:

  • Excel Analytics with detailed coverage of various analytics components of Excel, which includes Excel Visualization, Excel Pivot Table/Chart, What if Analysis.
  • Case studies included Titanic Passenger List - which is featured in many data competition (e.g., Kaggle) tutorials.
  • Focus on Excel 2016.

Outcome:

  • You will become an Excel Analytics Master. This course will equip you with essential and advanced skills of performing analytics using Excel. You will be able to answer most analytics questions in seconds using Excel Analytics tools that are covered in this course.

Learn data science & analytics by creating excel dashboards

From Excel dashboards (that you can build in under a minute) to AI & BI mobile apps ... without coding!

Created by Luke Rochester - Management Consultant

"]

Students: 429, Price: $99.99

Students: 429, Price:  Paid

Build Dashboards for Excel and Business Apps for iPhones & iPads

Build Dashboards & Business Apps without writing a single line of code, all you need is Excel.

In a world first we have designed a training course that helps the average Excel user create an Excel dashboard and an iPhone app without having to write a single line of code.

When we build the dashboards we only use tools that come standard with Excel – like Pivot Tables, Pivot Charts, Icons and Sparklines (and don't worry there isn't any visual basic or even a single macro in our solution).

And here's the best bit … Claris FileMaker (an Apple subsidiary) has released a free database for iOS called "FileMaker Go".  It works natively (i.e. online or off-line) on iPhones and iPads.

The program you download from the resource section will automatically convert a simple spreadsheet into a sophisticated Business App that works with FileMaker Go. Therefore you will be able to distribute your own apps to as many people and iOS devices as you like.

More advanced users can even host an online version which will work with most browsers including Android.  The advanced version can  integrate with everything from SQL to SAP and Claris has just released Claris Connect, which can connect your  app to API's via a simple workflow.  These advanced (multi-user) techniques are beyond the scope of this training course however advanced users, BI specialists, data analysts, data scientists, programmers and app developers may still want to take this course to refine core skills in multidimensional modelling and analysis.

However, this training course is squarely aimed at the typical Excel user who wants a simple method for building their own Dashboards and Business Apps.

Sign up today to start creating your own Dashboards and iPhone apps without learning a single line of code.

Excel VBA Introduction- Data Analytics Training Series1

You will learn complete VBA Introduction here from scratch

Created by ajay parmar - Instructor - Advance Excel, Excel Vba ,Access, Access Vba

"]

Students: 383, Price: $19.99

Students: 383, Price:  Paid

  • I am here to make you awesome in Excel VBA. Let us take a deep dive into VBA and learn it from the beginning.

  • We are starting with Macro recorder introduction. How to record steps and play it later using VBA.

  • How to Edit the existing macros if your boss want you to change few lines.

  • How to Run macros or delete macros or give shortcut keys. There are different ways to execute your program or macro. Know all of them.

  • How to find out last row and how to select the data. We have discussed Static and Dynamic , both approaches and their advantages ,disadvantages over each other. Everything is discussed in full detail. Great for freshers who do not know anything about programming.

  • How to correct Macros if they are recorded with wrong steps.

  • How to run macro step by step which we need it for debugging.

  • How to move from one sheet to another. What errors we can expect if sheet name changes and how to sort out your issues.

  • Introduction to Variables. What are variables and why do we need them. How to declare them.

  • Data types of Variables and their significance in your project. Strings. Integer, Single, byte, Double , Variants - we have covered all.

  • Grip over variable related errors - overflow and type mismatch - Why they come and how to resolve the issues.

  • Use of Local window for better testing of your code. How to activate it and how to use this window.

  • Option Explicit - How to declare it and what benefit it provides.

  • Frequently asked Questions related to Variables asked in your interview.

  • Call key word .

  • Scope of Variable - Local, module, private and Public level variables . In full detail everything is covered.

  • Assignments solutions are also provided in the form of file as well as lecture video explaining it.

  • We have a long way to go and i promise you wont be disappointed after taking this program. We have live project discussions and assignments for you to practice. You will not only learn here but also know how to implement the VBA in real environment.

Certificate Course on Advance MS. Excel with Data Analytics

Become Excel Expert

Created by Ruby Kushwaha - Web Designer And Trainer

"]

Students: 357, Price: $24.99

Students: 357, Price:  Paid

Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel.

Analyzing large data sets with Excel makes work easier if you follow a few simple rules: Select the cells that contain the data you want to analyze. Click the Quick Analysis button image button that appears to the bottom right of your selected data (or press CRTL + Q). Selected data with Quick Analysis Lens button visible

Microsoft Excel is one of the most widely used tools in any industry. While some enjoy playing with pivotal tables and histograms, others limit themselves to simple pie-charts and conditional formatting. Some may create an artwork out of the dull monochrome Excel, while others may be satisfied with its data analysis.

Business Analytics – Advanced Excel

Microsoft Excel, Basics, Formulas, Charts, Pivots, Dashboard, Macros, Business Simuation, VBA

Created by ForeVision Academy - Investment Banker | Edupreneur

"]

Students: 307, Price: $44.99

Students: 307, Price:  Paid

Excel Overview

Excel is one of the most widely used tool in corporates across sectors and across functions

It has always been user friendly and feature rich and now has been expanded to provide an even wider array of tools helping businesses right from simple work to complex problem solving and decision making

Excel has become an integral part of everyday operations, making it a necessity for continuous flow of business

•Excel Overview & Basic Excel tools

•Basic & Advanced Excel Formulae

•Nested & Dynamic Formulas

•Charts – Basic, Multi Axis, Advanced & Dynamic

•Pivot Table, Pivot Charts & Pivot Dashboards

•Business Simulations – Sensitivity Analysis / Scenario Manager / Solver

•Management Dashboards

•Macro Recording, Macro Objects & VBA Coding

•Shortcut techniques for easy working

•Case Study based extensive hands on learning

•Wide range of managerial examples

Microsoft Excel Hands on Specialization For Data Analytics

Learn how to manage, analyze, and visualize data with Excel to transform raw data into ready to use information.

Created by Thinkahead Academy, LLC. - Best Technology Courses from Expert Instructors

"]

Students: 252, Price: $89.99

Students: 252, Price:  Paid

Welcome to this course: Microsoft Excel Hands on Specialization For Data Analytics. Microsoft Excel is one of the easiest to use data analysis tools you will ever come across. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level.

In this course, you'll learn:

  • Learn How to create formulas to help you analyze and explain findings

  • Learn and Understand Data Cleansing

  • Learn various ways to model data for businesses

  • Build impressive tables and combine datasets using Excel's built-in functionality

  • Leverage Excel's powerful built-in tools to get the median, maximum, and minimum values of your data

  • Learning Power Query, Power Map, and Power Pivot

At the end of the course, you'll be provided with useful shortcuts and tips, enabling you to do efficient data analysis with Microsoft Excel. So let's get started.

Excel in the World of Data Analytics

Learn how to conduct data analysis in Excel and get meaningful insights!

Created by Data Civilisation - Technology-based analytics company

"]

Students: 240, Price: $89.99

Students: 240, Price:  Paid

Reviews

"A great, easy to follow course which provides all the knowledge you need to confidently use essential Excel functions in the corporate environment. Split into clear sections which makes it very useful to bookmark this course as a guide for future reference" - Sunny Gun

"This course really builds a strong foundation and which in turn makes the more complex excel functions to be easily understood. Coming from 5 years of experiences from professional services back ground and being through various excel training this is by far the most easily understood and value adding I have seen" - Adeel Sharif

"This course started with the very basics and continued to more advanced topics. I was already familiar with Excel but I leaned several new concepts that I can put to use. The instructor was very good." - Disa Lee

"This course is highly recommended! The best data material I have ever seen! This course explains concepts to me in the most entertaining and easy to understand way possible. Thank you!" - Mostafa Ahmad

"Good explanation" - Balwinder Kaur

"I am brand new to Excel for data analytics! This course is providing me with a strong foundation to perform job tasks. Thank you for offering this course!" - Michelle Little

-------------------------

Join this course and you will work on building a strong skill set in Excel. We will start from the basics to develop a strong foundation, and we will then work through more complex functionalities, step-by-step.

This course covers topics which are used extensively in the job market, ranging from financial consulting to healthcare. Additionally, a lot of the topics in this course are actually used for interview questions for large corporations!

This course will walk you through the structure and user interface in Excel. We will then look at how to utilise a wide range of formulas which can help us analyse data sets. We will then go over at how to manipulate data and operations to create reports which show useful insights and findings. Finally, we will be visualising our results by creating graphs in Excel! This is the standard operation and process used in multiple job industries. We have tailored this course specifically to enhance your career opportunities!

So what are you waiting for? Jump right in and learn about data analysis in Excel!

Business Analytics with Excel

Business Analytics covering Statistical tools, Excel applications, Forecasting, Regression, Optimization & Simulation

Created by Dr Bishram - Author, Trainer & Management Consultant, Visiting Professor

"]

Students: 167, Price: $89.99

Students: 167, Price:  Paid

If you are a manager or aspiring manager and you want to differentiate yourself or create a competitive advantage for you, Business Analytics with Excel is right course for you.

You will learn some important tools and techniques to proceed with Business Analytics of your own. This is a quick course. The techniques have been presented from practical perspective. You don’t need to get into complex mathematical and statistical modelling. Instead the focus is on understanding implications of various tools, learn interpreting and formulating problem and finally solve them using Excel.

In the book “Competing on analytics: The new science of winning”, Thomas Davenport claims that a significant proportion of high-performance companies have high analytical skills among their personnel. In a research by MIT Sloan Management Institute it has been found that 51 % companies used Analytics to gain competitive advantage while others have been struggling.

The answer is empowering each manager on analytics. This course is an attempt to empower every participant with analytics tools. This is about demystifying analytics. You will be able to do 80% of analytics related work yourself after this course. You may need specialist intervention in some complex cases. This course will help you getting competitive advantage and help you move faster in your career.

So, what are you waiting for?

Register now and empower your career!

MBA in Excel- Master Business Analytics in Excel

Master Excel with Formulas, Functions, Excel Dashboards, Pivot tables, Power Query, Macros & VBA and Power BI

Created by Mohammed Mustafa - Excel Instructor

"]

Students: 153, Price: $89.99

Students: 153, Price:  Paid

All in One Excel Course - Enhance your Excel experience with MBA in Excel. Start with formulas, move onto Pivot tables, macro and VBA, manipulate data and consolidate with Power Query and visualize with Power BI. All in One course, from basics to Advanced level.  Recommended for any Excel user to level up their skills and insights of different tools provided. Excel is a must anywhere you go in the world. Uplift your Excel confidence and step out an Excel hero. With more than 18 hours of content, I hope you will be able to learn many new tips and at the end of the course be able to quickly analyze and debug formulas with ease. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst. All you need is basic Excel skills and a passion to put in hard work to master key concepts.

More videos to be added on student feedback and request.

Formulas covered are Xlookup, Vlookup, Counta, Index & Match, Sumif, Sumifs, Countif, Countifs, Array nested formulas, Filter, Xmatch, Sumproduct, Text functions, Date functions, VBA coding, DAX functions, Pivot tables, Named Ranges, Offset, Conditional Formatting, Dashboard creation, Animation in Excel, Getpivotdata, Slicers, Indirect function, Textjoin, IFS, Maxifs, Sort, Sortby, Unique, Switch, Let, Sequence, much more and  Super Excel shortcuts.

Course is updated with Microsoft 365 version.

Excel MIS Analytics (Advance Vlookup Match & IFs ) Series 1

VLOOKUP MATCH CELL REFERENCING IF Discussion -. From Basic to Advance Level

Created by ajay parmar - Instructor - Advance Excel, Excel Vba ,Access, Access Vba

"]

Students: 93, Price: $19.99

Students: 93, Price:  Paid

If you thinking of learning Excel - This is the perfect lecture for you. We are starting the excel in this program and covering use of $ signs in formulas and also a complete discussion on most used formula in excel - Vlookup, Match, if functions including nested IFs. You will have assignments also to practice along-with classwork files. Discussion starts from basic level but gradually moving towards extremely advance side. Have a great learning today.

Excel VBA LOOPS & IF – VBA Analytics Series2

Know everything about basic & complex loops using IF functions. Fantastic in-depth discussion with lot of examples

Created by ajay parmar - Instructor - Advance Excel, Excel Vba ,Access, Access Vba

"]

Students: 78, Price: $19.99

Students: 78, Price:  Paid

  • In this course - we are taking a deep dive into Loops and IF Functions .

  • Detailed discussion on For Next loops - their use and significance . How to mold them in different ways and use in your projects.

  • Discussion on Do -While & Until loops from very basic level to advance.

  • Which loop is better or how about making a choice in loops over each other.

  • Learn loops using the basic and complex patterns in order to get mastery.

  • Detailed discussion on IF functions and their different syntax's. For example, Single IFs, IF AND, IF OR and Nested IFs.

  • Use of Else-IF and when to use it , How it is different from IFs without Else if Blocks. With real time examples.

  • How to handle hundreds of conditions in one go using IFs.

  • What is the syntax of writing them. How they are used in Loops. How to write Loops and IF together to make awesome projects.

  • What is a Case select statement- how it can be an alternate to IF conditions.

  • Whether it is a combination of IF with For next or Do Loops - we are discussing everything here taking great examples.

  • How to write sub-loops in loops- you will find all relevant information here.

  • Assignments for your practice and to monitor the self performance as to how well we understood the series and use of Loops along-with IF Functions.

    To help you in growing faster and be able to the assignments ,questions prepared for you an Online assistance to students is also given personally by me. Students can ask questions related to the loops series and get their doubts cleared on immediate basis.

Excel VBA Functions- MIS Analytics Series5

Discussion on functions - User defined functions as well as vba in-built functions ( complete tutorial)

Created by ajay parmar - Instructor - Advance Excel, Excel Vba ,Access, Access Vba

"]

Students: 45, Price: $19.99

Students: 45, Price:  Paid

  • We are learning everything about vba functions from their definitions to their practical use in excel day to day work life.

  • Lessons are started from very basic understanding and gradually moving toward advance levels. 

  • You will see the use of functions practically as well and their powerful and unique combinations with loops and arrays. Must watch for wannabe developers

  • Inbuilt functions of VBA

  • UDFs - User defined functions in VBA

  • Advantage of UDFs over Inbuilt excel functions. From limitations to dealing with complex situations - I have got everything for you. Many amazing projects are shared in the series.

  • Can we pass in parameters in sub routines . How to call functions from excel sheets or sub routines.

  • What is the process of passing parameters from a sub routine to a function and how it is useful for us.

  • Questions asked in your VBA Interview.

  • Assignments are added to give you a real exposure.

  • Vlookup advance level projects discussed.

  • My online support forever for you.