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.