Best Excel Dashboard Courses

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

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.

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 Zero to Advanced: Data Analysis & Dashboards

Microsoft Excel Beginner to Advanced w/ Data Analysis, & Dashboards. Learn Pro Tips, Shortcuts, Formulas and Functions.

Created by Irfan Sharif - Bestselling Trainer | Chartered Accountant | PwC Alumni

"]

Students: 132534, Price: $99.99

Students: 132534, Price:  Paid

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.

Microsoft Excel is one of the most powerful data management, data analysis and dashboarding tool.

This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.

About this course:

Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.

Prerequisites:

There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.

Who should take this course:

First-time learners, who have no idea about Excel and want to start the right way. This includes:

  1. Students

  2. Professionals, especially those who have to work with numbers.

  3. Daydreamers who wish to bring financial sense to their dreams.

  4. Anyone who wants to learn a better way to manage the numbers and calculations.

Software Requirement:

You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.

Money-Back Guarantee: 

Nothing to lose! If you won't be satisfied with the course, Udemy offers 30 days money-back guarantee!

Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years

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.

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. 

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 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!

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.

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.  

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.

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.

Excel: From beginner to intermediate

Learn the skills that Microsoft want you to know in Excel.

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

"]

Students: 42093, Price: Free

Students: 42093, Price:  Free

What do others like you think of this course?

"Prior to doing this course Excel has always scared the heck out of me! I never expected to learn so much and am amazed by all the things that can be done using excel. It's so much more than just formulas! The course is really well presented and makes the whole learning experience comfortable and enjoyable. Thank you so much for putting together such a great course. I've already signed up to the intermediate to advanced excel course and I look forward to learning more about Microsoft Word in the future too... I imagine there are all orts of neat little tricks that I had no idea about!" -- Adam Shipley

"Phillip is a brilliant teacher of Excel . His explanations are clear , in-depth and very comprehensive" - xlongFx

"Awesome organization of course and well presented. I really loved the course. Of course as I am using excel for many years in work I was quite aware and using many features, but there are many details which helped me to polish my excel skills." - Manjunath Hirennavar

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

In this 11 hour course, learn how to:

Create and manage worksheets and workbooks

  • Create and navigate in Excel worksheets and workbooks,

  • Format worksheets and workbooks,

  • Customize options and views, and

  • Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

  • Insert data into and format cells and ranges, and

  • Summarise and organize data in Excel .

Create tables

  • Create and manage tables,

  • Manage table styles and options, and

  • Filter and sort a table.

Perform operations with Excel formulas and functions

  • Summarize data,

  • Perform conditional operations, and

  • Format and modify text.

  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

  • Create charts,

  • Format graphic elements, and

  • Insert and format objects in Excel .

The course will take about 10 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

Free Basic Excel Course + Lookup Function

Excel made easy for everyone

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 41781, Price: Free

Students: 41781, Price:  Free

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.

Microsoft Excel Data Analysis and Dashboard Reporting

Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 36764, Price: $99.99

Students: 36764, Price:  Paid

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.

The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools, including;

  • VLOOKUP() Function for Looking up Information
  • INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
  • TEXT() Function for Formatting
  • CHOOSE() for Ultimate Flexibility in Presenting Data
  • Advanced Filtering
  • Summarizing Data with PivotTables and Pivot Charts
  • Interactive Features to Create User Friendly Reports
  • VBA Magic to Create Dynamic Content
  • and more...


What's Included in the Course:

  • 30+ Video Lectures to Follow Along and Practice the Concepts of Excel Data Analysis and Dashboard Reporting
  • Downloadable Exercise Files
  • Instructor Support through the QA Section Found within the Course - Ask Your Questions!
  • Build a Real World Excel Dashboard
  • 30 Day Money Back Guarantee

Join me in this course and take your Microsoft Excel skills to new heights. The skills you learn will help streamline your efforts in managing and presenting Microsoft Excel data.

See you in the course!

2021 TOP MS EXCEL Templates and Dashboards with applications

Save your time and effort and automate your daily tasks and events with Ready awesome MS Excel templates

Created by SMARTER ACADEMY - Learn SMARTER, not Harder

"]

Students: 35893, Price: $89.99

Students: 35893, Price:  Paid

2021 TOP MS EXCEL Templates and Dashboards with applications

Save your time and effort and automate your daily tasks and events with Ready awesome MS Excel templates.

Free Excel templates to help you create spreadsheets with ease

Microsoft Excel is one of the most versatile and useful programs in the Office suite. It doesn’t matter if you need Excel templates for budgeting the next fiscal year, tracking your business inventory, planning out meals, or creating a fantasy football draft sheet, there are plenty of Microsoft Excel templates for you. For example, if you need to visualize data over a timeline, consider Excel Gantt chart templates, which are ready and available to be customized with your specific project information.

Excel’s capabilities don’t stop there. If you’re looking for Excel templates to use at home, consider a weekly chore schedule or household to-do list. These free Excel templates take the stress away from having to remember whose turn it is to clean the bathrooms or wash the dishes. Similarly, templates for Excel spreadsheet can also help you with short and long-term budgeting. These spreadsheets come with a wide array of built-in formulas that auto-complete after you fill out the first few rows. Any list or chart you can conceive of, an Excel template is there for you.

The Key advantages of MS Excel templates are

1. Ready.

2. Tested.

3. Save your time and Effort.

4. Optimize and automate  your time and daily works.

This Course is using MS Excel templates for

1. Personal tasks and jobs  templates.

2. Calendars for Personal usage and business usage.

3. Data analysis.

4. Personal Budget.

Reference: MS Office official website.

Haytham H. Elmousalami

SMARTER ACADEMY Founder, PMI-PMP®, Projects Engineer, M.Sc., Data scientist, Researcher, ICDL Instructor, PhD Candidate,  ...

Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 34335, Price: Free

Students: 34335, Price:  Free

During this introductory course on using Microsoft Excel 2010, we'll teach the basics of using Microsoft Excel 2010.

Your professional instructor will talk you through Excel 2010's features, starting with the basics, from creating files to editing existing documents. You'll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.


The course is designed for individuals and office professionals who need to learn the basics of Microsoft Excel 2010.

Excel Data Analysis Masterclass with Excel Dashboards

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

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

"]

Students: 19838, Price: $19.99

Students: 19838, Price:  Paid

Welcome to the best online course on Excel.

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

Hundreds of millions of people around the world use Excel.

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

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

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

You will learn to create interactive dashboards using excel.

In this course, you will cover:-

  • Basic formatting in excel

  • Datatypes of excel

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

  • Sorting and filtering data in excel

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

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

  • Finding different percentiles.

  • Finding missing values in data

  • Finding outliers in data

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

  • Learn about conditional formatting.

  • Learn about lookup functions- VLOOKUP, HLOOKUP.

  • Learn about index and match

  • Learn to create pivot tables and pivot charts.

  • Learn to create interactive dashboards.

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

  • Learn about performing linear regression in excel.

  • Advanced Filtering

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

We are also providing quizzes.

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

Instructor Support - Quick Instructor Support for any queries.

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

Enroll now and make the best use of this course.

Data Visualization with Excel – Crash Course

Learn Excel for Business. Learn the most useful features of excel to develop dynamic business dashboards and Graphs.

Created by Mobeen Ayub - MBA, Entrepreneur, BI enthusiast, Leadership Trainer

"]

Students: 13273, Price: Free

Students: 13273, Price:  Free

1. Learn to create a database and some excel formulas and shortcuts common for people in Universities and Corporate roles.

2. Learn to create different metrics and KPI's (Key Performance Indicators) from the main database in the form of Pivot Tables which update automatically when you update data in the main table.

3. Learn to visualize data in the database in the form of different charts which automatically update when you update the data in the table.

Excel Dashboard and Data Analysis Masterclass

Create 6 Interactive Microsoft Excel Dashboards from Scratch (Excel Dashboard Templates Included) - 2021 Updated!

Created by Andreas Exadaktylos - Best Selling Teacher | Msc Computer Scientist

"]

Students: 11673, Price: $89.99

Students: 11673, Price:  Paid

COMPLETELY REDONE ON APRIL 25th 2021 WITH OVER 100 BRAND NEW VIDEOS!

Excel dashboards are a powerful way to leverage Excel functionality, build and manage better presentations and improve your Excel and data visualization skills. In this course I will use my 20+ years of Excel training to show you how you can turn Excel into your own, personal Business Intelligence tool and create Interactive Charts and awesome Dashboards in Microsoft Excel. 

Learn how to make 6 well-designed Dashboards from Scratch!

Content and Overview

Hi!

Welcome to the brand-new version of The Excel Dashboard and Data Analysis Course, Udemy's best-selling dashboards course.

This course was just completely overhauled to prepare students for the 2021 job market, with over 12 hours of brand new content. This is the only course you need to learn excel dashboards and data analysis.

There are a lot of options for online excel training, but this course is without a doubt the most comprehensive and effective on the market. Here's why:

  1. This is the only Udemy course taught by a professional Bootcamp instructor-teacher with over 20 years of experience in Excel, and a track record of success.

  2. Everything I cover is up-to-date and relevant to 2021's excel data analysis job market. This course does not cut any corners. I just spent 4 months redoing this behemoth of a course!

  3. We build 2 projects, 2 complete dashboards. No other course walks you through the creation of creating a dashboard, with such details.

  4. The course is constantly updated with new content, projects, and modules. Think of it as a subscription to a never-ending supply of developer training.

Throughout the brand new version of the course, we cover tons of excel tools:

  • We’ll start by covering the key Design principles of dashboards, the creation process, color tips and layouts.

  • Then I’ll walk you through all the methods of importing data into Excel.

  • After that, I’ll explain in detail over 20 functions and formulas that we use in dashboards.

  • Then we’ll dive into basic charts, advanced charting techniques, and basic dashboard components, like sparklines, data bars, color scales, icon sets, etc.

  • Once we’ve mastered the basics, I’ll walk you through all the advanced dashboards components, like drop-down lists, filters, panel charts, rollover method, etc

  • Also, I’ll walk you through over 5 different interactive advanced charts, like bullet graph, small multiples, and infographics.

  • After that, I’ll explain in detail all the form controls with demo and examples.

  • The next section is about data analysis using pivot tables and charts.

  • Once you complete a few sections, you will enter the first major milestone project. Here we combine all the methods you learned, to create a social media dashboard.

  • Finally, you’re going to create together with me 4 dashboards from scratch starting with planning and setup.

    • A business sales dashboard

    • A KPI dashboard

    • A Pivot Slicer Dashboard

    • A Traffic lights Dashboard

  • All these come with templates and samples that can be applied directly to your business.

  • After that, you will enter the second major milestone project, and you are going to create with me an auto part sales dashboard.

  • I cover also how to protect and share your dashboard with the outside world.

  • Also, you’ll learn advanced topics, like how with the aid of a macro and simple VBA code, little touches will help make the perusal of your dashboard a bit more pleasant.

  • Once you complete every section, you’ll have quizzes and exercises to solve and fully understand the theory.

  • If you want to study offline, I have over 100 pages of documentation, and a detailed table of contents, so you can easily find anything in the course.

  • You are going to get access to over 50 examples and files that apply to your work. You can immediately download and use them along with the code-free version, so you can follow along with me.

This course is also unique in the way that it is structured and presented. I've incorporated everything I learned in my years of teaching to make this course not only more effective but more engaging.

If you have any questions, please don't hesitate to contact me. I got into this industry because I love working with people and helping students learn.

Enroll now and enjoy the course!   

So, if you are a professional looking to become more efficient at building excel reports and dashboards, sign up today for immediate lifetime access to over 10 hours of high-quality video content, downloadable project files, quizzes and homework exercises, and one on one support.

And by the way, at the end of the course don’t forget to print out the certificate of completion.

If you're not 100% satisfied there is a 30-day money-back guarantee!

Now, don’t just take my word for it. Check out what my past students had to say about my courses:

Testimonials for this Course

"I learned so many new excel tricks from this course. It covers almost everything. Andreas impressed me for updating his course so often! It worth every cent. Great job!" - Chris K

===================================================================

"Outstanding course! Very thorough and easy to understand. Sample spreadsheets make it very simple to follow along and provide hands on work. I would highly recommend this course." - Kelli Kellen

===================================================================

"A strongly recommend the course for all type of excel users. The lecturer follows a systematic and inspiring approach to present the most important techniques for data visualization with Excel." - Tommy Kalman

===================================================================

*** learning is more effective when it is an active rather than a passive process ***

Euripides Ancient Greek dramatist

New Reporting Features in Excel 2013

Create great looking dashboards with the new reporting (and a few other) features in Excel 2013.

Created by Matthew Bernath - Entrepreneur | Engineer | CFA® charterholder

"]

Students: 11182, Price: Free

Students: 11182, Price:  Free

Create great looking dashboards with the new reporting (and a few other) features in Excel 2013.  This short course gives you an introduction to some of the new features, together with practice workbooks.  From PivotTables to Recommended Charts and Flash Fill, this course will quickly get you up to speed with some of the changes from previous versions of Excel.  A preview of the Forecast functionality in Excel 2016 is also shown.

This course is ideal for anyone upgrading from Excel 2010 (or lower) to Excel 2013 or Excel 2016.

Microsoft Excel – From Excel Beginner to Excel Expert

Learn Pivot Tables, Formulas, Charts, Data Analysis, Dashboards, VBA, Macros & More for Excel 2010, 2013 or Excel 2016

Created by Martyn Blythin - Data Minded Excel Training, 30,000+ students

"]

Students: 11099, Price: $59.99

Students: 11099, Price:  Paid

Just imagine what it would feel like if using Excel was effortless - if you could create charts, functions, and analyse data with ease. Becoming an Excel expert isn't about learning what every button and every formula does - it's about learning methods you can use over and over again to effortlessly clean, enrich and analyse data.

I bet your a bit like me, you've tried learning through trial and error, but it takes a long time and involves a lot of mistakes along the way! I've been using Excel for over 15 years and there's still a few functions I've never used. The good news is that you can become an Excel expert in just a few hours by learning the right tools and approaches to use. How would it feel to have those skills on your resume and at your next job interview?

So, you want to become an Excel expert but you don't want to overwhelm yourself with stuff you're never going to use and you need the skills for your job, or the next job you hope to get. As I see it, you have three options. First, you could take a classroom based course and try to learn it all in a day, but from experience I know many people who have just been overwhelmed with the amount of information and the pace of learning. Second, you could do absolutely nothing, stay exactly where you are right now with your Excel skills. Or third, you could give this a try, work it alongside your current job and be genuinely good at Excel within a week or two.

We designed this Microsoft Excel - Excel from Beginner to Advanced using feedback received from over 30,000 students over years who told us they wanted opportunities to advance Excel skills. This course has it all, including:

  • Downloadable challenges to test your knowledge.

  • Multiple choice quizzes at the end of each module.

  • Each lesson has a downloadable Excel file containing the examples used.

  • Cheat sheets for functions & excel keyboard shortcuts that you can have at your desk for reference.

  • Ask me any Excel question on the course message boards.

  • A certificate of completion at the end of the course.

The course covers all levels, from beginner to advanced, so you don't have to worry about if the course is right for you, and you don't have to buy multiple courses for each level of your Excel knowledge! The course is split into 6 core modules:

  • Module 1: Master The Basics - Useful excel for beginners, including Excel fundamentals

  • Module 2: Your Data Gameplan - cover how to organise your data including Excel filters

  • Module 3: Your Functions Toolkit - Learn Excel advanced formulas and functions

  • Module 4: Your Data Analysis Strategy - The Complete Microsoft Excel Pivot Tables and Pivot Charts including Excel pivot table basics and data analysis Excel

  • Module 5: Your Dashboard Playbook - Learn how to create an Excel Dashboard

  • Module 6: Your Excel Automation Machine - Learn how to create an Excel macro and use Excel VBA code to automate your work. Excel vba programming is an extremely powerful tool, once you know the basics.

The course also comes with everything you'd expect from a great online course, including:

  • Lifetime access to the material

  • Unlimited free updates to the course

  • 30 day money back guarantee

If you're prepared to give this a try, then we're certain you will see the results as early as the first day you try it.

Here is what students said about this Excel course:

"Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!"

- Mary J. de Guzman

"This is a really great course. He started at what I would definitely consider an intermediate Excel level--and I even learned some things during that part--and then took us well into advanced Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course."

- Randy Crane

"Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion."

- Kaushal Vyas

Who is this course for?

This course can be used whatever your industry - anything from Excel for Accounting and Bookkeeping to excel for investment banking or Excel for data science. Anyone who is looking to achieve excellence in Excel and advance excel skills at work and on their resume.

Excel certification

Although this course does not issue an official microsoft excel certification, it includes a Udemy certificate of completion which you can use to illustrate your Excel skills on your resume and in interviews.

Easy Excel Dashboards, Models, Visualizations & Power Query

Build Professional Dashboards with No Formulas. Rapid Step by Step Beginner to Advanced. Get & Transform Data with Ease

Created by Jonathan Ng - Data Science and BI Strategy

"]

Students: 10720, Price: $99.99

Students: 10720, Price:  Paid

Rapidly build robust dashboards in Excel by following a simple step by step process that requires no formulas. Beginners can get started easily due the lack of formulas. Advanced users will learn to structure their dashboards like software developers so that they become more automated with no additional work. 

Not many people are aware how much can be done with no or very few formulas in Excel. This not only makes the design simpler it also makes it more robust, reduces risk and improve performance. 

Jonathan trained as a Microsoft Certified Trainer and has used advanced Excel for over a decade. 

Microsoft Excel Dashboards & Data Visualization Mastery

The only Microsoft Excel Dashboard, Data Visualization & Data Analysis course for INTERMEDIATE to ADVANCED EXCEL users!

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 10212, Price: $99.99

Students: 10212, Price:  Paid

You’re Just Seconds Away From Leveraging Microsoft Excel Dashboards, Data Visualization & Data Analysis That Will Make It Possible For YOU To:

  1. Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

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

This course is the first of its kind! 

A course tailored specifically toward the Intermediate to Advanced Excel developer. If that's you, you likely spend hours each day in Excel. Whether that's managing finances, making projections, tracking projects, and creating Excel dashboards for special projects.

You are not new to Excel. In fact, you can wrangle your way around most features and concepts. However, what you really need is instruction. Searching Google and forums can only get you so far.

This course is what you've been waiting for!

It's a quick deep dive into concepts like Array Formulas and formula-driven development. As you progress the course, you'll see how each module builds atop the last. You'll be exposed to often overlooked features, like Excel's form controls, which can drive tremendous interactivity.

And we'll even run through the rules of data visualization, to make sure what you build communicates its message.

By the end of this course, you won't just good at data visualization and dashboards, you'll be a master Excel builder!

There are tons of labs and mini dashboards throughout the course. Whatever you build for the course, you can use right away.

See you on the inside....

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

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel Dashboard & Data Visualization level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

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

>> Get LIFETIME Course access, downloadable Excel workbooks, Quizzes, Assignments, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Learn Microsoft Excel and Create Interactive Dashboards

Learn everything you need in Excel.Download 30 Useful Excel Dashboard Templates.Excel 2019,Excel 2020,Office 365.

Created by Mubeen Ali - MSc Data Science

"]

Students: 7300, Price: $19.99

Students: 7300, Price:  Paid

Note: Select "auto" to watch 1080p HD quality videos.

This course covers training for two Microsoft apps.Microsoft Excel and Microsoft Power BI.These two apps are very useful in the  office and business world.

                                                                                                      Microsoft Excel/Office 365

Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel.Learn how to create dashboards in Excel.To see more topics of this course,view course contents in the course landing page.

Note:-Extra downloadable Dashboard Templates are included with this course in the resource.

21.Covid 19 (1).xlsx

20.Covid 19.xlsx

19.Monthly Budget Dashboard Template.xlsx

18.University Monthly Budget Dashboard Template.xlsx

17.Monthly Personal Budget Dashboard Template.xlsx

16.Multiple Dependent drop down list Sales Dashboard.xlsx

15.Dependent drop down list Sales Dashboard.xlsx

14.Sales KPI Dashboard Template 2.xlsx

13.Download Searchable Drop Down List COVID - 19 Microsoft Excel Dashboard Live Update 26/05/2020.xlsx

12.Searchable drop down list Excel Dashboard Template with lookup picture.xlsx

11.Extra Project 2 - Sales Commission Calculator Template.xlsx

10.Extra Project 0 - Searchable Drop Down List Sales Dashboard Template.xlsx

9.KPI Sales Dashboard Template.xlsx

8.Business Finance Management Dashboard Template.xlsx

7.Extra Project 0 - COVID - 19 Data Analytics in Excel Dashboard Template 1 - Live Update.xlsx

6.Download Sales KPI Dashboard Template1.xlsx

5.Download Customer Analytics Dashboard Template.xlsx

4.Extra Project 5 - Real Estate Management Dashboard Template.xlsx

3.Download Sales Team Dashboard Template.xlsx

2.Extra Project 6 - Fully Automated Inventory Management Dashboard Template.xlsx

1.Extra Project 0 - COVID - 19 Data Analytics in Excel Dashboard Template 2 - Live Update.xlsx

                                       ______________________________________________________________________________________________________

                                                                                                      Microsoft Power BI/Office 365

Learn How to Analyze Data in Microsoft Business Intelligence Power BI.How to Reports and Dashboards are Created in Power BI.

In this course,you will learn,how to analyze business data in Microsoft business intelligence power bi.You will learn how to extract data from the website and an other sources and how that data is transformed in power query editor and power bi.You will learn how to that data is visualized in power bi.You will learn how to create reports and dashboards in power bi and how to add buttons in report page.You will learn how to custom visuals are added and data is visualized from that visuals.And much more!

Excel with Interactive Excel Dashboards

Learn how to create amazing interactive Excel Dashboards that will wow your boss & take your career to the next level. Lifetime access with no subscription on Udemy.

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

"]

Students: 6602, Price: $199.99

Students: 6602, Price:  Paid

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data.

The price of this course reflects its value and I'm confident you'll get results. Just read some of the unsolicited testimonials I've received:

  • "Financial Analyst - $52,500 (before taking your course)
  • Sr. Financial Analyst - ($60,000) After finalizing my dashboard
  • Sr. Business Analyst - ($70,000) Start that this Monday

Taking your course has honed my skills and led to two promotions and a reputation. I am also energized to learn more. James C"

"I originally signed up for this as continuing professional education for my CPA license but I have learned so much, easily more than any other technical class I've taken in years. Thank you for a wonderful class, you are a great teacher. Dielle B"

Dashboards can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

Master the Creation of Interactive Excel Dashboards and Learn to Build and Distribute Dashboard Reports From the Ground up.

  • Advanced Features
  • Design and Display Principles
  • Interactive Controls
  • Analyzing Data
  • 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.

In order to learn Excel Dashboard students should have access to Excel 2007 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 as well. Pivot Table and Pivot Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 107 lectures and over 11 hours of content + 5 sample Excel Dashboards in order to give students a working knowledge of utilizing Excel Dashboard visuals to communicate their data.

3 hours of the tutorials are optional supplementary Excel lessons and only for students who need to fill any knowledge gaps.I don't waffle on, my tutorials get to the point so you're up to speed fast.

Included are all the workbooks from the course which contain extensive notes, so you don't have to worry about taking notes while watching the tutorials. You can use the workbooks 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 information informative and relevant, analyzing and automating information for a fully functional and complete dashboard. It also includes key considerations for distributing dashboards like password protections, locking and unlocking cells and protecting workbooks.

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets. Students will be able to choose the right chart for their data, write easy to interpret reports, know which areas of the dashboard will get the most attention, animate charts using VBA, create interactive reports (so users can change views and filter information), among a host of other abilities taught in this course.

Learn Microsoft Excel Charts (Basic to Advanced)

Create awesome charts in Microsoft Excel

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 6372, Price: Free

Students: 6372, Price:  Free

Learn to create awesome charts in Microsoft Excel. In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts. With Excel, it is easy to create a chart.

Ultimate Master Course for Excel Dashboard Analytics

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

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

"]

Students: 5897, Price: $19.99

Students: 5897, Price:  Paid

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

This Microsoft Excel course combines 4 different courses.

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

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

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

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

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

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

Recent Student Review:

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

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

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

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

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

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

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

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

Disclaimer:

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

Excel Data Analysis with Excel Pivot Tables, Excel Dashboard

Excel Data Analysis and Excel Data Visualization with Excel Pivot Tables, Formulas, Pivot Charts and Excel Dashboard

Created by Skills On Demand - Better Skills Better Learning

"]

Students: 5236, Price: $109.99

Students: 5236, Price:  Paid

Microsoft Excel - Excel Data Analysis and Excel Data Visualization  with Excel Pivot Tables, Excel Pivot Charts and 2 Interactive Excel Dashboards.

Excel Charts and Excel Graphs are one of most
powerful features of Microsoft Excel which allows the users to represent
numerical data in Graphical Data Visualization format so that end user gets a better view
of the Information discussed.

In this course

You will learn the Excel Pivot Table and Excel Pivot Chart Function in detail and you will learn how to create Dynamic Excel Charts and Excel Graphs.

We will help you understand how to present your data Graphically on a Dynamic Chart, Graph or 3D Map, to make the information appear in a simplified manner.

  • You will learn the Top functions and Top formulas used to Pivot your data.

  • You will Learn to create a 2 Dynamic Sales Dashboard

  • You will learn how to design, style and format aspects of Excel 2016 are applied on charts, graphs and 3D maps.

  • You will use the dynamic graphical representation to display your complex data in an impressive way.

  • Learn to customize Layout, Axes, Grid lines, Spark lines, Trend lines and Error Bars.

This Course is structured in 8 Plus chapters and you will learn all the aspects of Pivot Function in depth .

We will go through, 20 Plus different Chart types used in Dynamic Excel Dashboards , Top formulas and Top Functions, Design and Style Elements and finally you will create a 2 Dynamic Excel Sales Dashboard.

So Lets the Show begin!

Mastering Excel Dashboard Creation and Data Visualizations

Learn to create stunning visually effective dashboards that aid quick business decisions, track KPIs and reveal insights

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 5063, Price: $99.99

Students: 5063, Price:  Paid

Do you want to improve your charting and visualization skills in Excel?  Do you want to master the common and lesser well-known charts available in your spreadsheets? Would you like to be able to create non-standard visually effective Excel charts and interactive dashboards that will all KPI's to be tracked, help aid business decisions, and reveal insights from your data?  If so then this course is the course for you.  Excel is not only an awesome tool for storing data and carrying out calculations, but it is also an amazing visualization tool from which you can design and create interactive dynamic dashboards and we are here to show you how it all works.

We will start this course by looking at the basics of charting in Excel.  You will explore ways to insert charts and formatting options.   After this, we will take a deep dive into creating the most commonly used charts such as line charts, pies charts, and columns charts.  And we will then finish the basics by looking at less common charts.

Once we have mastered the basics, you will then learn how to create dynamic non-standard visually effective charts and visualization.  You will learn advanced use functions and formulas to drive interaction and by the end of this course, you will be comfortable taking on a dashboard project from scratch.

This is a hands-on course, with workbooks to download and a lot to practice and master, giving you Excel dashboard skills that are in high demand in this growing world of data.

Excel Interactive Dashboards and Data Analysis

Learn to create POWERFUL, INTERACTIVE dashboards in Excel in minutes with no coding

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 4735, Price: $94.99

Students: 4735, Price:  Paid

If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you.  We've focused on providing you with the fundamentals you need to work with Excel effectively! 

Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert!

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say:

"I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. "

"Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!"

"Nice pace. Instructor knew the material and delivered it in a clear and understandable way"

"A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses"

**** Lifetime access to course materials and practice activities.  ****

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. 

Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)

We also discuss how to create and use BEST PRACTICE for your dashboards.

  • How to configure a dashboard

  • What graphs you should use to display what types of data

  • What questions you should ask of the data

  • What methods of analysis you can use in the data

In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis.

In the course you will learn the following key outcomes:

  • How to STRUCTURE your data for dashboards and data analysis

  • Create PIVOT TABLES to easily summarize and aggregate your data

  • Use Excel SLICERS to create filter tables and graphs

  • Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more

  • Understand how to EASILY create time / trend analysis using a few clicks of the mouse

  • Filter data and create Top 10 analysis

  • Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis

  • Create a Sales, Human Resource and Finance dashboard

  • Use Conditional Formatting to highlight key data and trends

This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis:

  • Comparison Analysis

  • Trend Analysis

  • Ranking Analysis

  • Contribution Analysis

  • Variance Analysis

  • Pareto Analysis