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

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: