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

Excel 2010

Course Summary

Online Excel training is designed to create a strong foundation for using the world's most popular business software.


  • +

    Course Syllabus

    • Essentials and Intro to Formulas and Functions
      • Getting Started
      • Practice Starting Excel
      • Navigating
      • McDonalds Cash Register
      • Autofit Column Width
      • Replace Data
      • Accounting Formatting Looks Like Money
      • Zooming
      • Formulas Should Use Cell Addresses
      • More About Formulas
      • Copy and Paste Formula
      • Additional Arithmetic
      • Saving Files
      • Open Practice Fields
      • Sheet Tabs
      • Right Click Sheet Tabs for TOC
      • Sum Function
      • Ctrl + Enter Stays in the Cell to be Copied
      • Sum Down and Autofill Sideways
      • Max and Min
      • Autofill
      • Formula Auditing Tools
      • Absolute References
      • Evaluate Formula Button
      • Interactive 2003 Command Reference Guide
      • Course Check List
    • Formatting, Spreadsheet Design, Page Setup and Printing
      • Open Excel Day 1 Workfiles
      • Insert a Sheet
      • Copy and Paste Between Sheets
      • Paste Widths
      • Pasting Continued
      • Insert a Column
      • Cut/Paste
      • Drag/Drop
      • Autofill A Months
      • Autofill with Days and Numbers
      • Formatting Cell Styles
      • Font Size
      • Number Formatting
      • Templates
      • Sheets: Color and Grouping
      • Sheets: Ungrouping and Deleting
      • Edit Multiple Sheets
      • Copy Entire Sheets
      • Spell Check
      • Freeze Panes
      • Unfreeze Panes and Split Screen
      • Custom Views
      • Page Setup for Printing
      • Page Layout View
      • Course Check List
    • List/Table Essentials and Charting
      • Introduction
      • A Well-Defined List
      • Sort by One Field
      • Sort Multiple Fields
      • Custom Sort Lists
      • Create a Custom Sort List
      • Sorting Numbers, Dates, and Text
      • Filtering
      • Multi-field Filtering
      • Filter for a Range of Values
      • Remove One Filter at a Time
      • Remove Multiple Filters
      • Remove Autofilter Arrows
      • Create the Duplicate Record Problem
      • Automatic Subtotals
      • Sort Before Subtotaling
      • Subtotal by Division
      • Subtotal by Second Field
      • Format Cells as a Table
      • Convert to Range
      • Charts
      • Column Chart
      • Modifying Charts
      • Themes Affect Chart Colors
      • Change Chart Column Colors
      • Include a Chart Title
      • Add a Gradient Fill to the Plot Area
      • Switch Row and Column Order
      • Add Data to your Chart
      • Change Chart Column Order
      • Line Charts
      • X Axis for Line Charts
      • Pie Charts
      • Data Labels
      • Create a Chart Template
      • Printing Charts
      • Sparklines
      • Column-Style Sparklines
      • Win/Loss Sparklines
      • Course Check List
    • Importing Data, Pivot Tables, Protecting and Linking Data
      • Introduction and Practice Files
      • Start Excel 2010
      • Look at the Text Data
      • Link to the Text File
      • Saving Workbook
      • Editing Text Data in Excel
      • Edit Data in Notepad
      • Refresh the Excel Communication
      • Link to Access
      • Editing from Excel
      • Open Day Two Workfiles
      • Export to PDF
      • Renaming Worksheets
      • Pivot Tables
      • Classic Pivot Table Skeleton
      • Creating Pivot Table
      • Multiple Fields in Pivot Table
      • Formatting Totals
      • Report Filter and Slicer
      • Pivot Chart
      • Filter the Table and Chart
      • Insert a New Sheet
      • Link by Copy/Paste
      • Insert Comment
      • Show all Comments
      • Print with Comments
      • Conditional Formatting
      • Color Scales
      • Data Bars
      • Data Validation
      • Data Validation Value Boundaries
      • Conditional Formatting for DV Rule Breaker
      • Protect the Worksheet
      • Protect the Workbook
      • Protect the File
      • Course Check List
    • Creating Forms
      • Download Practice Files
      • Creating Range Names
      • Names in Formulas
      • Create Names from Selection
      • Logical Functions
      • If Functions
      • Nesting If Functions
      • V Lookup
      • Copy and Adjust V Lookup
      • V Lookup with TRUE
      • Using TRUE
      • Nest If Inside V Lookup
      • Nest If Inside V Lookup (cont.)
      • Sumif
      • Averageifs
      • Sumifs
      • Data Validation List
      • Date Functions
      • Today Function
      • Overview
      • Course Check List
    • Creating Reports
      • Getting Started
      • Consolidate
      • Opening a Template
      • Goal Seek
      • Goal Seek (cont)
      • Install Solver Addin
      • Practice Constraints 2 and 3
      • Constraint 3
      • Constraint 4
      • The Results
      • Absolute References via F4
      • Two-Variable Data Table
      • Scenario Manager
      • Summary Sheet
      • Install Developer Tool
      • Record Absolute References Macro
      • Visual Basic Editor
      • Relative Macro References
      • Problems Running H3 Relative Macro from F3
      • Relative Recorded from H3
      • Additional Macros
      • Assign KBD Shortcut Later
      • Macro with Ribbon
      • Excel Speaks
      • Course Check List


Course Fee:
USD 59

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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