Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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 !
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started (Basic of Excel & Excel Shortcuts)|
|Section 2: Conditional Formatting|
Formatting data on the basis of CriteriaPreview
Conditional Formatting using formula
|Section 3: Sorting & Filtering|
Sorting (Arranging data in proper order)
Filter data according to your requirement
|Section 4: Charts|
Create Column, Line & Pie charts
|Section 5: Pivot tables|
Create summary reports from Huge Database
|Section 6: Paste Special|
Convert Formulas into value
|Section 7: Validation|
Create drop down in cells & Restrict invalid values in cell
Creating dependent list (Advanced Validation)
|Section 8: Macros|
Automate your regular activities with Macro recording
|Section 9: Sub total & Text to Column (To Seperate First Name & Last Name)|
Create Subtotal of Huge data
Seperate First & Last Name
|Section 10: Hyperlink|
Linking Sheets & other files
|Section 11: Protecting Data|
Protect Sheet & Workbook
|Section 12: Basic Formulas|
Sum, SumIF & SUMIFs
Finding Minimum, Maximum, Average & Calculate Average on condition
|Section 13: IF Condition|
IF Condition & Multiple IFs
|Section 14: Vlookup & Hlookup|
Compare & Pull data from another file
Index & Match (Reverse lookup)
|Section 15: Change Case Functions (Upper, Lower & Proper)|
Randbetween, Adding system date, time & converting data to Upper and Lower case
|Section 16: Count Functions|
Counting records, course blanks and count on the basis of Condition
|Section 17: Other Regular used Functions|
Calculate days between two dates
|Section 18: Length, Trim & Concatenate Function|
Count characters, Remove extra blank spaces & combine first & last name
|Section 19: Excel Reference Materials|
|Lecture 25||2 pages|
More than 25 regular used shortcuts
Excel Tips and Tricks
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).