About the course
Quickly learn A-Z of Excel 2016, Formats, Pivots, Excel Charts, Excel Functions, Excel VBA and Data Analysis in Excel
What Will I Learn?
Introduction to worksheets, workbooks, and toolbar: Learn the basics of Excel and how to navigate a spreadsheet.
Cells, Ranges, Tables, Worksheet operations: Navigate the spreadsheet and begin to change the way cells, ranges, and tables look and function.
Formatting cells and conditional formatting: Easily set rules and conditions for cells within the worksheet, so you stay organized.
Formulas and Functions: Learn how to calculate complicated equations the easy way.
Charts: Give your data a visual representation that is easier to understand and useful.
Data Protection and Validation: Keep others from changing the cells in your worksheet through data protection and validation.
Pivot Tables: Quickly summarise, analyse, and sort your data with easy-to-use pivot tables.
What-If Analysis: Explore a variety of different results by comparing two sets of data within the spreadsheet.
Descriptive Statistics: Easily and quickly produce a summary of key statistics for any given data set.
Visual Basic for Applications (VBA): Become an Excel wizard by writing your own programmed tasks directly in Excel to automate complicated tasks.
- Basic computer knowledge and Ms Excel
This course is updated regularly to include new lectures, quizzes/practice activities
About the course
This course is your complete guide to mastering Microsoft Excel. This course covers all aspects of working on Excel, starting from basic concepts like what are worksheets, rows, columns, tables and then moving onto different Formats in Excel and Conditional Formatting where we have covered all thedifferent scenarios which one can think of. We then move onto more intermediate topics in Excel likeFunctions where we discuss Statistical, Math, Text, Logical, Lookup functions in MS Excel. We then discuss Data Protection and Validation which everyone uses to protect data from other users.
We then move onto more advanced topics of Pivot tables in which we discuss unique features of a pivot table and have a case study for you to understand how Pivot tables are used in real life. In Charts we cover distinct types of charts, how to do trend analysis using charts, sparkline charts and then move onto more statistical concepts which are essential for a data analyst - “what if” analysis, data interpretation using Data Analysis toolbox within Excel and finally VBA where we learn basics of VBA, how to create custom functions using VBA and finally a UserForm which will help you is automating your work!
This course is basically THE Bible of Excel you want, and the explanation and examples provided are something which haven’t been done in any other course on this platform.
There are helpful quizzes included in all sections that will help you to cement the concepts learnt. Also, we are committed to add new practice activities so that you can practically apply the concepts learnt in this course.
Why should you start learning Excel NOW!
- Jobs in Excel – Almost every organization uses Excel for data entry and knowing it will already put you over others
- Demand is only going to go up – As organizations have started to understand the importance of having data, storing data, the demand for more people being comfortable in Excel will only go up. And for a Data Analyst, it is THE backbone!
- Easy to learn, easy to use and very flexible
Why learn from Us?
EXCEL in EXCEL is our motto!!
Saving HUNDREDS of dollars and your time with the most effective training course ever created. Gain instant access to the exact training courses used to train over 4,000 beginners to become experts in using excel for day to day jobs and for analytics techniques and data manipulation.
Call us ambitious, but we are trying to save you time and money while giving you quality.
Don’t work hard – Work smart!
Who is the target audience?
- The course has been developed for anyone who wants to learn MS Excel and VBA. And for even those who want to understand how Excel is used in Data Analytics
Talend Data Integration Course : Beginner to Expert