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

Microsoft Excel 2010 Training - Beginner to Advanced Lessons

Course Summary

This course will teach you Excel 2010 from the absolute basics through to the most advanced topics. Start today!

  • +

    Course Syllabus

    • Introducing Excel 2010
      • Welcome to Excel 2010
      • Starting Excel 2010
      • Understanding the new Excel 2010 Screen Layout
      • Introducing the new File Tab and Backstage View
    • Excel 2010 Basics
      • Excel 2010 work file to be downloaded and used throughout this course.
      • Introducing the new Office 2010 file format
      • Creating and saving a new workbook
      • Opening an existing workbook
      • Creating a new workbook from a template
      • Saving a workbook as a template
      • Opening a workbook using different options
      • Using SAVE AS to create a new workbook
      • Saving a Excel 2010 workbook in Excel 2003 format
      • Saving a workbook as a PDF file
      • Saving a workbook in web page format (HTML)
      • Printing workbooks
      • Understanding text versus numeric cell entries
      • Introducing the Quick Access Toolbar
      • How to minimize the Office Ribbon
      • Navigating the Office Ribbon using the keyboard
      • Navigating around worksheets using the keyboard
      • Managing worksheets
      • Introducing the Mini Toolbar
      • Getting to know the Formula Bar
      • How to select cells in different ways
      • Resizing rows and columns
      • Using AutoCorrect
      • Using AutoComplete
      • Using AutoFill
      • Inserting and deleting cells, rows and columns
      • A closer look at Cut, Copy and Paste
      • Understanding Excel Operators
      • A refresher course in the Order of Operations
      • Multi-User editing using the new Office Web Apps
    • Controlling Worksheets and Information
      • Getting the most from the Office Clipboard
      • Working with the Format Painter
      • Understanding the Font Group commands
      • Understanding the Alignment Group commands
      • Merging cells and wrapping text entries
      • Understanding the Number Group commands
      • Introducing Conditional Formatting
      • Working with Table Styles
      • Table Style formatting options
      • Working with Cell Styles
      • Introducing Sparklines
      • Adjusting rows and columns using the Office Ribbon
      • How to hide and un-hide rows, columns and worksheets
      • Managing worksheets using the Office Ribbon
      • Clearing cell content and formatting
      • Sorting and filtering information
      • Using the Find and Replace tools
      • Using the Select Objects tool
      • Working with the Selection Pane
    • Inserting Objects Into Worksheets
      • Inserting a picture into a worksheet
      • Understanding the new picture editing tools
      • Inserting and working with ClipArt
      • Inserting and working with Shapes
      • Introducing SmartArt graphics
      • Introducing the new Screenshot tool
      • Using different types of Hyperlinks
      • Working with Text Boxes
      • Inserting Headers and Footers into worksheets
      • Working with WordArt
      • Inserting Equations and Symbols
    • Organizing Worksheets and Workbooks
      • Utilising Office Themes
      • Adjusting Page Margins and Orientation
      • Changing the Page Size and Print Area
      • Working with Page Breaks
      • Adding a worksheet background image
      • Adding column and row headings to reports
      • Using Gridline and Heading options
      • Working with different Excel Views
      • Working with the Show and Zoom commands
      • Managing multiple workbook windows
      • Freezing rows and columns
      • Comparing workbooks side by side
      • Using the Spelling Checker and other proofing tools
      • Inserting and managing worksheet Comments
    • Excel Security
      • Protecting worksheets
      • Protecting workbooks
      • Sharing workbooks to allow multi-user editing
      • Using Mark As Final
      • Password protecting your workbooks
      • Other ways to protect worksheets and workbooks
      • Information Rights Management and Digital Signatures
      • Using the Document Inspector
      • Using the Accessibility Checker
      • Working with the Protected View feature
    • Working with Charts
      • How to insert a Chart
      • Chart Basics
      • Modifying the chart design
      • Modifying the chart layout
      • Chart formatting options
      • Chart formatting tips and techniques
      • Changing the default chart type
      • The fastest way to insert a chart
      • Creating and using chart templates
      • Advanced data selection techniques
    • Macros
      • Recording a basic macro
      • Saving a macro enabled workbook
      • Macro security settings
      • Absolute versus Relative cell referencing
      • Assigning a macro to a button
      • Adding a macro to the Quick Access Toolbar
      • Editing a macro
      • Troubleshooting a macro
      • Enabling the Developer Tab
    • Mastering Pivot Tables
      • Introducing Pivot Tables
      • A quick look around a Pivot Table
      • Adding data to Pivot Tables
      • Removing and customizing report data
      • Formatting Pivot Table information
      • Sorting and filtering data
      • Working with Report Filters
      • Customizing the Pivot Table screen layout
      • Basic Pivot Table options
      • Working with Report Filter page options
      • Pivot Table configuration options
      • Drilling down into Pivot Table data
      • Data calculation options
      • Grouping Pivot Table data
      • Grouping options relating to Date information
      • Refreshing and modifying source data
      • How to move a Pivot Table
      • Inserting a Pivot Chart
      • How to create a Calculated Field
      • Working with Pivot Table Styles
      • Introducing the new Slicer tool
      • How to insert a Pivot Chart using the Office Ribbon
    • Formulas and Functions
      • Introducing Formulas and Functions
      • Formula and function basics
      • How to use the SUM function
      • Understanding Absolute and Relative cell referencing
      • How to use the CONCATENATE function
      • How to use the SUMIF function
      • How to use the VLOOKUP function
      • How to use the TRIM function
      • How to use the RANDBETWEEN function
      • How to use the COUNTIF function
      • How to use the PMT function
      • Formula auditing tools
      • Error checking tools for formulas
      • Evaluating Formulas
      • Using the Watch Window
    • Other Advanced Topics
      • Introducing the Excel Name Manager
      • Navigating the Name Manager
      • Using and managing named cells and ranges
      • Excel calculation options
      • Importing an Access database
      • Importing data from a CSV file
      • Splitting text into multiple columns
      • Removing duplicated information
      • Data validation options
      • Using the Consolidation tool
      • Using the Goal Seek tool
      • Grouping and ungrouping data
      • Auto-generating totals and subtotals
    • Excel 2010 Finale
      • Thank you

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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