Take this
course

Office Productivity / Microsoft

Learn Microsoft Excel 2010 Advanced Course

Learn advanced Excel 2010 features and get ready to take your Excel knowledge to the next level.

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: Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster. An online quiz (35 questions) - to test what you've learned. 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. 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. 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!
Full details

Curriculum

  • Basic Steps for Charts & Graphs
    Introduction to Advanced Excel 2010
    2:42
    Four Basic Steps When Creating Charts/Graphs
    10:59
    Additional Features to Help Create Charts/Graphs
    14:41
    Additional Features to Help Create Charts/Graphs Part 2
    14:29
  • Layout Tab
    Detailed Formatting for Charts/Graphs
    13:03
    Formatting Legends within Charts/Graphs
    14:49
    Formatting Axes and Gridlines within Charts/Graphs
    15:48
  • Trends
    Trends within Charts and Graphs
    11:25
    Complex Trends within Charts and Graphs
    14:42
    Trends over Time within Charts and Graphs
    15:29
  • Differences
    Showing Differences Using Bar Charts
    14:38
    Showing Differences Using Pie Charts
    15:31
    Limitations with Pie Charts & How to Correct
    16:21
    Alternative Ways to Show Differences
    13:29
  • Relationships
    Using Charts & Graphs to Show Relationships
    15:24
    Using Charts & Graphs to Show Relationships Part 2
    15:35
  • Stock
    Charting & Graphing Financial Information
    15:16
    Charting & Graphing Financial Information Part 2
    11:07
    Specific Charts for Finance Information
    14:13
    Setting Up Live Charts
    14:39
  • Sparklines
    Using Sparklines for Data Visualization
    14:27
  • Data Bars
    Using and Formatting Data Bars, Color Scales & Icon Sets
    17:09
  • Pivot Tables
    Setting Up Pivot Tables/Charts
    14:33
    Setting Up Pivot Tables/Charts Part 2
    13:50
    Filtering Pivot Tables/Charts
    13:05
    New Features for Pivot Tables/Charts
    13:21
  • Graphics
    Graphics Tools
    15:07
    Graphics Tools Part 2
    13:33
  • Exporting
    Exporting Charts and Graphs
    15:10
    Exporting Charts and Graphs Part 2
    15:00

Skills

  • Microsoft Excel
  • Microsoft Excel for Mac

Similar Courses

More Courses by this Instructor