Rs. 199
Excel 2016 Tutorial: Learn Excel and Earn Now
Ace the corporate world with necessary skills of structuring data and automating reports. This course on MS Excel 2016 will teach you time-saving techniques and formulas.
01h:45m
Lifetime access
8
25 learners
Course Introduction:
Microsoft Excel 2016 is the most important computer skill used in the corporate world today. Excel can be used to create charts, identify trends, analyze data and much more. Learning Excel formulas would significantly benefit your job prospects. Without Excel formulas, Excel is just a data keeping tool. But by using Excel formulas, you can crunch data, analyze it and get answers to most of the complex questions.
Read more
Course Objectives:
By the end of the course, this course will:
- Gain more confidence using Excel to help you at work and increase productivity
- Learn how to use several data analysis tools and decipher formulas/fix errors on sheets.
- Automate reports that use tables and text summaries.
- Clean Data using Excel functions.
- Structure Excel Reports.
Pre-requisites and Target Audience:
This tutorial is best suited for:
- Sales and Marketing Managers
- Office Managers
- Financial Analysts
- Management Consultants
- Anyone interested in learning Excel and Excel Formulas to improve productivity.
The only requirement is to install Microsoft Excel 2013 or Microsoft Excel 2016 ion your computer.
Course Plan
1. Introduction to the Course
1 video Introduction to Excel and Earn Now 03:43
Salaries you can potentially earn
Tips on how to get the best out of this course
List of Excel Shortcuts
2. Structure Excel Reports Part 1
1 video Structure Excel Reports 06:03
3. Structure Excel Reports Part 2
2 videos · 1 test How to make Text proper? 05:43
Test 1
5. How to Automate Reports?
1 video · 1 test Automate reports using Formulas 11:55
Test 3
6. Calculating Working Days
2 videos · 1 test Adding working days to a date 07:16
Test 4
7. Data Basics Part 1
1 video · 1 test Auditing Formulas 13:32
Test 5
8. Data Basics Part 2
1 video · 1 test Using Sum Formulas 09:37
Test 6
9. Data Basics Part 3
2 videos · 1 test Using Lookup Function 14:00
Key concept of vlookup Function
Use of vlookup as an employable skill 03:27
Test 7
10. Including MS Excel skills on your CV/Resume
How to write Excel skills on your CV/Resume
11. Wrap Up Section
1 video Wrap Up Lecture 03:30
