Microsoft Excel Training - Beginner to Advanced Level
4.6 (318 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,332 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Training - Beginner to Advanced Level to your Wishlist.

Add to Wishlist

Microsoft Excel Training - Beginner to Advanced Level

Learn from Ramzan Rajani (Microsoft Excel Specialist & Microsoft Certified Trainer)
4.6 (318 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,332 students enrolled
Created by Ramzan Rajani
Last updated 8/2017
English
English [Auto-generated]
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • After successfully completion of the course you will be able to generate reports
  • Can create stunning charts
  • Will be comfortable in writing your own IF Conditions
  • Will be able to pull data from anothe file with Vlookup
View Curriculum
Requirements
  • Excel 2010 Software
Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

As you know Excel is the most used computer application in the world. Because of this, Excel skills are in high demand by most of the organizations.

In this course will teach you how to use Microsoft Excel from the most basic Level to the advanced features.

Each topic in this course is presented in a separate video lesson, allowing you to learn as much or as little as you like at a time. You are also able to watch videos as many times as you like if you need to.

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

Happy Learning !

Ramzan Rajani

Who is the target audience?
  • Finance Manager
  • Students
  • HR Managers
  • Sales Manager
  • Training Manager
  • Executives
  • Analyst
Compare to Other Excel Courses
Curriculum For This Course
26 Lectures
06:37:05
+
Getting Started (Basic of Excel & Excel Shortcuts)
1 Lecture 29:52
+
Conditional Formatting
2 Lectures 27:51

In this topic you will learn Step by Step how to format / color the data on the basis of some condition.  I have attached the practice file, please see the video once, then download the file and practice once again.  Follow this for all the topics it will give you good practice.

Conditional Formatting using formula
02:02
+
Sorting & Filtering
2 Lectures 25:52
Sorting (Arranging data in proper order)
13:32

Filter data according to your requirement
12:20
+
Charts
1 Lecture 28:34
Create Column, Line & Pie charts
28:34
+
Pivot tables
1 Lecture 31:55
Create summary reports from Huge Database
31:55
+
Paste Special
1 Lecture 12:56
Convert Formulas into value
12:56
+
Validation
2 Lectures 33:07
Create drop down in cells & Restrict invalid values in cell
22:53

Creating dependent list (Advanced Validation)
10:14
+
Macros
1 Lecture 10:23
Automate your regular activities with Macro recording
10:23
+
Sub total & Text to Column (To Seperate First Name & Last Name)
2 Lectures 28:06
Create Subtotal of Huge data
13:42

Seperate First & Last Name
14:24
+
Hyperlink
1 Lecture 21:55
Linking Sheets & other files
21:55
9 More Sections
About the Instructor
Ramzan Rajani
4.6 Average rating
320 Reviews
5,721 Students
3 Courses
Microsoft Certified Trainer & Microsoft office Specialist

Ramzan carries more than 15+ years of experience in the field of IT Training & Project Management. After getting his Diploma in Information Technology 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 programming, advance Powerpoint, Excel Dashboard, MS Access & MSP (Microsoft Project).

Along with other companies around the world he has done trainings for the following companies in UAE - Dubai : Manipal University, Etisalat, World Bank Group, Sharjah Islamic Bank, Emirates NBD, Redbull, Carestream health, Rotana, Funcity, Johnson & Johnson, Mastercard, Dulsco, AstraZeneca & MAF (Majid al Futtaim Properties).

Ramzan is based in Dubai.