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

Mastering Microsoft Excel 2010 Made Easy Training Tutorial

Course Summary

Learn Introductory through Advanced material with this complete Excel course. Video lessons & manuals included.


  • +

    Course Syllabus

    • Getting Acquainted with Excel
      • About Excel
      • The Excel Environment
      • The Title Bar
      • The Ribbon
      • The "File" Tab and Backstage View
      • Scroll Bars
      • The Quick Access Toolbar
      • The Formula Bar
      • The Workbook Window
      • The Status Bar
      • The Workbook View Buttons
      • The Zoom Slider
      • The Mini Toolbar
      • Keyboard Shortcuts
    • Creating Basic Workbooks
      • Creating New Workbooks
      • Saving Workbooks
      • Closing Workbooks
      • Opening Workbooks
      • Selecting Cells
      • Entering Text Into Cells
      • Entering Numbers Into Cells
      • AutoComplete
      • Pick From Drop-Down List
      • Using the "Window" Command Group
      • Switching to Full Screen View
      • Working with Excel File Formats
    • Using Ranges
      • Selecting Ranges
      • Ranged Data Entry
      • Using AutoFill
    • Creating Formulas
      • Ranged Formula Syntax
      • Simple Formual Syntax
      • Writing Formulas
      • Using AutoSum
      • Inserting Functions
      • Editing a Range
      • Formula and AutoCorrect
      • AutoCalculate
    • Copying and Pasting Formulas
      • Absolute References and Relative References
      • Cutting, Copying and Pasting
      • AutoFilling Cells
      • The Undo Button
      • The Redo Button
    • Columns and Rows
      • Selecting Columns and Rows
      • Adjusting Column Width and Row Height
      • Hiding/Unhiding Columns and Rows
      • Inserting and Deleting Columns and Rows
    • Formatting Worksheets
      • Formatting Cells
      • The Format Cells Dialog Box
      • Clearing All Formatting from Cells
      • Copying All Formatting from Cells to Another Area
    • Worksheet Tools
      • Moving Between Worksheets
      • Selecting Multiple Worksheets
      • Inserting and Deleting Worksheets
      • Renaming Worksheets
      • Coloring Worksheet Tabs
      • Copying or Moving Worksheets
    • Setting Worksheet Layout
      • Using Page Break Preview
      • Using the Page Layout View
      • The Page Setup Dialog Box
    • Printing Worksheets
      • Previewing and Printing Worksheets - 2010
    • Helping Yourself
      • Using Excel Help
    • 3D Formulas
      • Creating 3D Formulas
      • 3D Formula Syntax
      • Creating 3D Range Preferences
    • Named Ranges
      • Naming Ranges
      • Creating Names from Headings
      • Moving to a Named Range
      • Using Named Ranges in Formulas
      • Naming 3D Ranges
      • Managing Named Ranges
    • Conditional Formatting and Cell Styles
      • Conditional Formatting
      • Finding Cells with Conditional Formatting
      • Clearing Conditional Formatting
      • Using Table and Cell Styles
    • Paste Special
      • Using Paste Special
      • Pasting Linked Formulas
    • Sharing Workbooks
      • Sharing Workbooks
      • Highlighting Changes
      • Reviewing Changes
      • Using Comments
      • Compare and Merge Workbooks
    • Auditing Worksheets
      • Auditing Worksheets
      • Tracing Precedent and Dependent Cells
      • Tracing Errors
      • Error Checking
      • Using the Watch Window
      • Cell Validation
    • Outlining Worksheets
      • Using Outlines
      • Applying and Removing Outlines
    • Consolidating Worksheets
      • Consolidating Data
    • Creating Worksheet Charts
      • Creating Charts
      • Selecting Charts and Chart Elements
      • Moving and Resizing Charts
      • Changing the Chart Type
      • Changing the Data Range
      • Switching Column and Row Data
      • Choosing a Chart Layout
      • Choosing a Chart Style
      • Printing Charts
      • Deleting Charts
    • Editing and Formatting Charts
      • Formatting Chart Objects
      • Inserting Objects into a Chart
      • Changing Chart Labels
      • Changing Axes Display
      • Changing the Chart Background
      • Applying Chart Analysis Lines
      • Naming Charts
      • Applying Shape Styles to Chart Elements
      • Applying WordArt Styles to Chart Elements
      • Saving Custom Chart Templates
    • PivotTables
      • Creating PivotTables and PivotCharts
      • Manipulating a PivotTable
      • Changing Calculated Value Fields
      • Applying PivotTable Styles
      • Creating a PivotChart
      • Setting PivotTable Options
      • Sorting and Filtering PivotTable Data
    • Tables
      • Creating a Table
      • Adding and Editing Records
      • Inserting Records and Fields
      • Deleting Records and Fields
    • Sorting Data
      • Sorting Data
      • Custom Sort Orders
    • Filtering Data
      • Using AutoFilters
      • Using the Top 10 AutoFilter
      • Applying a Custom AutoFilter
      • Creating Advanced Filters
      • Applying Multiple Criteria
      • Using Complex Criteria
      • Copying Filtered Results to a New Location
      • Using Database Functions
    • Using What-If Analysis
      • Using Data Tables
      • Using Scenario Manager
      • Using Goal Seek
    • Table-Related Functions
      • The Hlookup and Vlookup Functions
      • Using the IF, AND, and OR Functions
    • Security Features
      • Unlocking Cells
      • Worksheet Protection
      • Workbook Protection
      • Password Protecting Excel Files
    • Making Macros
      • Recording Macros
      • Running and Deleting Recorded Macros
      • The Personal Macro Workbook
    • Instruction Manuals
      • Introductory Excel Manual
      • Intermediate Excel Manual
      • Advanced Excel Manual


Course Fee:
USD 97

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