MS Excel Basic to Advanced Level

Become Excel Professional user

Instructed by Ramzan Rajani

Want to learn more?
Go for Premium Subscription

Choose your plan:

  • Monthly
  • Annually
$ 29
Monthly Subscription
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
Need Help?

Call +1 855 999 1795

( Toll Free )
  • 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...
learn-ms-excel-from-basic-to-advance

Learn MS Excel From Basic to Advanc...

By : Ashwini Bissa

Lecture 14

odoo-purchases-sales-inventory-with-accounting-modules

Odoo: Purchases, Sales, Inventory w...

By : Quantic Statistics R spatial analysis

Lecture 13

how-to-carry-out-term-loan-appraisal-as-banker

How to carry out Term Loan Appraisa...

By : CA N Raja Natarajan

Lecture 39

accounting-basics-in-66-minutes

Accounting Basics in 66 Minutes

By : CA N Raja Natarajan

Lecture 13

how-to-carry-out-financial-analysis-as-a-banker

How to carry out Financial Analysis...

By : CA N Raja Natarajan

Lecture 25

Buy

$15

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now