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 2013 Training Tutorial

Course Summary

Learn to use Microsoft Excel 2013 with this comprehensive course.


  • +

    Course Syllabus

    • Getting Acquainted with Excel
      • About Excel
      • The Excel Environment- 2013
      • The Excel Environment- 2010
      • The Excel Environment- 2007
      • The Title Bar
      • The Ribbon
      • The “File” Tab and Backstage View- 2013:2010
      • The Microsoft Office Button- 2007 Only
      • Scroll Bars
      • The Quick Access Toolbar
      • Touch Mode- 2013
      • The Formula Bar
      • The Workbook Window
      • The Status Bar
      • The Workbook View Buttons
      • The Zoom Slider
      • The Mini Toolbar
      • Keyboard Shortcuts
    • File Management
      • Creating New Workbooks- 2013 Only
      • Creating New Workbooks- 2010 Only
      • Creating New Workbooks- 2007 Only
      • Saving Workbooks- 2013 Only
      • Saving Workbooks- 2010 Only
      • Saving Workbooks- 2007 Only
      • Closing Workbooks- 2013 Only
      • Closing Workbooks- 2010:2007 Only
      • Opening Workbooks- 2013 Only
      • Opening Workbooks- 2010 Only
      • Opening Workbooks- 2007 Only
      • Recovering Unsaved Workbooks- 2013 Only
      • Using the “Window” Command Group
      • Switching to Full Screen View
      • Working with Excel File Formats
    • Data Entry
      • Selecting Cells
      • Entering Text into Cells
      • Entering Numbers into Cells
      • AutoComplete
      • Pick from Drop-Down List
      • Flash Fill- 2013 Only
      • Selecting Ranges
      • Ranged Data Entry
      • Using AutoFill
    • Creating Formulas
      • Ranged Formula Syntax
      • Simple Formula Syntax
      • Writing Formulas
      • Using AutoSum
      • Inserting Functions
      • Editing a Range
      • Formula AutoCorrect
      • AutoCalculate
      • Function Compatibility- 2013 Only
    • Copying and Pasting Formulas
      • Relative References and Absolute References
      • Cutting, Copying, and Pasting Data
      • AutoFilling Cells
      • The Undo Button
      • The Redo Button
    • Columns and Rows
      • Selecting Columns and Rows
      • Adjusting Column Width and Row Height
      • Hiding and 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
      • Inserting and Deleting Worksheets
      • Selecting Multiple Worksheets
      • Navigating Worksheets- 2013 Only
      • Navigating Worksheets- 2010:2007
      • 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- 2013:2010
      • Using Print Preview- 2007 Only
      • Printing Worksheets- 2007 Only
    • Helping Yourself
      • Using Excel Help
    • 3D Formulas
      • Creating 3D Formulas
      • 3D Formula Syntax
      • Creating 3D Range References
    • Named Ranges
      • Naming Ranges
      • Creating Names from Headings
      • Moving to a Named Range
      • Using Named Ranges in Formulas
      • Naming 3D Ranges
      • Deleting 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
    • Tables
      • Creating a Table
      • Adding an 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
      • Using a Custom AutoFilter
      • Creating Advanced Filters
      • Applying Multiple Criteria
      • Using Complex Criteria
      • Copying Filter 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
    • Sparklines
      • Inserting and Deleting Sparklines
      • Modifying Sparklines
    • Creating Charts In Excel 2013
      • Creating Charts
      • Selecting Charts and Chart Elements
      • Adding 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
      • Changing Color Schemes
      • Printing Charts
      • Deleting Charts
    • Creating Charts in Excel 2010 & 2007
      • 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
    • Formatting Charts in Excel 2013
      • Formatting Chart Objects
      • Inserting Objects into a Chart
      • Formatting Axes
      • Formatting Axis Titles
      • Formatting a Chart Title
      • Formatting Data Labels
      • Formatting a Data Table
      • Formatting Error Bars
      • Formatting Gridlines
      • Formatting a Legend
      • Formatting Drop and High-Low Lines
      • Formatting Trendlines
      • Formatting Up/Down Bars
      • Formatting the Chart and Plot Areas
      • Naming Charts
      • Applying Shape Styles
      • Applying WordArt Styles
      • Saving Custom Chart Templates
    • Formatting Charts in Excel 2010 and 2007
      • 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
    • Data Models- 2013
      • Creating a Data Model from External Relational Data
      • Creating a Data Model from Excel Tables
      • Relating Tables in a Data Model
      • Managing a Data Model
    • PivotTables and PivotCharts- 2013
      • Creating Recommended PivotTables
      • Manually Creating a PivotTable
      • Creating a PivotChart
      • Manipulating a PivotTable or PivotChart
      • Changing Calculated Value Fields
      • Formatting PivotTables
      • Formatting PivotCharts
      • Setting PivotTable Options
      • Sorting and Filtering Using Field Headers
    • PivotTables and PivotCharts- 2010:2007
      • 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
    • PowerPivot
      • Starting PowerPivot
      • Managing the Data Model
      • Calculated Columns and Fields
      • Creating KPIs
      • Creating and Managing Perspectives
      • PowerPivot PivotTables and PivotCharts
    • Power View
      • Starting Power View
      • Adding Report Visualizations
      • Changing the Layout of Report Visualizations
      • Using Undo and Redo in Power View
      • Formatting the Power View Sheet
      • Creating Multiples in a Chart
    • Slicers and Timelines
      • Inserting and Deleting Slicers
      • Modifying Slicers
      • Inserting and Deleting Timelines
      • Modifying Timelines
    • Security Features
      • Unlocking Cells
      • Worksheet Protection
      • Workbook Protection
      • Password Protecting Excel Files- 2013
      • Password Protecting Excel Files- 2010:2007
    • Making Macros
      • Recording Macros
      • Running and Deleting Recorded Macros
      • The Personal Macro Workbook
    • Conclusion
      • Course Conclusion
    • Instruction Manuals
      • Introductory Excel Manual
      • Intermediate Excel Manual
      • Advanced Excel Manual


Course Fee:
USD 9

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