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

Course Summary

Handle your workload 500% faster and get that promotion you deserve.


  • +

    Course Syllabus

    • Introduction to the course
      • Introduction
      • What is Microsoft Excel?
      • What will you learn from this course?
      • Earn your certificate of completion
    • Understanding the basics
      • Understanding the basics Intro
      • Create a new template
      • 3D Index
      • Workbook and Worksheets
      • Ribbon
      • The formula bar
      • Entering Data
      • Excel Operators
      • Find and Replace Tool
      • Hide Columns and Rows
      • Shortcuts
      • Understanding the basics
    • Save a file
      • Intro
      • Saving the workbook
      • Different Extensions
      • Auto Recover
      • Protect File
      • Save a file
    • Printing and Sharing
      • 1 - Intro
      • Let's Print
      • Print Selection
      • Print the Workbook
      • Print to file
      • Page Orientation
      • Printing and Sharing
    • Getting started with data
      • Intro
      • Copy and Paste
      • Paste Special
      • Undo & Redo
      • Format cells
      • Wrap text
      • Merge data
      • Comments
      • Hyperlinks
      • Flash Fill
      • Insert Equations & Symbols
      • Worksheet Background
      • Add and remove worksheets
      • Protect Worksheets
      • Freeze Panes
      • Format Painter
      • Tables and borders
      • Text to Columns
      • Getting started with data
    • View and Review
      • Intro
      • Page Views
      • Window arrangement
      • Spell-Check
      • Translate
      • View and Review
    • Accounting
      • Intro
      • Change Currency
      • Decimal Values
      • Format with percentage and comma
      • Accounting
    • Top 10 formulas to maximize your productivity
      • Intro
      • What is a formula?
      • Basic Syntax
      • SUM
      • COUNT
      • AVERAGE
      • SumIF, CountIF & AverageIF
      • LEN
      • IF Statement
      • "=" Sign
      • VLOOKUP
      • Analyse the formula
      • Lock cell references
      • Top 10 formulas to maximize your productivity
    • Pictures and graphics
      • Intro
      • Inserting Pictures
      • Inserting Shapes
      • Smart Art
      • Picture Position
      • Pictures and Graphics
    • Creating Charts
      • Intro
      • Why do we need them?
      • Different chart types
      • Creating a bar & column chart
      • Different axis
      • Trend line VS Limit line
      • Edit chart data
      • Data labels
      • Format chart area
      • Creating Charts
    • Conditional Formatting
      • Intro
      • Learn more about it
      • Different types of conditional formatting
      • Create a rule
      • Manage a rule
      • Clear a rule
      • Conditional Formatting
    • Pivot Tables
      • Intro
      • What is a pivot table?
      • Creating a pivot table
      • Manage criterias
      • Slicers
      • Pivot Tables
    • Sorting and filtering
      • Intro
      • Create a filter
      • Sort data
      • Create an Auto Fill
      • Data Validation Lists
      • Sorting and filtering
      • Bonus Lesson
    • Course Completion
      • Congratulations !


  • Course Fee:
    USD 69

    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