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

The Ultimate Microsoft Excel 2013 Training Bundle

Course Summary

The Drop-Dead Simple Method to Mastering Microsoft Excel 2013, Without Books, in Less Time Than You Thought


  • +

    Course Syllabus

    • Learn Microsoft Excel 2013 Beginner/Intermediate Training Course
      • Excel 2013 Beginners: Introduction
        • Introduction to Excel 2013
        • What's New
      • Excel 2013 Beginners: Using Touch
        • Overview of Principles
      • Excel 2013 Beginners: Getting Started
        • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
        • Templates; Creating, Opening, and Saving a Workbook
        • Excel 2013 Exercise Files
      • Excel 2013 Beginners: Help
        • Online, Offline, and Contextual Help
      • Excel 2013 Beginners: Settings and Preferences
        • Excel Options
      • Excel 2013 Beginners: The Ribbon and Toolbars
        • Ribbon Interface
        • Quick Access Toolbar
        • Mini Toolbar
      • Excel 2013 Beginners: Backup and Recovery
        • Create Backup Option; Auto-Recover and Autosave
      • Excel 2013 Beginners: Enterting and Deleting Data
        • Entering and Deleting Data
        • Date Formats
        • Formatting Cells; Editing and Deleting Data
        • Fill
        • Flash Fill
      • Excel 2013 Beginners: 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
      • Excel 2013 Beginners: Copy, Paste and Paste Special
        • Copy, Cut and Paste
      • Excel 2013 Beginners: Proofing
        • Spell checking
      • Excel 2013 Beginners: Managing Worksheets
        • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
      • Excel 2013 Beginners: Comments
        • Inserting Comments
      • Excel 2013 Beginners: Viewing and Printing
        • Workbook Views, Zoom and Freeze
        • Printing; Headers, Footers and Margins
      • Excel 2013 Beginners: Formulas and Functions
        • Overview of Formulas and Functions
        • Cell References
        • Names
        • Finding Errors; New Excel Functions
      • Excel 2013 Beginners: Working with Workbooks
        • Multiple Workbooks and Windows; Comparing Workbooks
      • Excel 2013 Beginners: Find and Replace
        • Go to; Find and Replace Options
      • Excel 2013 Beginners: Conditional Formatting
        • Applying, Clearing and Managing Rules
      • Excel 2013 Beginners: Graphing and Charting
        • Chart Types; Chart Recommendation
        • Basic Formatting
        • Selecting Data, Positioning and Printing Charts
      • Excel 2013 Beginners: File Types
        • Saving Workbooks; PDF and CSV Formats
      • Excel 2013 Beginners: Managing Data
        • Sorting
        • Filtering
        • Tables
      • Excel 2013 Beginners: Functions Case Study
        • VLOOKUP
        • Text Function
        • Date and Time Functions
        • Logical Functions
      • Excel 2013 Beginners: Analyzing Data
        • Financial Analysis Case Study - Part 1
        • Financial Analysis Case Study - Part 2
        • Quick Analysis Tool
      • Excel 2013 Beginners: Shapes and Pictures
        • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
      • Excel 2013 Beginners: Sharing and Protecting
        • Protecting Worksheets
        • Protecting Workbooks
        • Sharing and SkyDrive
      • Excel 2013 Beginners: More Backstage View Options
        • Trust Center; Export; Inspect Workbook
      • Excel 2013 Beginners: Closing
        • Summary; More Help
        • Excel 2013 Quiz
      • Learn Microsoft Excel 2013 Advanced Training Course
        • Excel 2013 Advanced: Introduction
          • Prerequisites of Excel 2013 Advanced Course
          • Course Review
          • Excel 2013 Advanced Exercise Files
        • Excel 2013 Advanced: Functions
          • List of Functions; Common Types of Arguments; Basic Use of Functions
          • Advanced Aspects of Functions; Searching for a Function
          • Autosum
        • Excel 2013 Advanced: Personal and Professional Financial Functions
          • Payment
          • Future Value
          • Principle Payment
          • Depreciations
        • Excel 2013 Advanced: Date and Time Functions
          • How Dates and Times are Stored
          • Dates and Times Calculation
          • Exercise on Date and Time Functions; Date and Time Settings
        • Excel 2013 Advanced: Statistical Functions for Description and Prediction
          • Average
          • Percentile
          • Regression
          • LINEST Function
          • Example of Functions for Inferential Statistics
        • Excel 2013 Advanced: Text Functions
          • Text Function Case Study - 1
          • Text Function Case Study - 2
        • Excel 2013 Advanced: Lookup Functions
          • Lookup and Reference Functions
        • Excel 2013 Advanced: Logical Functions
          • Logical Functions
        • Excel 2013 Advanced: Connecting to External Data
          • Connecting to Other Workbooks
          • Connecting to Access Data
          • Connecting to Web Data
        • Excel 2013 Advanced: Tables
          • Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
          • Inserting Columns and Rows; Resizing Tables
          • Table Reference
          • Table Styles
          • Table Selection
        • Excel 2013 Advanced: Pivot Tables
          • Basic Principles of Pivot Tables
          • Presentational Side of Pivot Tables
          • Filtering in Pivot Tables; Slices
        • Excel 2013 Advanced: Data Analysis
          • What if
          • Scenario Manager
          • Goal Seeker
          • Solver
        • Excel 2013 Advanced: Charts
          • Area Charts
          • Surface Charts
          • Stock Charts - Part 1
          • Stock Charts - Part 2
          • Radar Charts
          • Bubble Charts
        • Excel 2013 Advanced: Graphs
          • Regression and Scatter Chart
        • Excel 2013 Advanced: Pivot Charts
          • Creating Pivot Charts
        • Excel 2013 Advanced: Sparklines
          • Using Sparklines
        • Excel 2013 Advanced: Web App
          • Creating Workbooks using a Web App
          • Sharing your Workbook
        • Excel 2013 Advanced: Conclusion
          • Closing
          • Excel 2013 Advanced Quiz


      Course Fee:
      USD 177

      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