MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

The Ultimate Microsoft Excel 2010 Training Course

Course Summary

Have all the numbers, charts and graphs got you down? Demystify Excel forever with this effective course.


  • +

    Course Syllabus

    • Intro to Excel 2010
      • Introduction and Overview of Excel Course
      • Overview of the Excel Window
      • Working with the Mouse
      • Excel Options
    • Getting Started Creating a New Workbook
      • Entering Text and Numbers
      • Creating Basic Formulas
      • Relative References
      • Order of Operations
      • Working withe Ranges
    • Saving Workbooks
      • Working with Save and Save As Commands
      • File Extensions
    • Navigating Workbooks
      • Opening a File
      • Working with Larger Files
      • Freeze Panes Options
      • Split Screen Option
    • Printing
      • Page Setup Options
      • Headers and Footers
      • Print Titles
      • Comments
      • Fit to print on one page
      • Printing Workbooks
    • Working with Rows, Columns, and Cells
      • Adding and Deleting Rows, Columns, and Cells
      • Changing Column and Row Widths
    • Moving Data
      • Cut, Copy and Paste
      • Copying Formulas
    • Formulas and Functions
      • Overview of Formulas
      • Create Formulas using Functions - Part 1
      • Create Formulas using Functions - Part 2
      • Absolute Values
    • Working with Worksheets
      • Adding, Deleting and Renaming Sheets
      • Additional Sheet Tab Options
      • 3-D Formulas
    • Formatting Worksheets
      • Cell Formatting
      • Number Formatting
      • Borders and Shading
      • Format as Table
      • Using Styles
      • Using Format Painter
      • Protecting Sheets
      • Fill Handle and Custom Lists
    • Charts
      • Creating Charts
      • Types of Charts
      • Editing Charts
      • Using Graphics to Enhance Charts
      • Course Review
    • Working with Names
      • Creating Range Names
      • Managing Names
      • Using Names in Formulas
    • Sorting and Filtering
      • Removing Duplicates
      • Sort Data
      • Filter Data
      • Advanced Filters
    • Outlining and Subtotaling
      • Creating an Outline - Part 1
      • Creating an Outline - Part 2
      • Subtotals
    • Working with Views
      • New Window Option
      • Arrange File Options
      • Creating a Workspace
      • Custom Views
      • Scenarios
    • Linking Files
      • Creating Formulas between Files
      • Working with Links
    • Advanced Formula Creation
      • IF Statement
      • VLookups
      • Consolidating Data
      • Data Validation
      • Formula Auditing
    • Additional Excel Features
      • Comments
      • Goal Seeker
      • Text to Columns Option
      • Watch Window
    • Conclusion
      • Closing Video
      • Assessment Test
    • Intro to Access 2010 Advanced - Basic Steps for Charts & Graphs
      • Introduction to Advanced Excel 2010
      • Four Basic Steps When Creating Charts/Graphs
      • Additional Features to Help Create Charts/Graphs
      • Additional Features to Help Create Charts/Graphs Part 2
    • Layout Tab
      • Detailed Formatting for Charts/Graphs
      • Formatting Legends within Charts/Graphs
      • Formatting Axes and Gridlines within Charts/Graphs
    • Trends
      • Trends within Charts and Graphs
      • Complex Trends within Charts and Graphs
      • Trends over Time within Charts and Graphs
    • Differences
      • Showing Differences Using Bar Charts
      • Showing Differences Using Pie Charts
      • Limitations with Pie Charts & How to Correct
      • Alternative Ways to Show Differences
    • Relationships
      • Using Charts & Graphs to Show Relationships Part
      • Using Charts & Graphs to Show Relationships Part 2
    • Stock
      • Charting & Graphing Financial Information
      • Charting & Graphing Financial Information Part 2
      • Specific Charts for Finance Information
      • Setting Up Live Charts
    • Sparklines
      • Using Sparklines for Data Visualization
    • Data Bars
      • Using and Formatting Data Bars, Color Scales & Icon Sets
    • Pivot Tables
      • Setting Up Pivot Tables/Charts
      • Setting Up Pivot Tables/Charts Part 2
      • Filtering Pivot Tables/Charts
      • New Features for Pivot Tables/Charts
    • Graphics
      • Graphics Tools
      • Graphics Tools Part 2
    • Exporting
      • Exporting Charts and Graphs
      • Exporting Charts and Graphs Part 2
    • Excel 2010 Advanced Quiz
      • Assessment Test


Course Fee:
USD 177

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top