Microsoft Excel 2010 Training - Beginner to Advanced Level

Learn from Ramzan Rajani (Microsoft Excel Specialist & Microsoft Certified Trainer)
4.5 (211 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,078 students enrolled
Free
Start Learning Now
  • Lectures 26
  • Length 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English

Course 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 2010 from the most basic Level to the most 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 !

What are the requirements?

  • Excel 2010 Software

What am I going to get from this course?

  • 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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started (Basic of Excel & Excel Shortcuts)
Excel Basics
29:52
Section 2: Conditional Formatting
Formatting data on the basis of Criteria
25:49
Conditional Formatting using formula
02:02
Section 3: Sorting & Filtering
Sorting (Arranging data in proper order)
13:32
Filter data according to your requirement
12:20
Section 4: Charts
Create Column, Line & Pie charts
28:34
Section 5: Pivot tables
Create summary reports from Huge Database
31:55
Section 6: Paste Special
Convert Formulas into value
12:56
Section 7: Validation
Create drop down in cells & Restrict invalid values in cell
22:53
Creating dependent list (Advanced Validation)
10:14
Section 8: Macros
Automate your regular activities with Macro recording
10:23
Section 9: Sub total & Text to Column (To Seperate First Name & Last Name)
Create Subtotal of Huge data
13:42
Seperate First & Last Name
14:24
Section 10: Hyperlink
Linking Sheets & other files
21:55
Section 11: Protecting Data
Protect Sheet & Workbook
08:53
Section 12: Basic Formulas
Sum, SumIF & SUMIFs
19:40
Finding Minimum, Maximum, Average & Calculate Average on condition
04:48
Section 13: IF Condition
IF Condition & Multiple IFs
19:49
Section 14: Vlookup & Hlookup
Compare & Pull data from another file
18:07
Index & Match (Reverse lookup)
04:47
Section 15: Change Case Functions (Upper, Lower & Proper)
Randbetween, Adding system date, time & converting data to Upper and Lower case
16:16
Section 16: Count Functions
Counting records, course blanks and count on the basis of Condition
05:26
Section 17: Other Regular used Functions
Calculate days between two dates
09:48
Section 18: Length, Trim & Concatenate Function
Count characters, Remove extra blank spaces & combine first & last name
14:00
Section 19: Excel Reference Materials
2 pages

More than 25 regular used shortcuts

Excel Tips and Tricks
23 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ramzan Rajani, Microsoft Certified Trainer & Microsoft office Specialist

Ramzan carries more than 8 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).

Ready to start learning?
Start Learning Now