Master Excel 2016, 2013 and 2010 – Formulas, Functions, Charts, LOOKUP, Pivot Table, What-If Analysis, Macros & VBA
ONLY $11.99 or Rs.500 Today. Sign Up Before It Goes Back to $19.99 / Rs.1,280 Tomorrow.
What you’ll learn
- 95 Lectures and 15 Assignments.
- 6.5 Hours of Video. 27 Downloads.
- Text, Date, Logical, Math, Financial, Statistical Functions.
- Pivot Table, LookUp, INDEX, MATCH and SEARCH.
- Automation with Macros and VBA.
- Charts, Trendlines, 3D Map and Drawing Tools.
- BONUS – Excel Shortcuts and Function Keys.
- BONUS – Free Excel 2016 eBook worth $4.99.
- Practical Learning with Case Studies.
- All Data files, Assignments and Solutions.
- Microsoft Excel 2016 – Beginner to Advanced Course.
Course Content
- Introduction to Excel 2016 –> 3 lectures • 14min.
- Working with Workbook and Worksheets –> 5 lectures • 17min.
- Introduction to Microsoft Excel Tables, Formulas and References –> 5 lectures • 17min.
- Formatting Data in Excel 2016 –> 4 lectures • 18min.
- Managing Your Data in Excel 2016 –> 5 lectures • 19min.
- Formulas in Excel –> 14 lectures • 1hr 4min.
- Inserting and Formatting Objects Some –> 2 lectures • 6min.
- Lookup and Reference Functions –> 5 lectures • 24min.
- Advanced Excel Tables –> 3 lectures • 12min.
- Using Charts in Excel 2016 –> 4 lectures • 23min.
- Pivot Table –> 4 lectures • 19min.
- What If Analysis –> 2 lectures • 9min.
- Data Analysis and Validation –> 7 lectures • 28min.
- Printing Excel Workbooks and Sheets –> 2 lectures • 8min.
- Macros –> 2 lectures • 5min.
- Managing Excel Files –> 3 lectures • 12min.
- Visual Basic for Applications (VBA) –> 3 lectures • 11min.
- VBA Case Study 1 –> 5 lectures • 22min.
- VBA Case Study 2 –> 9 lectures • 28min.
- VBA Case Study 3 –> 5 lectures • 15min.
- VBA Case Study 4 –> 3 lectures • 14min.
- Practice assignment for VBA –> 0 lectures • 0min.
Requirements
ONLY $11.99 or Rs.500 Today. Sign Up Before It Goes Back to $19.99 / Rs.1,280 Tomorrow.
***This Microsoft Excel course includes 95 Lectures, 15 Assignments (with Solutions), Excel eBook worth $4.99, Data files, Instructor feedback on assignments, Lifetime course access and 100% money-back guarantee form Udemy***
***This Microsoft Excel course is recorded in Indian Voice.***
Microsoft Excel – Excel from Beginner to Advanced & VBA is the most comprehensive Excel course on Udemy.
It comes with full set of course book, data files for exercises, case studies and solutions. This is the Microsoft Excel Bible that includes everything you need to know to become an Excel expert.
The course is recorded with Microsoft Excel 2016. I point out important differences from Excel 2013 whereever applicable. Whether you use Excel 2016 or Excel 2013, this course is all you need. In fact, most features should work in Excel 2010 as well.
You will learn everything you need to learn in Microsoft Excel, from basics to advanced features like Pivot Table, Charts, Sparklines, Macros, Workbook Management and VBA.
A unique feature of this course is the use of exercises and case studies to illustrate how to use Excel formulas, functions and features.
With this Microsoft Excel course, your Excel skills will go from starter to expert in just a few hours. Whether you want to learn Excel for business, work, or College, this is the right course for you.
This Microsoft Excel course has been used by thousands of people. It is licensed to multiple colleges, businesses and professional education companies in India, Malaysia and Dubai.
You will master the following Microsoft Excel features in this course:
- Excel User Interface
- Workbook and Worksheets
- Excel Tables
- Data Management
- Excel Formulas & Functions – Date, Financial, Information, Mathematical & Statistical and Text
- Inserting and Formatting Objects
- Lookup and Reference Functions
- Charts, 3D Map and Sparklines
- Pivot Table
- What If Analysis, Data Analysis and Validation
- Printing Excel Files
- Macros
- Managing Excel Files
- Advanced VBA
BONUS CONTENT:
- PDF with most common Excel 2016 keyboard shortcuts
- Excel eBook worth $4.99
If you are from the following countries, you will especially love the Charts and Graphs section. I use Sachin Tendulkar’s career stats to show you how to use different types of charts to analyze data.
- India
- England
- Ausrtalia
- SriLanka
- South Africa
- Pakistan
- Bangladesh
- New Zealand
- West Indian Island Countries
Enroll now and start mastering Microsoft Excel. Go from an Excel Novice to Excel Expert in just a few hours!
Videos are recorded in Indian voice so people from India and other Asian countries can also follow it easily.