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

Learn Microsoft Excel 2013 - Advanced

Course Summary

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes


  • +

    Course Syllabus

    • Introduction
      • Prerequisites of Excel 2013 Advanced Course
      • Course exercise files
      • Microsoft Excel 2013 keyboard shortcuts
      • Course transcripts
      • Downloadable course MP3 audio files
    • Functions
      • List of Functions; Common Types of Arguments; Basic Use of Functions
      • Advanced Aspects of Functions; Searching for a Function
      • Autosum
    • Personal and Professional Financial Functions
      • Payment
      • Future Value
      • Principle Payment
      • Depreciations
    • Date and Time Functions
      • How Dates and Times are Stored
      • Dates and Times Calculation
      • Exercise on Date and Time Functions; Date and Time Settings
    • Statistical Functions for Description, Prediction and Interference
      • Average
      • Percentile
      • Regression
      • LINEST Function
      • Example of Functions for Inferential Statistics
    • Text Functions
      • Text Function Case Study - 1
      • Text Function Case Study - 2
    • Lookup Functions
      • Lookup and Reference Functions
    • Logical Functions
      • Logical Functions
    • Connecting to External Data
      • Course Review
      • Connecting to Other Workbooks
      • Connecting to Access Data
      • Connecting to Web Data
    • 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
    • Pivot Tables
      • Basic Principles of Pivot Tables
      • Presentational Side of Pivot Tables
      • Filtering in Pivot Tables; Slices
    • Data Analysis
      • What if
      • Scenario Manager
      • Goal Seek
      • Solver
    • Charts
      • Area Charts
      • Surface Charts
      • Stock Charts - Part 1
      • Stock Charts - Part 2
      • Radar Charts
      • Bubble Charts
    • Graphs
      • Regression and Scatter Chart
    • Pivot Charts
      • Creating Pivot Charts
    • Sparklines
      • Using Sparklines
    • Web App
      • Creating Workbooks using a Web App
      • Sharing your Workbook
    • Conclusion
      • Closing
      • Assessment Test
    • Downloadable course MP3 audio files


    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