MS Excel Basic to Advanced Level

Become Excel Professional user

Instructed by Ramzan Rajani

  • Excel Shortcuts so that you can work faster in Excel
  • Conditional Formatting in Detail (12 options)
  • Sorting with Multiple Levels
  • Filtering data on different criterias
  • Creating Stunning Charts (Column, Line, Pie & Bar charts)
  • Pivot Table (To create summary report for management) - One of the best option of MS Excel which is widely used
  • Validation (Creating drop down in Excel)
  • IF Condition with Multiple Level of IFs
  • Vlookup (Vertical Lookup) to pull the data from Same or other file
  • Change case formulas (Converting small to capital letter)
  • Hyperlink
  • Sharing file with other user
  • Concatenate & Trim Formulas
  • Creating small summary report with SubTotal

Dear friends, as you know, Excel is one of the most powerful tools for managing & presenting data. In this online video training, you will learn step by step all the regular used options like Conditional Formatting, Sorting, Filtering, Charting, Pivot table with lots of interesting Shortcuts & Formulas.

Make sure you practice after viewing each video to get grip on each topic & become super star in Excel

Welcome to the course & Happy Learning !

  • MS Excel 2007 or latest version
  • No previous MS Excel Knowledge required, as i will start from Basic to Advanced Level
  • Notepad & Pen to write down Interesting Shortcuts & bullet points
  • Executive to Senior Level of Management
  • Accountant & Finance executives
  • HR & prople working in Sales & Marketing
  • College students
View More...

Section 1 : Unpublished Section

  • Lecture 1 :
  • MS Excel Basic Formatting with Shortcuts Preview
  • Lecture 2 :
  • Conditional Formatting (Formatting - Color on the basis of condition)
  • Lecture 3 :
  • Sorting (Arranging Data) & Filtering (Extracting data as per condition)
  • Lecture 4 :
  • Creating Stunning Charts (Column, Line, & Pie Charts)
  • Lecture 5 :
  • Pivot table (To create the Summary Reports) - For Management Reporting
  • Lecture 6 :
  • Hyperlink
  • Lecture 7 :
  • Sharing File with Multiple Users
  • Lecture 8 :
  • SubTotal (Creating Small Summary report from huge database)
  • Lecture 9 :
  • Validation (Creating Drop Down in Excel)
  • Lecture 10 :
  • Protecting Excel File
  • Lecture 11 :
  • Change Case Formula (Converting Text to Capital & in Small Letter)
  • Lecture 12 :
  • Concatenate and Trim
  • Lecture 13 :
  • Sum and Referencing
  • Lecture 14 :
  • Vlookup (Vertical Lookup - To pull data from other file or sheet)
  • Lecture 15 :
  • IF Condition

Ramzan Rajani,

Ramzan carries more than 15+ years of experience in the field of IT Training & Project Management. After getting a Diploma in Information Technology from National Institute of Management, he did his MBA with Dual specialization in IT Project Management. He has experience of designing, managing & implementing large databases bearing very good understanding and extensive experience in Advance Excel, VBA – Macros, Advance Power-Point & Excel Dynamic Dashboard. Have trained more than 5000+ employees from executive to senior management in different companies across locations. Ramzan regularly travels to Saudi, Tunisia, Oman & Maldives to conduct trainings & IT consultancy for report automation on regular basis. Have trained around 1500+ employees from 24 different banks in UAE from Executive Level to Finance Managers through difference vendors. Specialties: 1) Advanced Excel, 2) Excel for HR, Sales & Finance, 3) Excel Macros VBA Programming for report automation 4) Excel Dynamic Dashboard  Excel Advanced Formulas
View More...

Enabling and Managing Office 365

By : Microsoft

Lecture 13

$300

Advanced Technologies of SharePoint...

By : Microsoft

Lecture 12

$300

Need any help with the platform? Contact us at: support@learnfly.com