Learn Microsoft Excel 2010 Advanced Course
4.7 (177 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
44,615 students enrolled

Learn Microsoft Excel 2010 Advanced Course

Learn advanced Excel 2010 features and get ready to take your Excel knowledge to the next level.
4.7 (177 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
44,615 students enrolled
Created by Simon Sez IT
Last updated 6/2018
English [Auto-generated]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 2 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Four basic steps to consider when creating charts and graphs.
  • How to better format your charts and graphs like professionals do.
  • Discover how to deal with complex trends in your charts and graphs.
  • Learn how to use a bar chart and a pie chart to accentuate the differences in a data set.
  • Discover the tools and options for exporting your charts and graphs.
  • Discover the limitations of pie charts and the best way to correct them.
  • Learn how to use Pivot Tables and Pivot Charts.
  • Learn how to integrate graphics into your spreadsheets.

Ideal for those seeking to enhance their Excel 2010 knowledge, the Learn Excel 2010 – Advanced by Simon Sez IT is a 7-hour training course covering advanced level Excel topics.

Microsoft has added very powerful tools to Excel over previous versions. Understanding these tools will save you time and energy combing through information. Learn how to create eye-catching charts and graphs (formatting axes and gridlines, showing basic trends, complex trends, even trends over time). Learn the differences between the various types of charts, relationships in data, and ways to show differences.

Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. Excel’s tools are covered in depth which includes discussions on and are setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. You can move columns and rows to understand how the numbers relate more easily than ever before.

Finally, once you have analyzed the data you will need to share it; ascertain the method for exporting charts and graphs for the best presentation.

Plus, when you sign up for our class, you’ll also get these 5 BONUSES in addition to the 30 online course videos:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (35 questions) - to test what you've learned.
  3. Downloadable & printable transcripts (over 120 searchable pages) – to give you another learning option, if you prefer reading but don’t have time to take notes.
  4. 7 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym.
  5. A certificate of completion to tell everyone you've aced the course.

Where else can you find so many extra tools to help you master Excel 2010?!?!

So start learning today. Because being a technology dinosaur isn’t going to get you a promotion or raise!

All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged.

Who this course is for:
  • Those seeking advanced Excel training
Course content
Expand all 36 lectures 09:20:40
+ Chapter 1 - Basic Steps for Charts & Graphs
9 lectures 44:57
Essential Information for a Successful Training Experience
Additional Features to Help Create Charts/Graphs Part 2
Excel 2010 keyboard shortcuts
6 pages
Course transcripts
129 pages
MP3 audio files
50% off course discount links for other Simon Sez IT courses
2 pages
+ Chapter 2 - Layout Tab
3 lectures 43:38
Formatting Legends within Charts/Graphs
Formatting Axes and Gridlines within Charts/Graphs
+ Chapter 3 - Trends
3 lectures 41:33
Trends within Charts and Graphs
Complex Trends within Charts and Graphs
Trends over Time within Charts and Graphs
+ Chapter 4 - Differences
4 lectures 01:00:29
Showing Differences Using Pie Charts
Limitations with Pie Charts & How to Correct
Alternative Ways to Show Differences
+ Chapter 5 - Relationships
3 lectures 31:40
Course Review
Using Charts & Graphs to Show Relationships
Using Charts & Graphs to Show Relationships Part 2
+ Chapter 6 - Stock
4 lectures 55:35
Charting & Graphing Financial Information Part 2
Specific Charts for Finance Information
Setting Up Live Charts
+ Chapter 7 - Sparklines
1 lecture 14:26
Using Sparklines for Data Visualization
+ Chapter 8 - Data Bars
1 lecture 17:08
Using and Formatting Data Bars, Color Scales & Icon Sets
+ Chapter 9 - Pivot Tables
4 lectures 55:26
Setting Up Pivot Tables/Charts Part 2
Filtering Pivot Tables/Charts
New Features for PIvot Tables/Charts
+ Chapter 10 - Graphics
2 lectures 28:39
Graphics Tools
Graphics Tools Part 2