Best Excel Courses

Find the best online Excel 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 Courses.

Microsoft Excel – Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 767794, Price: $129.99

Students: 767794, Price:  Paid

Microsoft Excel all in One Package

This Microsoft Excel course combines 4 different courses.

  • Microsoft Excel 101 - An Introduction to Excel

  • Microsoft Excel 102 - Intermediate Level Excel

  • Microsoft Excel 103 - Advanced Level Excel

  • Master Microsoft Excel Macros and VBA in 6 Simple Projects

Material recorded with Excel 2013 but works in 2010, 2013, 2016, 2019 (Office 365)

Recent Student Review

  • "You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don't doubt it, buy it. I've learned so much in this course. Hope more courses are on the way because I'd buy every single one of them. Thanks again bro. God bless you and your family."

  • "Happy to say that I now "know" excel. I realize there is so much more to learn, but it's a start! Thank you for being such a great instructor... now on to the next class."

  • "Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them."

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 Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user

Created by Dinesh Natarajan Mohan - Sharing simple but effective solutions

"]

Students: 378433, Price: Free

Students: 378433, Price:  Free

      Welcome to the Useful Excel for Beginners course. 

     In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply. 

     As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing. 

     The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. 

Since this is a free course, Udemy does not offer certificates anymore.

Zero to Hero in Microsoft Excel: Complete Excel guide 2021

A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks

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

"]

Students: 368448, Price: $29.99

Students: 368448, Price:  Paid

6 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.

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.

Microsoft Excel – Advanced Excel Formulas & Functions

Master 75+ MS Excel formulas and learn data analysis with a top Microsoft Excel & business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 229912, Price: $149.99

Students: 229912, Price:  Paid

See why this is one of the TOP-RATED Excel courses on Udemy:

"One of the best Excel courses I've ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, and count me in for the next ones!"

-Julio Garcia

"This is an exceptionally valuable course. The information is vital with examples of best practices from a true Excel expert. Chris Dutton can teach!"

-Barbara S.

"Chris Dutton is an EXPERT in Excel. He makes comprehensible to the student the complex (sometimes super-complex) nature of the formulas he uses. Everything that is written at the course description, although it may seem pure marketing and publicity at first glance, is indeed true. If I could rate it higher I definitively would. THANKS Chris!"

-Bruno Ricardo Silva Pinho
__________

FULL COURSE DESCRIPTION:

__________

It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute Excel power user, you've come to the right place.

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.

__________

By the end of the course you'll be writing robust, elegant formulas and functions from scratch, allowing you to:

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data

  • Go rogue and design your own formula-based Excel formatting rules

  • Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions

  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)

  • Manipulate dates, times, text, and arrays

  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)

__________

We'll dive into a broad range of Excel formulas & functions, including:

  • Lookup/Reference functions

  • Statistical functions

  • Formula-based formatting

  • Date & Time functions

  • Logical operators

  • Array formulas

  • Text functions

  • INDIRECT & HYPERLINK

  • Web scraping with WEBSERVICE & FILTERXML

__________

What gives you the right to teach this class? Can't I just Google this stuff?

I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and significant others. The only thing I love more than learning Excel is teaching it, and as the founder of Excel Maven and Maven Analytics I've been lucky enough to teach Excel to 200,000+ students across 180+ countries. My teaching style is conversational, authentic and to the point, and I will always communicate complex concepts in a framework that is clear and easy to comprehend.

As a full-time analytics consultant and Excel instructor, I cut my teeth using Excel to solve real-world business problems and develop award-winning analytics & data visualization tools for Fortune 500 companies. If you care about creds, I'm a card-carrying MOS Certified Excel Expert and my work has been featured by Microsoft and the New York Times. Ok so I don't actually carry the card, but you get the idea.

If you're looking for the ONE course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel ninja, you've found it.

See you in there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

Ms Excel/Excel 2021 – The Complete Introduction to Excel

Master Excel/microsoft Excel- Learn MS Excel - Excel formulas/Excel charts/Excel functions using Excel 2016/Excel 2019

Created by Yassin Marco - Helped over 995 000+ students in 198 countries

"]

Students: 195566, Price: $59.99

Students: 195566, Price:  Paid

Microsoft Excel is definetly not an easy application to learn and to use. This is why sometimes it's better to have someone that help us learning how to properly work with this amazing APP. Indeed, wether you are:

- A student looking to learn how to use this APP for a school project

- Looking to learn microsoft Excel for professional goals

- Want to improve your knowledge and learn new skills

- Understand microsoft Excel just for personal uses

Or any other reason this course is for you. By using this course to learn this Microsoft APP you will have access to many high quality examples tips and tricks. Also, you will get a complete introduction to all Excel basics and you will be able to work with this app on a daily basis with more confidence.

The structure of the course

​The course is created around a very simple concepte. To learn you need to practice as much as you can. This is why from the moment that you will enter the course and start your Excel journey you will have a lot of Examples and cases that are presented in the course to help you practice everything that you will learn. Not only this will help you become a better user of microsoft Excel but it will give the confidence to start using the App by yourself to be able to create way more andvanced Applications tat will be able to perform different tasks. Thoses App will be able to be used in your personnal life as well as in your professional fiel or at school.

Also, not only this course will help you learn a new skill that is the complete understanding of Microsoft Excel but you will also have a lot of practie inside of the course. So basically, in all the course you will be learning and practicing different concepts functions and formulas and at the end of this course you will have create your own project or small app that you will be able to later use for your personnal, proffessional life or simply for scool,

For who is this course designed

This course is designed for people who have no prior excel knowledge. Indeed, this course is really here to give you a complete introduction to microsfot Excel and give you all the basic knowledge to be able to use this amazing app by yourself. Also, this course can be useful for everyone that always wanted to start there Excel journey and to see the potential of Microsoft Excel. This means that even with no excel knoeledge you will be able to create your own Excel Apps by the end of this course and this a guarantee that I can give you.

Why should I take this course

​Yes, of course there is many other microsoft Excel courses that exist on the internet. But, my way of teaching you how to use this application is unique. Indeed, every concept in this course comes with an example. This will give you a lot of practice so you will be able to think very logically when you will create your own Excel apps. First of all, you will know the process of creating an excel basic app, know how create the plan for your app and then finally make all the creation of the app. This means that with just one course, you will be able to put your full potential into using microsoft Excel and having your own applications that can be used for different purposes.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concepte that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very usefull in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

This is why more than 100 000 students have already took the course !! Don't wait anymore

ENROL NOW and start learning today :)

Microsoft Excel Pivot Tables – The Beginner Course

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 151181, Price: Free

Students: 151181, Price:  Free

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease!

Microsoft Excel – Data Analysis with Excel Pivot Tables

Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 138976, Price: $174.99

Students: 138976, Price:  Paid

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course:

"This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT"

-Monique C.

"Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!"

-Paul M.

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well."

-Ernie A.

__________

FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering, & grouping tools

  • Calculated fields, items & values

  • Pivot Charts, slicers & timelines

  • Interactive Excel dashboards

__________

We'll then explore and analyze Excel datasets from a number of real-world case studies, including:

  • San Diego burrito ratings

  • Shark attack records from 1900-2016

  • Facebook Post data from Spartan Race

  • Major League Baseball team statistics

  • San Francisco employee salaries

  • Daily stock market data

  • IMDb movie ratings

  • Apple Store mobile app ratings

  • Wine ratings and descriptions

__________

Whether you're looking for a quick Excel Pivot Table primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro!

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

Excel Dashboards in an Hour

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.

Created by Mynda Treacy - Microsoft Excel MVP, Teaching 25,000+ Students

"]

Students: 131584, Price: Free

Students: 131584, Price:  Free

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

"10 minutes in and I feel like I can save hours" - Alex

"I consider myself quite good at Excel, but your mastery of it leaves me in the ashes. The dashboard presentation was dazzling." - Ben

"Wow! I am so excited to try this myself! Thank you so much for sharing your skills." - Lyn

Very dense information that in just one hour you represented what I have spent days reading books about this subject. - Khalid

"I've been using Excel for over 10 years and I'd like to take the time to say thank you. That was definitely one of the best courses I've ever taken.

It was
incredibly informative, insightful and taught me a few tips and tricks
that will surely aid me in producing automated dashboards. Thank you for
sharing the course materials.

Nothing short of excellent! " - Amanta

You too can master the creation of Interactive Excel Dashboards and learn to build Dashboard Reports from the ground up.

  • Design and Display Principles
  • Interactive Controls
  • Automating your Dashboard so it updates in seconds

Impressive Content that Will Provide Insight, Analysis and Alerts Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard. 

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets, among a host of other tips that can be used in day to day Excel work.

Unlock Excel VBA and Excel Macros

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 122318, Price: $159.99

Students: 122318, Price:  Paid

Go from Beginner to Microsoft Excel VBA Expert!

I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects. 

What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes:

  1. Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.

  2. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways.

  3. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.

  4. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.

  5. Simple explanations for complex concepts.

  6. High quality video and different delivery methods to keep things interesting.

  7. Lots of ideas to automate your current tasks.

Learn from Google or from this Course?

I've been there! I first learnt VBA from Google.

It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing:

  1. The WHY - why does the code work in one situation but not another.

  2. Structure - topic sequence, real-case examples, workbooks, documentation.

Don’t waste your time

Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing. 

"I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor

"Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take."  -- Justin Fazzio

What you can look forward to in this course:

  • Understand how to use the right syntax in VBA

  • Useful Excel VBA codes you can directly use for your work

  • Use the macro recorder for simpler tasks and improve the code

  • Working with the Visual Basic Editor

  • Debugging tools and error handling methods

  • Different ways to reference ranges and cells

  • Different methods to loop

  • How to work with data types

  • PivotTables in Excel using VBA

  • Importing data from other files and exporting data to text files

  • Interacting with other applications (Word, PowerPoint, Outlook)

  • ActiveX and Userforms to enhance the Excel interface

  • Basically all the knowledge you need to automate tasks in Excel

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!

Created by Jeff Knowlton - Senior Executive. Data Scientist. Teacher.

"]

Students: 119237, Price: Free

Students: 119237, Price:  Free

Here's what some students are saying about the course in the Reviews!

"Really concise quick summary and foundation in Excel" - Clare B.

"Instruction was very easy to follow. It was like having a friend show you what to do." - Patrick M.

"Very clear and easy to understand" - Fiona M

 "Great introduction to pivot tables and good examples too."  - John P. 

"Needed this to get ready for a new job, feeling more confident already!" - Daniel H.

"I have been using Excel for years but only in very specific ways. This course gave a good overview of major functions I have never used and didn't know existed. Will be making some accounting pivot charts right away." - Kyrie

The course is just 36 minutes - you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. You’ll learn how to enter and edit data and formulas. How to format text and numbers. How to filter and sort large tables of data and calculate totals.

Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. You’ll learn how the functions work, and you’ll learn when, and why, to use them in business analytics. Full disclosure: plan for another 45 minutes or so to work through the case studies yourself. I provide all of the files. 

And it’s free! Even though free, it includes all of the features of the standard course: downloadable files, closed captions and quizzes, to help you learn and make it stick. 

This course is designed for people who are preparing for an interview. Starting a new office job. Looking to jump-start their career. And even for those people who are thinking about a longer Excel course, but who aren't sure that Excel is right for them. 

But let’s make something clear: you won’t be an expert. This course is a starting point, the first step on your journey to learn business analytics. It may be as far as you need to go. Let’s find out! Click the button “TAKE THIS COURSE” and get started. 

Microsoft Excel – From Beginner to Expert in 6 Hours

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2013 for Windows.

Created by Todd McLeod - Tenured College Professor

"]

Students: 107953, Price: $24.99

Students: 107953, Price:  Paid

This training provides you everything you need to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel. A university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to master Microsoft Excel.

In only five hours of videos, provided to you in 75 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:

  • Learn how to navigate around Excel
  • Learn how to enter and edit data in Excel
  • Learn how to adjust the way data and information are displayed in Excel
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to use relative, absolute, and mixed references in Excel
  • Learn how to create powerful calculations with Excel functions
  • Learn how to visually represent your data with charts and graphs in Excel
  • Learn how to use Excel data tools like sorting, subtotaling, and filtering
  • Learn how to "freeze columns and rows" with freeze panes in Excel
  • Learn how to remove duplicates from data in Excel
  • Learn how to "transpose data" - switching the columns and rows in Excel
  • Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
  • Learn how to format worksheets in Excel for impact and appeal
  • Learn how to automate Excel tasks with time-saving macros
  • Learn how to integrate Microsoft Excel with Microsoft Word
  • Learn how to use passwords in Excel to protect your work in multiple scenarios
  • Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
  • Learn how to use printing and sharing in Excel

As bonus material, you will also learn two very incredible, and super valuable, skills:

  • how to harvest data from the web
  • how to create online forms which allow you to gather data from individuals

As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template."

Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.

This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.

The Ultimate Excel Programmer Course

Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!

Created by Daniel Strong - Excel Instructor/Programmer

"]

Students: 105169, Price: $139.99

Students: 105169, Price:  Paid

Teach Excel to Do Your Work FOR YOU. . .

Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.

In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.

Excel programming utilizes a simple but effective tool called "VBA" - the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use.

I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION.

My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by.

Take this course and access your true potential.

Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers!

-Dan

Here's what some of the students are saying:

“I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” - Jim C.

“Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” - Marcela T.

“I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Ryan S.

“You can't go wrong with Daniel Strong!” - Steven S.

“The presenter explains in detail and demonstrates what he's covering, easy to follow along and learn!” - David B.

“Teaches you the fundamental of VBA programming without any prior experience. Shows with easy to follow Example!. thanks for the video!”  - Sean C.

"I've taken several different VBA courses here on Udemy and this one from Daniel is by far the most interesting and easy to understand. I've done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I've been doing manually for years... I'm angry with myself because of the time I wasted by not buying this course earlier. I can't even imagine what I will be able to do after finishing the entire course :)" - Robert

“Well explained, easy to understand lectures. Enjoyable and informative videos.” - Marlena

“Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” - Gustavo P.

Best course on VBA ever taken. Thanks a lot!” - Nikita L.

“This is an excellent course!!!  There's a lot of good, useful "stuff" here.  The examples are practical and real-world!” - Todd W.

“Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor.” - Scott K.

“By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete, this throughout.

I am amazed at how little I actually new about the VBA world.

Thanks a million!” - Alex B.

“Everything I have been looking for, you would have to buy multiple books for this level of instruction!” - Luke S.

"Excellent VBA basic to advance tutorial." – Sandeep G.

“This course is good for beginners and for experienced programmers.  Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet.  He goes over different events and triggers (like buttons) to execute code.  This is a really good course if you plan to do some pretty complex vba code with forms and reports.”  - Christian H.

“Very helpful if you do any type of data analysis.” – Jonathan D.

“I think this is an excellent gateway to the tools we need to use going forward. I like the
hands on nature.”
– Andre C.

“Much better than other classes and seminars. Great course.” – Mark S.

“The instructor made VBA easy and straight forward to use.” – Min Z.

“Very thorough and practical.” – Juan S.

***Now Available for Offline Viewing!***

Microsoft Excel – Data Visualization, Excel Charts & Graphs

Master 20+ Excel charts, build advanced Excel visuals & learn data analysis with a top Excel instructor (Excel 2016+)

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 101316, Price: $149.99

Students: 101316, Price:  Paid

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course:

"Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs."

-Nirav M.

"Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!"

-Robert C.

"At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!"

-Judit B.

__________

FULL COURSE DESCRIPTION:

Ask people what comes to mind when they think of Excel, and odds are they'll say "spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts -- and I'm here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2016, including: 

  • Bar & Column charts

  • Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

  • Line charts & trend lines 

  • Area charts

  • Pies & Donuts

  • Scatter plots & Bubble charts

  • Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

  • Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

  • Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

  • Radar & Stock charts

  • Heat maps, 3-D Surface & contour charts

  • Chloropleths & Geospatial maps

  • Custom combo charts & graphs

  • Sparklines

  • And more...

__________

From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times. I've built my analytics career around data visualization, and I can help you do the same.

We'll cover advanced Excel data viz topics that you won't find anywhere else, including:

  • Custom image overlay charts

  • Automation with named ranges and OFFSET/COUNTA functions

  • Scroll & Zoom functionality with Excel form controls

  • Animated charts to visualize changes over time

  • Dynamic, custom Excel dashboards

  • Value-based chart formatting

  • Custom gauge charts & pacing charts

  • Grid visuals using Excel array formulas

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.

Excel for Accountants: Mapping Tables

Automate reporting tasks with a mapping table

Created by Jeff Lenning - Microsoft Certified Trainer

"]

Students: 86463, Price: Free

Students: 86463, Price:  Free

In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table.

Microsoft introduced tables in Excel 2007, and this feature is a game-changer. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we'll discuss these special properties in the course.

Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We'll discuss the function's arguments and demonstrate several practical applications.

Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we'll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different.

The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.

Excel VBA programming by Examples (MS Excel 2016)

Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook

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

"]

Students: 85195, Price: $19.99

Students: 85195, Price:  Paid

Understand what you are going to achieve through the VBA by seeing demo and then see step by step explanation of VBA code. Learn about Excel VBA syntax, Excel VBA form and control, methods of  using forms and controls, several workout examples to see usage of Excel VBA for automation.

In this course, you will learn following stuff in step by step manner

Level 01 – start without coding – Automate tasks using Excel Macro recording

 

  • Demo of an excel macro

     

  • What is excel macro

     

  • When to use it

     

  • How to record a macro/create a shortcut action

     

  • How to run a recorded macro

     

  • How to create a shortcut for a macro action

     

  • How to run a recorded macro on a new dataset (excel workbook)

     

  • How to record a relative macro

     

  • What is the difference between a relative macro and a general macro.

     

  • How to understand what was recorded as macro.

     

  • How to delete a macro

     

Level 02 A – Understand Excel VBA integrated development environment

  • How to reach VBA window

     

  • What are different component of the window

     

  • What is use of those components

     

  • How to use breakpoint, properties window, edit tools etc.

     

Level 02 B – Understand Excel VBA syntax

 

  • How to define a variable

     

  • Different types of variables

     

  • How to write a for loop

     

  • How to display output in an interactive way

     

  • How to write output in a different worksheet

     

  • How to take user input through a prompt

     

  • How to use user input

     

  • How to use record macro to know VBA syntax

     

  • How to use breakpoint

     

  • How to run macro through click of a button

     

  • When you need to write do while / do until loop

     

  • Syntax of do while / until loop

     

  • How to take input from excel sheet for program execution

     

  • How to ensure variable names are correct before execution of program

     

  • If else command, If elseif else command

     

  • Using mod function (for remainder)

     

  • Showing status bar

     

Workout Examples 01 – Using Forms for user entry, chart display etc.

 

  • See a worked out example of a VBA form

     

  • Learn about various control, design aspects of Excel VBA form

     

  • Learn about why will need form, and such controls

     

  • Hide Data sheet and format other sheet to make it look professional

     

  • Ensure proper data type

     

  • Ensure value selection from combo box only

     

  • Learn to define level, text, combobox and button command

     

  • Learn to pass dropdown data in combobox

     

  • Learn to use form entry into VBA

     

  • Learn to write back on Excel form

     

  • Learn how to load form while getting excel started

     

  • Learn to change properties of control through VBA

     

Workout Examples 02 – fetching data from MS Access using Excel VBA

 

  • How to use Excel as front end and fetch data from microsoft Access database

     

  • Where to use this à Greatly useful when many users have Excel but don't have MS access database in the PC

     

  • Where Reference is needed

     

  • Watch window - how to use it

     

  • How to edit the code for many fields and different databases

     

Workout Examples 03 – One sheet per product or agent

 

  • How to use do while loop to let it run for as many records as it has got

     

  • How to find block size (starting and ending row for each product)

     

  • How to add sheet using VBA and give it a name

     

  • How to ensure that the tool remains intact with multiple runs and even a mistake can't cause issue

     

  • How to repeat header in each tab or worksheet

     

Workout Examples 04 – Inventory management, coupon assignment and customer communication using Excel VBA

 

  • Traverse through various sheets and workbooks using VBA          

     

  • Formatting date              

     

  • Writing derived information from one sheet to another 

     

  • Passing several parameters to VBA for conditional traversal         

     

    • 3 should mean three coupons to get reserved

       

    • [Coupon code : Validity] will need comma if there are multiple vouchers

       

  • Error handling : alert, if there are no coupons     

     

  • Protecting Excel tool for further usage   

     

Workout Examples 05 – Reading data from a microsoft access database and writing it into a text file

  • Reading Microsoft Access data using VBA

  • directly writing output into a text file

  • Making the output comma separated 

Workout Example 06 - Designing survey form in Excel VBA with option buttons / list box etc.

Workout Example 07 - Insert Excel VBA form data in MS Access database 

Workout Example 08 - Using pivot table, vlookup and several other formula for a sampling work 

Workout Example 09 - Windows based user authentication and Voice notification of execution of VBA

Workout Example 10 - Running SQL command through VBA. Read Excel sheet as a table inside VBA

You will learn

  • Reading complete worksheet data into a table

  • Managing named as well as unnamed headers

  • Running SQL command inside VBA

  • Little advance SQL coding as well (by product)

    • A-B

    • B-A

Workout Example 11 - Voice based reminder tool

You will learn how to remind speaker about how much time is left through automated announcement.

Workout Example 12 - Running VBA code in automated manner

You will learn what is takes to used Windows scheduler to schedule the VBA code to run in automated manner with desired frequency.

Workout Example 13 - Recursive file and folder size within a folder

Many a times we need a tool, which should recursively put file names and file sizes within a folder.

I mean to say that, if you pass name of a folder and say in that folder, it has

  1. 11 files

  2. 2 folders

    Then it should again go into the 2 folders and if it finds a folder again say in any of the folder, it should go within that folder too and should create result, with name and size of all the files & folders.

Workout Example 14 - Combine all the files inside a folder through VBA

Tasks

1. Combine Multiple files - having same layout (same number of fields and fields are always in the same column) but not neessarily same number of rows

2. Also put file name as first column in the final data set

Assumption:

  1. All the data files are in the same folder

  2. There is nothing other than data files in that folder

  3. Usually data files should have a way to know, which file was referred

  4. All the data files are excel files only

Excel Formulas and Functions with Excel Formulas Cheat Sheet

Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 84646, Price: Free

Students: 84646, Price:  Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Formulas and worksheet functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating and obtaining useful information and insight from your data.

Without formulas and functions, Excel spreadsheet is simply a fancy word-processing document. Welcome to my Excel Formulas and Functions for Beginners course!

I designed this course for beginner level Excel users. But are you an intermediate level Excel user? Want to have a broader, deeper and in-depth knowledge in building Excel formulas and functions? This course is also for you!

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly more than 15,000 Excel users visit my Excel blog ExcelDemy and read my Excel and data related articles and tutorials.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the formulas using Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your Finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.  
  6. Circular Referencing: Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with formulas, and so on.
  7. DATEDIF() and Date related Excel Functions: And I will finish this course with DATEDIF () and other Date related Excel functions!

I am assuring you that what you will learn in this crash course is priceless. I designed this course keeping in mind, to give you a solid base in Excel formulas and function. Thanks for watching. Enjoy the course!

Excel Essentials: The Complete Excel Series – Level 1, 2 & 3

Excel: The WHOLE Excel Mastery Series In One! From Excel Novice To VBA Programmer - Excel 2013, 2016, 2019 & Excel 365

Created by Alan Jarvis - Everything Is Easy, Once You Know How - 100,000+ Students!

"]

Students: 82746, Price: $149.99

Students: 82746, Price:  Paid

Over 120,000 students in 201 countries are becoming Excel masters with THIS series. Check out the FREE PREVIEW LECTURES and SEE WHY!

This COMPLETE* course is one of the HIGHEST RATED courses anywhere on Excel, with over 9000 5 STAR REVIEWS:

*Why buy 5 individual Excel courses, when this one complete course will give you everything you'll ever need?

What other students are saying:

"This may be the single, greatest course on Excel in existence. It is that good. Concise, yet comprehensive and informative. The instructor has a gift for teaching in an old-world, grade school type of way, which I find particularly useful. He explains each new concept quite clearly and then builds upon the concepts to establish a very strong foundation. Remarkable class and presentation. I highly recommend this instructor. Brilliant." - Kevin Ward (May 2020)

“Course is more than I expected. Instructor provides in depth knowledge of Excel and is effective at communicating it. This course, practice and effort are making me an Excel WIZ ! Thanks Alan.” – Tom Howard (April 2020)

“This course is by far the best course on Excel. Alan is a great instructor and has an art of teaching from the grassroots level and gradually building up to the advanced level which I think is a great way for the concepts of Excel to sink in the brain.” - Kshipra Jawdekar (April 2020)

Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee and YOU CAN EARN MORE MONEY!.

If you run a business, being proficient in Excel can help you see your business in a completely different light.

Congratulations!

If you are reading this, you have already taken your first important step. You want to learn Excel from the ground up, and go from a complete beginner, to super user, to being part of the few Excel Elite, and being able to program your very own full blown applications using VBA (including automating not only Excel, but Outlook, Word, Powerpoint and even Windows itself!).

This complete course contains all the lectures, quizzes, projects, and downloadable resources contained in Levels 1, 2 and 3. In fact, everything you will need to go from novice to coder! There's no need to buy one course after another to become an Excel master...it's all here!

Yes, but 27 hours, Alan?

Don't worry! We have a very (very) active student forum, so new lectures are regularly added in the SQA Sections (Student Questions Answered). If I can't explain something in a post, or I get a particularly interesting question, I'll make a video for you to walk you through your own specific sticking point!

You can find the detail of each section below, but here's a summary of how it breaks down:

Level 1 Beginners: Base course - 3 hours, SQA - I hour

Level 2 Advanced: Base course - 6.5 hours, SQA - 2 hours

Level 3 VBA Programming: Base course - 11.5 hours, SQA - 3 hours

The course is structured so you can dip in and out whenever you want...you don't have to do it all at once :)

Here's what you get inside...

In Excel Essentials: Level 1 Basics - Master Excel Step-By-Step

  • Average review HIGHER than the other Microsoft courses on Udemy!

  • Average minutes viewed 27% HIGHER than other Microsoft course!

  • New students join THIS Excel course EVERY DAY!

Great news! I have added a new bonus section to this course "Student Questions Answered"!

In this section you will find custom made tutorials to answer YOUR specific questions! Just drop a message in the discussion board, and if I can't answer it in a simple message, I'll make a video just for you!

What other students are saying:

"This is the most comprehensive course I've seen on Udemy..." - Renato Ferreira

"This course is a must and it could be the only one you need, if you want to master Excel for any reason. It is well organized, it covers all topics of Excel, from the fundamentals (formatting, writing data, put that data to use, etc...), continuing to a more advance use of the program, like applications for the formulas included in the app. But the part that outstands in the course, is the macro-programming part. It helps you to start programming in VBA in a step by step fashion. The instructor explains every lesson quite well, he is easy to follow, and you can notice he knows the app and have lots of experience with it. He is also very responsive and will reach you as soon as he can in case you have any doubt about the topics covered in the course. For me is a five stars course, thumbs up for a well roundup course." - David Garcia Silvarrey

"This is the best Excel course ever! I like that the topics are broken down into few minutes at a time". - Sheryl Blosel

"This course is wonderful. If you were and absolute beginner like I was, this is the course that you should take. This course starts at the absolute beginning and shows you in detail how to use the program and how to make it do what you need it to. I am almost through section 2 and I cant believe how much I have learned and I couldn't imagine taking an Excel course from anyone else. If you are thinking about getting an Excel course for refreshing your skills, or just starting from the beginning, this is the course for you" - Jake Rose

Next to soft skills, being able to use Microsoft Excel well is probably one of the most sought after skills employers are looking for in today’s competitive market. Make sure you can compete…

  • Do you want to master one of the must have skills for any work place?

  • Are you willing to invest a little time now for your own future?

  • Want to learn powerful, little known tools most users don't know about?

  • Do you want to get ahead of your competition?

If you are a complete beginner looking to master Excel, or you just want to brush up on the basics, you've come to the right place. If you want to earn more money by developing a skill set that today’s employers demand, this is the course is for you!

Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.

Many of my students have gone on to get better paying jobs, change career, or even start their own businesses, using the very skills you will soon master.

“I spent over 30 years mastering Excel, so you don't have to!”

In this course we cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it.

Who is this course aimed at?

Complete beginners, and those who want to build a solid foundation upon which to build their skills.

How is it structured?

Together we concentrate on building a single complete project from beginning to end, using all the basic functions and give you a thorough understanding.

I know your time is valuable, so most lectures are between 3-5 minutes, allowing you to dip in and out when it's convenient for you. This also maximizes your learning, and makes it easy if you ever need to go back to refresh your memory...no need to click through a 40 minute lecture to find the part you're looking for!

There are screencasts, lots of quizzes, presentations, pdfs, downloadable files...all designed to optimize your learning.

What do I get with this course?

  • Lifetime access to over 4 hours of HD content.

  • Over 50 bite-size lectures, each covering a specific topic in detail. Some of which I have never seen taught before!

  • Multiple quizzes to ensure you cement your learning!

  • Downloadable source file, practice file, and pdf cheat sheets that you can take with you and quickly refer back to if you are away from home.

  • Access to the Q&A forum, so if you have any questions, you can ask me!

What other students are saying:

"This course is exactly what I was looking for. Simply explained, and in a level of detail I could follow. I really enjoyed it, and will recommend it to all my friend"s – Beatrice

"This course [Level 1] gives a solid foundation for a beginner who wants to develop their skills...To sum up Folks, this is a HIGHLY RECOMMENDED course. I will be shortly enrolling myself in the next course with Alan of course" – Alex

"Fantastic course! The instructor is extremely knowledgeable and the way he organized the course makes it extremely easy to follow. I highly recommend this course to anyone looking to increase their knowledge of Excel." – Dan Hughes

So, Why take THIS course?

I have been using Excel for over 20 years, but there is a difference between being good at something and being able to teach it. In that time I have taught thousands of people how to master its power. Because I have taught so many people, I know not to assume you already understand something, and I have probably already heard every question you are likely to have.

This course took over 4 months to produce, and has been tested extensively with hundreds of people. If something didn't work, or wasn't clear, it was revised until it did, to make this the best possible course on Excel.

Of course, we never stop learning, and I will continue to develop this course, and your skills, with your feedback. And remember, if you have a question, post it in the Q&A and I will answer it for you personally.

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

In Excel Essentials: Level 2 - Intermediate/Advanced:

THIS course will take your Excel skills to the next level!

  • New "Student Questions Answered" added

  • The HIGHEST RATED Excel Level 2 course on Udemy!

  • Average minutes viewed almost triple that of other Microsoft courses!

So, you have an understanding of the basics, but would you like to use Excel like the professionals? If so, read on…

For students who have already completed Level 1 in this series, or already have a good basic understanding of Excel, what you will learn in this course will supercharge your skills... and your career.

So, What’s inside?

  • Over 90 bite-sized lectures

  • 8.5 hours of quality HD content

  • 41 downloadable resources

  • All the source files for each project

  • Access to me (in case you have any questions)!

You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. We will do this by creating multiple projects together, step-by-step, and in depth to guarantee your understanding. Each project builds on the last, so your skills develop cumulatively.

What other students are saying:

"This is a great course for anyone wishing to learn or brush up on the basics. The presentations are easy to follow!" – Pamela Reyna

"This is a very simple, clear and concise and easy to follow course that is perfect for beginners" – Sean Loftus

"The author of this course takes you through it one simple step at a time, and it is really easy to follow. I like that the lectures are short, and focus on one thing at a time, which was perfect for me. I actually now feel confident using Excel. Well done and thank you!"– Nickie Student

You will learn how to combine multiple functions in a simple way to create powerful solutions that most users believe can't be done in Excel!

Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.

In Project One:

  • The fastest way to create powerful dynamic templates (by cheating!)

  • Custom formatting

  • Manipulating calculations with time and dates

  • Conditional formatting

  • Simple and nested logical testing

  • Building complex and dynamic text strings

  • ActiveX controls (and how to customize them)

In Project Two:

  • Building a fully functional complex relational database

  • A Masterclass in Vlookups (WAY beyond the basics here!)

  • Importing data from multiple sources

  • Controlling user entry

In Project Three:

  • Creating named ranges (and why you would want to)

  • Building dynamic named ranges

  • Getting Excel to create them for you!

  • A powerful trick very few users know about!

In Project Four:

  • Hyperlinking (so it ALWAYS works!)

  • Creating Macros, and using them to automate your work!

  • Executing Macros from buttons

  • Dropdown lists

  • Building dynamic formulas using Excel’s Indirect function

In Project Five:

  • Project management made simple with Gantt charting!

  • Have your chart timeline ALWAYS begin at the best date

  • Nesting multiple logical tests (simply!)

  • Making your timeline completely dynamic by changing a single cell!

This isn't just a course with a bunch of formulas, it's hands on guide through real life projects. You will learn how to build complex solutions using the very same methods I use.

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

In Excel Essentials: Level 3 - VBA Programming:

If you really want to harness the full power of Excel, then learning how to program in VBA is ESSENTIAL!

If you got this far, it's because:

  • You want to join the Excel elite, and program your own solutions?

  • Maybe you want to automate most of your work, do more in less time with less effort?

  • Could be you want to earn more money?

  • Perhaps you may even fancy a career change?

If you answered yes to any of the above, I want you in my student community!

In this course you will learn everything you need to know about coding in VBA, even if you've never looked at a line of code before!

What other students are saying:

"This is a great course! ...I can't wait to start using it. I will certainly be using the emailing program! And reports. My mind is reeling!" - Nickie Student!

"Taught in easy bite size chunks makes the learning fun as well as informative" – Joe Long

"If you are serious about learning how to make excel work for you, you should take this course" - Beatrice

Introducing Visual Basic For Applications

Visual Basic for Applications, or VBA, is included with Excel, so there's nothing more to buy. If you have Excel, you already have access to VBA.

VBA is the powerhouse. It's the code that lives under the hood where the magic happens.

A lot of people can record a Macro, but being able to program in VBA is quite a different thing. It separates the good from the truly amazing, and I want you to be amazing!

Now, one of those words in "Visual Basic for Applications" carries more weight than the others. And no, it's not "Basic" (though coding the way I will teach you is simple!).

No, it's "Applications". In fact, it's the "s" at the very end. The significance is that VBA works across ALL MICROSOFT APPLICATIONS! Word, Outlook, Access, PowerPoint, Internet Explorer, and even WINDOWS ITSELF!

In this course I will not only teach you how to code for Excel, there are even THREE, no...FOUR Bonus Sections:

  • Controlling Word

  • Controlling Outlook

  • Yes, even controlling Windows

  • and now...Automating PowerPoint!

What Makes Me Qualified To Teach You?

Well, I'm a regular guy. I don't have a University degree, but what I do have is the drive to learn new things and never be beaten by a problem...a lot like you, I guess.

What I also have is over 20 years of experience in using Excel, and programming solutions with VBA.

I have built simple helper systems to make life easier for my colleagues. I've programmed complete MRP systems to run the procurement division of a £1.3b company, and everything in between.

So, I can do it, does that mean I can teach you?

You bet! I have taught hundreds of students one on one, and even more in groups. Many of my students have gone on to better paying jobs, start their own businesses, or at the very least made their work lives less stressful! One of my most recent students got a promotion and a 15% pay rise just 16 weeks after learning how to code! Not bad, hey?


Why Is Your Course Different, Alan?

I'm glad you asked!

If you got this far, you already know you get:

  • Over 15 hours of HD video lectures

  • 72 downloadable resources

  • Quizzes

  • All the source code for the course + more!

  • Programming projects

There are lots of great courses on coding in VBA. There are even lots of free videos on YouTube. Many of them show you all the basics in kind of a "little bit of everything" approach. I looked at what was available, and I knew I had to create something different. Of course, I still cover all the basics, just like the other courses, but we will go beyond the basics, and cover in depth the "missing bits".

In addition, I will teach you my step-by-step process, the actual methods I use to build powerful solutions easily and quickly. I'm sure programming can be difficult, but not the way I do it!

You will learn how streamline your code for efficiency (and make it execute faster!) from the beginning. After we've covered all the basics, we will go on to create 6 separate projects using those very tools and techniques, where we will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!

What other students are saying:

"I'm coming close to finishing this course...This course has given me the knowledge and confidence to succeed, get promoted and think seriously about building a career based on what I can learn from great teachers like Alan." - Thomas Heaton

"Alan is an excellent tutor, goes very deep into every single thing, and he is not bothered to repeat even the smallest tricks and tips along the way. I feel like I got amazing new skill, this course has opened my eyes on how I should "see" excel from now on. Definitely the best course I have ever taken on Udemy" - Aleksandar Stankovic

With So Much Power, What Will You Create?

With the skills you will learn in this course you will be limited only by your imagination.

If you can describe it, you can most likely code it. What will YOU create?

Let's see. Enrol now, and I look forward to welcoming you to the course!

Best Online Excel Training | Best Shortcuts in 30 mins.

Quick useful guide to learn Excel Shortcuts (Save time & Money) [Excel 2007 - Excel -2019]

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

"]

Students: 69683, Price: Free

Students: 69683, Price:  Free

The list of 1000s of Excel shortcut keys are NOT to be memorized. It will torture your grey cells! So we have used industry practices and our Ninja Instructor's experience to handpick those shortcut keys which will meet your work requirements, make you look like an accomplished Excel Ninja.

This course is best suited for MS Excel 2007-2019 (Windows PC).

Not suited for Mac.

The best part is you can learn them in 30 minutes and start showing off at your office. Join now for a Complete No-Nonsense Course on Excel Shortcuts.

Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox

Created by John MacDougall - Microsoft Excel MVP

"]

Students: 69241, Price: Free

Students: 69241, Price:  Free

In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst. 

  1. Text to Column
  2. Flash Fill
  3. Recording a Macro
  4. Grouping Sheet
  5. Deleting Blank Rows
  6. Remove Duplicate Data
  7. Auto Sum
  8. Filling a Range with Ctrl + Enter
  9. 3D Sums
  10. Advanced Filters

Bonus: Conditional Formatting

These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.

MS Excel – From 0 to Working Professional in 1 hour

Learn Excel as fast as possible

Created by Jason Zhang - Financial Analyst

"]

Students: 65003, Price: Free

Students: 65003, Price:  Free

This course covers Excel basics in the way that's very short and concise. You may use Excel before but this course shows you a better way of using these functions in real work environment. If you are going back to workforce, or looking for jobs, this is the fastest way to refresh your skill or Jump Start your skills. Within 1 hour, you can use Excel the way a working professional would use.  

This course IS NOT for everyone because of 2 things

1. Excel is powerful. Microsoft tries to make Excel as relevant to anyone as possible. However, each occupation use Excel differently. I've no idea how scientists or engineers use Excel. But I know how working professionals, especially analysts use Excel. I've worked as Business Analyst, Market Analyst, and till this day a full time Financial Analyst. Excel changed my life, I get hired, get promoted because that. I hope more people can do the same and better.

2. The pace of the course is super fast. If you like things go slowly, this is NOT for you. This course covers basic Excel. Most of the things in this course should be learnt by doing. Therefore I have enclosed a downloadable workbook. You can see me demonstrating on the left side of the sheet, while you would be practicing on the right.  

Boost Your Excel Skills: Crash Course w/ Downloadable Files

Microsoft Excel: Hone Core Skills in Microsoft Excel in 1+ Hours (Downloadable Excel Files Included in Course)

Created by The ProductivityMe Company - Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

"]

Students: 59750, Price: Free

Students: 59750, Price:  Free

Course Highlights:

  • 10 Individual, Bite-Sized Lessons
  • Downloadable Excel Files
  • Verifiable Certificate of Completion
  • Instant Access to Instructor and the ProductivityMe Community
  • 1080p HD Quality Video

In this Course:

Learning Excel takes time, particularly if you try to do it without any structure!

In this course, we'll walk you through the top ten skills you need to know in order to excel in Microsoft Excel!

Give us an hour, and we’ll help you to get to the next level of mastery in Microsoft Excel.

In this short, easy-to-follow training course...

We'll Cover:

  1. Autosum
  2. The Quick Access Toolbar
  3. The Shortcut Menu & The Mini-Toolbar
  4. The Quick Analysis Tool
  5. The Fill Handle
  6. Flash Fill
  7. Charts & Graphs
  8. Recommended Charts
  9. Sorting & Filters
  10. Tables

Our Approach:

At the end of each video, you have the chance to prove your mastery by completing a small practice exercise thus testing the core skill that you’ve just learned.

You can easily follow along in each lesson by using the downloadable course exercise files provided in Lecture 2.

If you have questions, comments, ideas, we’d love to hear from you. Email or message us any time.

Final Thoughts:

Alright, that’s it for now.

Look forward to having you in class!

Cheers,

Tolan & Ryan
ProductivityMe Co-Founders

EXCEL at Work – Complete MS Excel Mastery Beginner to Pro

Boost your Excel skills - Boost your career. Master Microsoft Excel worksheets, functions, & more. Excel 2016-2019 & 365

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 58432, Price: $99.99

Students: 58432, Price:  Paid

"Your Excel skills could land your next job."

    - Fortune Magazine

A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't.

Are you ready to land your next job and increase your pay by 13%?

This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.

Note: This course is specifically designed for learning on  a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.

You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:

  1. Create a basic Kitchen Remodel Costs worksheet.

  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.

  3. Create professional looking pie charts, bar charts, column charts and more.

  4. Create a table and a range and sort your data.

  5. Create pivot charts and tables to do lightening fast analysis of your data.

  6. Learn to use new features of Excel including 1-click forecasting and 3D maps.

  7. Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you'll learn in this course:

  1. VLOOKUP

  2. COUNT & COUNTA

  3. COUNTIF & COUNTIFS

  4. AVERAGE & AVERAGEA

  5. SUM, SUMIF & SUMIFS

  6. IF

  7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

  1. Spreadsheets

  2. Tables

  3. Ranges

  4. Pie, Column, Bar and Line charts

  5. Pivot tables

  6. Pivot charts

  7. Tons of tips and tricks to make using Excel easier every day.

So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course.

100% Satisfaction Guaranteed

Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free.

So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge.

Visually Effective Excel Dashboards

Actionable Excel Tips (Templates Included) You Can Use Right Now to Create Eye-Catching Microsoft Excel Dashboards

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 56679, Price: $109.99

Students: 56679, Price:  Paid

Creating an impressive, interactive Microsoft Excel Dashboard from scratch is not easy!

I used to stare at my empty sheet and wonder where do I even start?

You need a structured process in place to go from idea to outcome in a smooth way.

You'll find out all about it in the course. We setup two fully functioning dashboards from scratch.

This course doesn't just teach you a set of functions and features, but how you can use them together to create impressive reports.

It teaches you how to approach a new Dashboard project and how to structure your work so maintaining the dashboard becomes very easy not just for yourself but for anyone else.

Note: Course recently updated to include new content on dependent combo-boxes and info-graphic charts in Excel

What students are saying

"This course provides a lot of great tips which you can immediately apply to your spreadsheets, no matter what standard of user you are. I have been working in excel for a number of years and I am amazed at the number of simple tips I have learnt in such a short time. Fantastic." -- Carl Postians

"I learned something new and very useful in the first 10 minutes...awesome!" -- Nancy Bowens

What you learn

This course teaches you to create well-designed Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.

This Microsoft Excel Dashboard course comes with templates, tools and checklists that can be applied directly to your Excel reports.   

  • Excel dashboard & Report templates   

  • Checklists and design guidelines   

  • Excel workbook to follow along

What differentiates this course from the other Microsoft Excel Dashboard courses?

It includes:

  1. The entire process from idea to delivery - every single step without skipping key points.

  2. Tried-and-trusted techniques that are not only applicable to Excel dashboards but any Excel report.

  3. Includes Excel templates, tools and checklists that you can use for your own Excel reports.

  4. Relevant and up-to-date with industry needs right now, as it’s based on feedback and suggestions from finance professionals. 

  5. Lots of ideas and inspiration to help you come up with own report design

Complex topics are taught in a simple way by an instructor with 17 years of experience.

The course is designed to have an even balance between talking head and screen-cast.

Content is clearly organised so more advanced learners can jump in at any point and follow along with the relevant project file.

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 54092, Price: Free

Students: 54092, Price:  Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Welcome to my “Excel 2016 Pivot Table” course where you will learn how to create basic pivot tables.

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly around 15,000 Excel users come to my Excel blog and read my Excel and data analysis related articles and tutorials.

At the end of this course:

  1. You will be able to create and update basic pivot table reports using Excel 2016,
  2. You will be able to realize, why and when you can best use of Excel Pivot Table tool,
  3. You will be get used to with the features of an Excel Pivot Table Report
  4. And you will be able to handle the limitations and compatibility issues related Pivot tables.

Let me give you an idea what exact topics I am going to teach you in this course.

  1. I will show you the exact cases when you can use the Excel Pivot Table
  2. Then I will show you the anatomy of a pivot table report with a real life example.
  3. Then you will see the step by step by process of preparing a data source for Excel Pivot table
  4. Then you will learn how to create and update a basic pivot table report
  5. Then you will be introduced with the Slicer tool in Excel
  6. And at the end of the course, I will show you total three techniques that you can use to will save your time when you’re working with Excel Pivot tables.

I have designed this course for new comers in Excel pivot table feature. But if you are an intermediate level user and want to be get used to with Excel 2016 Pivot table feature, then this course is also for you. This course will give you a simple but powerful introduction to the most powerful tool in Excel.

Feel free to take a look at the free previews of this course. I hope this course will change your view about Excel Pivot Table. Enjoy the course and thanks for reading!

20 Free Life Hacks to Inspire You to Excel in Business &Life

20 Free Videos to Inspire You to Live Your Life on Your Terms

Created by Chris Haroun - Award Winning MBA Professor, Venture Capitalist and Author.

"]

Students: 50375, Price: Free

Students: 50375, Price:  Free

Welcome to "20 Free Life Hacks to Inspire You to Excel in Business & Life."  This course is a collection of 20 of my favorite daily video Vlogs. Topics that we will cover include: 

Day 1: Finding Your Career Path and Happiness (What Hat Should You Wear)?

Day 2: How to Build Unstoppable Confidence

Day 3: Cut These People Off (Get Them Out of Your Life)

Day 4: Why You Need Yoda's (Mentors) to Take Your Career to the Next Level

Day 5: How to Focus Better!

Day 6: Interview Better, Sell More & Get A Promotion Faster by Being You

Day 7: How to Save $1,000,000+

Day 8: Failure Is Not Shameful Because You'll Never Make It Big Without Failing

Day 9: Goal Setting:A Simple Way to Increase the Chances of Achieving Your Goals

Day 10: How to Find Your Passion

Day 11: You Are 26 Years Younger Than You Think + 16 Other Positive Things!

Day 12: Visualize Your Goal, Vocalize It & Set A Deadline (Right Now).

Day 13: How to Meet Any CEO You Want! JACKPOT For Your Career!

Day 14: Quit Your Job & Start Your Own Company. (I Want To Help You Do This)!

Day 15: Get Into Your Natural High Zone to Boost Your Productivity

Day 16: Write A Book The Easy Way & Watch Your Career Take Off!

Day 17: Why Skeptics Can Be Great For Your Career & Business!

Day 18: How to Get Into Your Genius Zone So You'llBe More Productive & Love Work

Day 19: Why Frustration With Your Job is a Good Thing

Day 20: Liberating Your Fear of Failure

Thanks!
Chris

Master Microsoft Excel Macros and Excel VBA

Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 49823, Price: $49.99

Students: 49823, Price:  Paid

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016

Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.

During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.

Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.

Below are a few samples of the projects you will complete by enrolling and participating in this course.

  • Automate placing and formatting a title on a worksheet
  • Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
  • Cleaning up multiple Excel Worksheets and prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
  • Automate the creation of Excel Formulas to SUM data up in your Report
  • Working with Excel VBA User Forms
  • Importing Data from External Text Files

Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.

So, don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.

Microsoft Excel – Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 49142, Price: Free

Students: 49142, Price:  Free

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Data Analysis Essentials Using Excel

Learn to apply the important concepts and techniques of data analysis using Excel.

Created by Symon He - Author | Investor | MBA

"]

Students: 48011, Price: $109.99

Students: 48011, Price:  Paid

Ibadullah Khalil - 5 Stars

“A great instructor and guide for the course. All topics were well driven and to the point with no gibberish language used to make it difficult for the learners just like other instructors. A highly recommended course for every beginner who aims to become a data analyst”

 

Jianyong Chen - 5 Stars

“This is one of the best course I took on Udemy so far. The instructors explained everything in detail and there are practices after each section. Make sure you download all the files, practice on your own, and you will learn a lot. Highly recommend!”

 

 

Every business generates data.  But whether you're able to turn that into useful insights depends on your ability to process, manipulate, and ultimately translate that data.

Whether you're working for a company or running your own, being able to make better decisions requires you to be able to analyze and interpret data.  

What data do you need? How do you prep that data? How do you analyze it to answer specific questions?

In this course, we're going to show you step-by-step, exactly how to do that, by starting with the very basics.  

 

Why Microsoft Excel?

 

This course is as much about Excel, if not more, than data analysis concepts and techniques. Why?

 

Excel is still the most popular tool used by analysts in all industries, across all roles.  It's used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.  

Yes, there are many tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you'll be able to apply your knowledge to a broad range of applications.

 

Don’t underestimate Excel--a single worksheet can technically hold more than 17 BILLION data points (granted, it will make your computer REALLY slow). Fortunately, most of us running analysis will need to process far fewer data points than that. Still, it speaks to the power of the program.

 

Maurizio Zippo - 5 Stars

“This is one of the best course I have ever taken and thoroughly enjoyed. Highly recommended if you want to brush up your existing Excel Skills and to learn how to build some complicated formulae. The Pivot Table and Charts were something I always struggled with but thanks to Symon and Travis' explanations they are now so easy to use every day at work, saving me tonnes of time! Many Thanks Symon and Travis for putting together this great course you are my Excel heroes! The case studies on Cryptocurrency and The Start Up Market are absolute gems! I can't wait to get started with your next course.”

 

Why learn from us?

 

By signing up with us, you will be learning from two instructors with a combined 35 years of relevant experience across a wide range of analyst roles.  

 

Travis has been a digital marketer, investor, and entrepreneur for 20 years. He’s led growth in Asia for Groupon and even helped build Excel when he was as an engineer at Microsoft.  He is a data analysis and data visualization expert who pulls from his industry experience to teach some of the advanced data analysis topics you’ll find in this course. 

 

Symon has been interpreting and analyzing data for 15 years.  He has served as a financial analyst, marketing analyst, and even head of marketing analytics across half a dozen industries.  If you look at his other courses on Udemy, you'll see that he is an Excel and analysis ninja, having taught nearly 180,000 students with over 18,000 reviews.  

 

Together, we’ve pulled directly from our personal experience and put everything we could into this course. In fact, all of the case studies you’ll find inside are inspired by real-world projects we’ve worked on.

 

What if I don't have any data analysis or Excel background?

 

No worries! This is why we start with the very basics in our foundational sections, which is designed to get you familiar with Excel before we move on to more advanced topics.  You can be a complete beginner and take this course.  It might sometimes feel like you're drinking out of a fire hose, but if you put in the time and effort we promise you’ll see results by following our course and doing the exercises. 

 

We then progressively increase the difficulty as you move along in the course, culminating in advanced techniques taught through our case studies.  

If you do have an Excel background, you can skip or skim through the foundational sections and move directly into the more advanced topics.  

 

Stephen Dias - 5 Stars

“If you're trying to learn the foundations of excel this course is all you need.”

 

Brandon Parker - 5 Stars

“I have a lot of experience building excel models and purchased the course for the case studies. I didn't expect to learn much from the introductory parts but was surprised to find additional keyboard shortcuts I had never learned as well as powerful new functions that will make my life a lot easier. This course helped me brush up on functionality that I often neglected while using excel and was super comprehensive. I look forward to continuing using this course as additional case studies are added and highly recommend it for even excel experts.”

 

Learn through practice.

Like most things in life, becoming proficient at data analysis in Excel takes practice.  A lot of practice.

 

Sure, you'll pick up plenty just from watching, but you'll be doing yourself a disservice if you don't download our more than 100 custom-built Excel practice files specifically designed to help you master the program.

 

We're not done adding all our content yet, either.  This class was initially created an "intro" course, but it will soon become a complete coverage of all things data analysis in Excel.  

 

In conclusion, does any of the following apply to you?

 

    1.     Do you want to really know your way around Excel?

    2.     You have data for your work or business but you're not sure what to make of it?

    3.     You might know your way around Excel but you're not confident about turning data into business insights

    4.     You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions?

    5.     You want to learn the best practices when it comes to using Excel for data analysis.

    6.     You are intimidated by spreadsheets and terms like Pivot Tables and VLookups

    7.     You want to learn a skill set that is useful for any role in any industry you get into later.

 


If so, then take charge and take our course.

You have absolutely ZERO risk. Udemy gives you a solid-as-an-oak-tree 30-day money back guarantee.  You have nothing to lose and everything to gain.

So if you're ready to go from data deficient to data proficient, enroll now!

 

 

Easy Excel Basics for Beginners – Get Started with Excel

Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016.

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 42632, Price: Free

Students: 42632, Price:  Free

Learn the basics of Excel quickly and easily.

This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying.

This course will show you the basics of how to use Excel, how to create a basic spreadsheet, how to navigate quickly through a spreadsheet, how to create simple mathematical formulas and some shortcuts and keystrokes to save you lots of time.

You can go through this course in about 30 minutes. At the end you'll know how to create a sample spreadsheet that can calculate estimated kitchen remodeling costs automatically.

If you're ready to get your feet wet quickly and painlessly, take this easy introduction to Excel course and you'll see that using Excel can be easier than you think.