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
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 Data Visualization for Business Analysts
Become an expert in data visualization using Excel as your canvas. Go past basic Excel charts to up your data vis game.
Created by Excel TV - Excel MVPs, Authors and Bloggers
Students: 19847, Price: Free
Master Data Visualization Using Microsoft Excel
Whether you've just started working in Excel or you've been using it forever, chances are you've heard about data visualization and understand how important is. More than that, you've probably made a few charts you were proud of.
I was there, too. I could make any basic Excel chart my boss asked for. But I knew my charts - and many of those that I saw presented - did a poor job communicating data. Looking back, I think I was being asked to make charts just so we would have more to present.
Sound familiar? I've been where you are.
So I wanted to create a data visualization course for the business analysts who work with a lot of data and use Microsoft Excel regularly within their workflows. Chances are - you can already create a bar chart, a pie chart, and more. If that's you, read on.
Because I think a course for people like us has been missing. So I decided to distill everything I knew into a course that shows:
The important research behind which charts show the best information.
That way you're always communicating the best results. And when your boss challenges you, you can point to the research. (Just point him or her to the module on why Pie Charts are the worst!)
How to create advanced charts not included in Excel.
Most business problems can't be captured in Excel's native chart library. Do you know how to create Bullet Charts? Charts with multiple banding? This course will show you how.
How to create charts for analysis and how to create charts to tell a story.
In this course, we'll talk about the difference between data graphics and info graphics. The former is for investigation, the latter for narration. You won't find this content elsewhere - I know, because I came up with it organically while working as a management consultant.
How to layout your charts and info graphics when you deliver them to executives.
I'll introduce you to the camera tool, one of Excel's most powerful features. You'll see how it will allow you to drag-and-drop a chart, much like in Power BI.
Labs and Quizzes
It's not enough to learn this information. You need to apply. I have created labs and quizzes based on the content. Take the quizzes to reinforce your knowledge. Complete the labs and then use them immediately in your own work.
No VBA or Macros
I love VBA and Macros too but they're way over deployed. In many cases, the advanced chart you're thinking of making doesn't need lines and lines of code. I'll show you how quickly.
Here's what you can look forward to in this course:
Data visualization principles including closure, proximity, common group and preattentive attributes
Theory and practice for why data visualization is so important
Why 3d charts cause issues when communicating data
Problems pie charts present to the audience
How to create charts with graded banding in Excel
How to create Bullet Charts in Excel
How to create Progress Meter Charts in Excel
How to create Waffle Charts in Excel
Microsoft Excel's camera tool
Resources to help you continue your learning
Like you, I work in the trenches, hustling to solve every new data challenge that comes my way. I wanted to create a course for people like me to learn from. If you want to stand out in the crowd and take your Excel and data skills to a whole new level, then you're the person I created this course for.
See you there,
Excel Charts and Graphs : Master Data Visualization
Master the art of Data Visualization by creating informative charts in Excel which deliver clear & concise message
Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries
Students: 13226, Price: Free
What are the chart types I will learn in this course?
Excel offers the following major chart types. All of these are covered in this course
XY (Scatter) Chart
And many other creative ones :)
How are charts useful in Excel?
A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.
What are the benefits of using charts in Excel?
Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.
This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:
How do you make Excel charts look better?
How do you format a chart in Excel?
What are the different elements of charts?
How do I make those awesome infographics that I see in fancy magazines and TV reports?
How do I create a comparison chart in Excel?
What is the best chart to use for comparison?
And many more...
How is this course different from other resources available online?
Most courses only cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.
The course is created on the basis of three pillars of learning:
Review (Self feedback)
We have created a set of concise and comprehensive videos to teach you all the Excel related skills you will need in your professional career.
With each lecture, we have provide a practice sheet to complement the learning in the lecture video. These sheets are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.
Check if you have learnt the concepts by comparing your solutions provided by us. Ask questions in the discussion board if you face any difficulty.
Lookup Functions, Advanced Charts and Pivot tables
Excel charts and pivotes made it easy
Created by MKCL India - Creating a Knowledge Lit World
Students: 11553, Price: Free
Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. After you enroll and complete this course, you will be proficient in all kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts. You will be able not only to create these charts in Excel, but also to format them quickly and easily.
This course also provides an in-depth coverage of pivot tables and pivot charts. These are two of the powerful data analysis tools in Excel's arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user. Pivot Tables and Pivot Charts allow you to dynamically reorganize and display your data in many different ways and they help you get meaningful information from large amounts of data.
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
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.