500 / $ 9.09This online course teaches you all the basic functions and shortcuts of MS Excel to make you get quicker at using this versatile software
- Learn to sort through data and apply reality checks on data
- Learn to apply powerful text functions to database for analyses
- Learn Basics, best practices, common mistakes, and when to apply
- Make visually appealing tables and charts quickly
- Learn to dynamically highlight /sort data to make business decisions
- Learn to analyze data according to pre-determined criteria
At the end of the class you will be confidently proficient and quick in using Excel for a large variety of business purposes.
Table Of Contents1. Introduction
1. IntroPreview this topic for free00:02:17
2. Getting Started: The Basics
1. Navigation00:02:36
2. FormattingPreview this topic for free00:08:32
3. Paste SpecialPreview this topic for free00:07:41
4. Selecting Data00:01:52
5. Grouping and Hiding00:01:38
6. Data Editing, Anchoring and Commenting00:06:07
7. Autosum and Naming00:03:11
8. Worksheets00:03:13
9. Exercises00:12:31
3. Filters
1. Data Filter00:07:23
2. Advanced Filter Part 100:03:02
3. Advanced Filter Part 200:03:08
4. Advanced Filter Exercise 100:03:09
5. Advanced Filter Exercise 200:01:30
4. Text and Conditional Functions
1. Text Functions00:05:39
2. IF function00:05:24
3. COUNTIF function00:01:17
4. SUMIF function00:01:17
5. SUMIF Exercise00:01:41
6. SUMPRODUCT00:01:55
5. Goal Seek
1. Goal Seek function00:02:01
2. Goal Seek Exercise00:04:18
6. LOOKUP and MATCH
1. VLOOKUP function00:04:51
2. VLOOKUP Exercise 100:07:02
3. VLOOKUP Exercise 200:09:52
4. MATCH Function00:03:24
5. HLOOKUP function00:02:31
7. Managing Data
8. Conditional Formatting
1. Conditional Formatting Exercise 100:04:04
2. Exercise 2 - Part 100:00:44
3. Exercise 2 - Part 200:02:03
9. Applications
10. Conclusion
1. All the best and Contact Us00:00:52
We provide hands-on training in Excel to professionals and students so that they can perform their day-to-day jobs with great ease and efficiency. Our compact and easy-to-follow classes comprise of practical illustrations, group projects, computer exercises and visual presentations.
Drawing on our vast experience, we have handpicked techniques that are the most useful in the real world and help professionals move up the learning curve faster. After undergoing our classes, professionals have noticed a drastic improvement in their skill set and efficiency levels.
