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

Mastering MS Excel® (Beginners/Intermediate)

Course Summary

Learn MS Excel® in a Weekend


  • +

    Course Syllabus

      • Intro/Promo
      • Introduction
    • Getting Started
      • What Is MS Excel
      • Work area and menu
      • Keyboard Shortcuts
    • Your first MS Excel file
      • Create A New File
      • Cells, Rows, Columns
      • Enter Data
      • Saving Files
    • Working with Worksheets
      • Add, Delete, Rename
      • Tab Colors
      • Split Windows & Freeze Panes
      • Hide And Unhide
      • Hide And Unhide Contd
      • Protect And Un Protect
      • Working With Shapes
    • Cell Formats and Options
      • Height And Width Of Rows & Columns
      • Types Of Data
      • Align And Indent
      • Font Options
      • Font Options
      • Hyperlinks
      • Context Menu
      • Insert , Delete And Move Columns, Rows & Cells
      • Cut , Copy And Paste
      • Paste Special
      • Clipboard
      • Cell Borders
      • Merge Cells
      • Wrap Text
    • More on formatting
      • Conditional Formatting
      • Data Validation
      • Naming Ranges
      • Special Characters
      • Format Painter
    • Formulas and Functions
      • Relative and Absolute Cell references
      • Other sheet references
      • Excel functions
      • Excel functions example
    • Dealing with data
      • Importing Data in Excel
      • Text to Columns
      • Handling duplicate data
      • Sort and Filter Data
    • Finalizing the Workbook
      • Check spellings
      • Cell comments
      • Hide Worksheets
      • Excel find and replace
      • Excel lock and unlock cells
    • Printing Your Workbook
      • Print Ranges
      • Print Margins in Excel
      • Excel Shrink to fit
      • Headers and Footers
      • Page Breaks
    • Charts and Labels
      • Excel Charts
    • Pivot Tables
      • Build
      • Excel Pivot Options
      • Pivot Charts


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

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