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 Beginners/Intermediate Training

Course Summary

The Fastest Way to Learn Microsoft Excel 2013 Inside and Out - On Your Schedule


  • +

    Course Syllabus

    • Introduction
      • Introduction to Excel 2013
      • What's New
      • Course transcripts
      • Course exercise files & Excel 2013 keyboard shortcuts
    • Using Touch
      • Overview of Principles
    • Getting Started
      • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
      • Templates; Creating, Opening, and Saving a Workbook
    • Help
      • Online, Offline, and Contextual Help
    • Settings and Preferences
      • Excel Options
    • The Ribbon and Toolbars
      • Ribbon Interface
      • Quick Access Toolbar
      • Mini Toolbar
    • Backup and Recovery
      • Create Backup Option; Auto-Recover and Autosave
    • Entering and Deleting Data
      • Entering Text and Numbers
      • Date Formats
      • Formatting Cells; Editing and Deleting Data
      • Fill
      • Flash Fill
    • Formatting a Worksheet
      • Themes and Cell Styles
      • Inserting, Deleting, Hiding and Adjusting Rows and Columns
      • Wrap Text and Alignment
      • Merging Cells; Applying Themes and Styles
      • Borders
    • Copy, Paste and Paste Special
      • Copy, Cut and Paste
    • Proofing
      • Spell checking
    • Managing Worksheets
      • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
    • Comments
      • Inserting Comments
    • Viewing and Printing
      • Workbook Views, Zoom and Freeze
      • Printing; Headers, Footers and Margins
    • Formulas and Functions
      • Course Review
      • Overview of Formulas and Functions
      • Cell References
      • Names
      • Finding Errors; New Excel Functions
    • Working with Workbooks
      • Multiple Workbooks and Windows; Comparing Workbooks
    • Find and Replace
      • Go to; Find and Replace Options
    • Conditional Formatting
      • Applying, Clearing and Managing Rules
    • Graphing and Charting
      • Chart Types; Chart Recommendation
      • Basic Formatting
      • Selecting Data, Positioning and Printing Charts
    • File Types
      • Saving Workbooks; PDF and CSV Formats
    • Managing Data
      • Sorting
      • Filtering
      • Tables
    • Functions Case Study
      • VLOOKUP
      • Text Function
      • Date and Time Functions
      • Logical Functions
    • Analyzing Data
      • Financial Analysis Case Study - Part 1
      • Financial Analysis Case Study - Part 2
      • Quick Analysis Tool
    • Shapes and Pictures
      • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
    • Sharing and Protecting
      • Protecting Worksheets
      • Protecting Workbooks
      • Sharing and SkyDrive
    • More Backstage View Options
      • Trust Center; Export; Inspect Workbook
    • Closing
      • Summary; More Help
    • Downloadable course MP3 audio files
      • MP3 audio files
    • Microsoft Excel 2013 Quiz
      • Course Quiz


Course Fee:
USD 97

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