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 2013 Fundamentals

Course Summary

This course covers everything you need to know to get started in Excel 2013. Starting with an overview of how to navigate in Excel using both the mouse and keyboard shortcuts, Heather Ackmann dives into popular topics including writing formulas and expres

  • +

    Course Syllabus

    ● Introduction to Excel 2013
        ◦ Introduction
        ◦ Creating a New Workbook
        ◦ Opening an Existing Workbook
        ◦ Signing into Excel 2013
        ◦ The Ribbon
        ◦ The Quick Access Toolbar
        ◦ The Formula Bar
        ◦ The Status Bar
        ◦ Navigating, Selecting, and Entering Data
        ◦ Introduction
        ◦ Navigating a Spreadsheet
        ◦ Selecting and Entering Data
        ◦ AutoFill
        ◦ FlashFill
        ◦ Saving
    ● Working with Rows, Columns, and Worksheets
        ◦ Introduction
        ◦ Inserting and Deleting Rows and Columns
        ◦ Hiding and Unhiding Rows and Columns
        ◦ Adding, Renaming, and Coloring Worksheets
        ◦ Moving and Deleting Worksheets
        ◦ Viewing Multiple Worksheets or Workbooks
    ● Introduction to Formulas
        ◦ Introduction
        ◦ Excel Math
        ◦ Creating a Simple Formula
        ◦ Relative, Absolute, and Named References
        ◦ Named References
    ● Introduction to Functions and 3D Formulas
        ◦ Introduction
        ◦ Excel Functions
        ◦ Sum, Average, and Count
        ◦ Introduction to 3D Formulas
    ● Sorting and Filtering Data
        ◦ Introduction
        ◦ Quick Sort and Custom Sort
        ◦ Creating Subtotals
        ◦ AutoFilter
        ◦ Custom Filters
        ◦ Advanced Filters
    ● Introduction to Formatting
        ◦ Formatting Basics
        ◦ Working with Alignment
        ◦ Number Formats
        ◦ Date and Times
        ◦ Conditional Formatting
    ● Introduction to Charts
        ◦ Introduction
        ◦ Chart Types
        ◦ Creating a Chart
        ◦ Chart Elements
        ◦ Chart Filters
        ◦ Change the Chart Type
        ◦ Sparklines and Data Bars
        ◦ Introduction to PivotTables and PivotCharts
        ◦ Introduction
        ◦ Creating a PivotTable
        ◦ Formatting a PivotTable
        ◦ Creating a Calculated Field
        ◦ Slicers
        ◦ Creating a PivotChart
        ◦ Introduction to Printing
        ◦ Introduction
        ◦ Print Views and Page Breaks
        ◦ Print Scaling
        ◦ Print Settings
        ◦ Adding Print Titles and Gridlines
        ◦ Conclusion
        ◦ Conclusion


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