Learn Microsoft Excel 2010 Advanced Course

Learn advanced Excel 2010 features and get ready to take your Excel knowledge to the next level.
4.1 (119 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
44,560 students enrolled
$70
Take This Course
  • Lectures 36
  • Contents Video: 7 hours
    Other: 2.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2012 English

Course Description

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.

What am I going to get from this course?

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

What is the target audience?

  • Those seeking advanced Excel training

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Chapter 1 - Basic Steps for Charts & Graphs
Introduction to Advanced Excel 2010
Preview
03:10
IMPORTANT - Read this to ensure the best video quality!
Article
Four Basic Steps When Creating Charts/Graphs
Preview
10:58
Additional Features to Help Create Charts/Graphs
Preview
14:56
Additional Features to Help Create Charts/Graphs Part 2
14:28
Excel 2010 keyboard shortcuts
6 pages
Course transcripts
129 pages
MP3 audio files
Article
50% off course discount links for other Simon Sez IT courses
2 pages
Section 2: Chapter 2 - Layout Tab
Detailed Formatting for Charts/Graphs
Preview
13:03
Formatting Legends within Charts/Graphs
14:48
Formatting Axes and Gridlines within Charts/Graphs
15:47
Section 3: Chapter 3 - Trends
Trends within Charts and Graphs
11:24
Complex Trends within Charts and Graphs
14:41
Trends over Time within Charts and Graphs
15:28
Section 4: Chapter 4 - Differences
Showing Differences Using Bar Charts
Preview
15:11
Showing Differences Using Pie Charts
15:30
Limitations with Pie Charts & How to Correct
16:20
Alternative Ways to Show Differences
13:28
Section 5: Chapter 5 - Relationships
Course Review
00:43
Using Charts & Graphs to Show Relationships
15:23
Using Charts & Graphs to Show Relationships Part 2
15:34
Section 6: Chapter 6 - Stock
Charting & Graphing Financial Information
Preview
15:15
Charting & Graphing Financial Information Part 2
11:06
Specific Charts for Finance Information
14:36
Setting Up Live Charts
14:38
Section 7: Chapter 7 - Sparklines
Using Sparklines for Data Visualization
14:26
Section 8: Chapter 8 - Data Bars
Using and Formatting Data Bars, Color Scales & Icon Sets
17:08
Section 9: Chapter 9 - Pivot Tables
Setting Up Pivot Tables/Charts
Preview
14:32
Setting Up Pivot Tables/Charts Part 2
14:30
Filtering Pivot Tables/Charts
13:04
New Features for PIvot Tables/Charts
13:20
Section 10: Chapter 10 - Graphics
Graphics Tools
15:07
Graphics Tools Part 2
13:32
Section 11: Chapter 11 - Exporting
Exporting Charts and Graphs
15:09
Exporting Charts and Graphs Part 2
14:59
Section 12: Course Quiz
Assessment Test
33 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Software training to help you succeed

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course