Excel skills are in high demand by most of the organizations. 

Description

In this course I will teach you Step by Step how to generate Summary reports, formulas from basic to advanced level including Vlookup, IF Condition, Multiple IFs and lot many which you can use in your reporting.

Each topic in this course is presented in a separate video lesson

This course will teach you how to save time and be productive.

You should Pause the video, rewatch, and repeat exercises until you mastered them.

Happy Learning !

Thanks & RegardsRamzan Rajani(Microsoft Excel Specialist and Certified Trainer)[email protected]

• Finance Manager
• Students
• HR Managers
• Sales Manager
• Training Manager
• Executives
• Analyst

Course content

• 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 & Reference Material

Microsoft_Excel_Training_-_Beginner_to_Advanced_Level.part1.rar

Microsoft_Excel_Training_-_Beginner_to_Advanced_Level.part2.rar

Microsoft_Excel_Training_-_Beginner_to_Advanced_Level.part3.rar