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 2010 Training - Beginner to Advanced Level

Course Summary

Learn from Ramzan Rajani (Microsoft Excel Specialist & Microsoft Certified Trainer)

  • +

    Course Syllabus

    • Getting Started (Basic of Excel & Excel Shortcuts)
      • Excel Basics
    • Conditional Formatting
      • Formatting data on the basis of Criteria
      • Conditional Formatting using formula
    • Sorting & Filtering
      • Sorting (Arranging data in proper order)
      • Filter data according to your requirement
    • Charts
      • Create Column, Line & Pie charts
    • Pivot tables
      • Create summary reports from Huge Database
    • Paste Special
      • Convert Formulas into value
    • Validation
      • Create drop down in cells & Restrict invalid values in cell
      • Creating dependent list (Advanced Validation)
    • Macros
      • Automate your regular activities with Macro recording
    • Sub total & Text to Column (To Seperate First Name & Last Name)
      • Create Subtotal of Huge data
      • Seperate First & Last Name
    • Hyperlink
      • Linking Sheets & other files
    • Protecting Data
      • Protect Sheet & Workbook
    • Basic Formulas
      • Sum, SumIF & SUMIFs
      • Finding Minimum, Maximum, Average & Calculate Average on condition
    • IF Condition
      • IF Condition & Multiple IFs
    • Vlookup & Hlookup
      • Compare & Pull data from another file
      • Index & Match (Reverse lookup)
    • Change Case Functions (Upper, Lower & Proper)
      • Randbetween, Adding system date, time & converting data to Upper and Lower case
    • Count Functions
      • Counting records, course blanks and count on the basis of Condition
    • Other Regular used Functions
      • Calculate days between two dates
    • Length, Trim & Concatenate Function
      • Count characters, Remove extra blank spaces & combine first & last name
    • Excel Reference Materials
      • Excel Shortcuts
      • Excel Tips and Tricks

Course Fee:
USD 20

Course Type:


Course Status:



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
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