Description
Microsoft Excel all-in-one Package - Become a certified Excel Ninja with our #1 Excel course:
Looking for an online Excel course to improve your skills and save time?
This basic and advanced excel training online can quickly get you up to speed with Excel, taking you from complete novice to Excel ninja.
This Microsoft Excel course covering 8 different sections with practice exercises and quiz before proceeding to next level. By the end of the course, you will be equipped with the real-world Excel knowledge you need to accomplish your daily tasks with ease.
Start mastering Excel, the world's most popular and powerful spreadsheet program and your sought after excel certification can help you impress your employer and advance your career prospects.
Are you ready to master Excel?
Enroll now to go through a detailed analysis of the most popular spreadsheet tool in the market, Microsoft Excel. As your instructor I will use my 10+ years of Excel training to guide you step by step through the beginner to advanced level.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will have mastered:
Contents:
The Ribbon commands and Navigation tools
Formatting, Alignment and wrap text
Hiding and unhiding rows and columns
Formula Anatomy
Cell Referencing (Relative, Absolute and mixed referencing)
Function Anatomy
Math Functions, Basic Statistics, Logic Functions, Text Functions
Understanding Dates & Time
Formula Auditing, Conditional Math
External Links and Temporal Functions
Naming Ranges, Excel Tables
Lookup functions (VLOOKUP with both matches, Using lookup with large tables, Nesting lookup functions, Index, Match, Index with Match functions
Creating, Formatting and Calculated Fields in Pivot Tables, Pivot Charts
Deep learning in Grouping functions such as Grouping by Date, time and other factors
Slicers to clarify & manipulating fields
What-if Analysis, Data Analysis Tools, Solver
Unpivoting Data, Power Pivot and Power query, Import data from a Text files, Appending Tables
Cell Formatting, Outlining, Custom Number Formats, Conditional Formats with built-in & custom rules
Building of Column Charts, Bar Charts, Pie Charts, Line Charts and combination line & area charts
Data Validation and security considerations
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel novice to Excel Ninja! Become a certified Excel ninja today.
Basic knowledge
Require a computer with excel installed (2016 version or later recommended)
This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. This Microsoft Excel Course will take you through 4 levels of Microsoft Excel Topics (Beginner, Intermediate, Advanced and Beyond)
Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help you take your Excel skills to the next level
Excel is utilized in almost every office in the world, thus offers a great scope. It is highly used in decision making and a kind of analysis tool that represents data into graphical form