Brief Introduction
Further your Excel skills to manage larger datasets and more complex data wrangling, management and modelling.
Description
This intermediate Excel course builds on the teachings of the introductory Core Foundations course, teaching you to leverage the power of data calculations and reports to make informed personal or organizational decisions.
The course is designed for learners who already have foundational knowledge and skills in Excel but wish to take advantage of some of the higher-level functionality to more effectively analyze and present data. From error prevention to forecasting andautomation, you’ll build an advanced layer of knowledge to manage larger datasets and continue developing your aptitude for data modeling.
Knowledge
- How to manage multiple worksheets and workbooks.
- Analyzing data with datasets and tables.
- How to manage data analysis using Pivot Tables and Pivot Charts.
- Implementing What-If Analysis and Decision-Making Tools.
- Using Date, Logical, Statistical and Financial Functions.
Microsoft Advanced Excel Dashboard : Zero To Hero (Complete)
- 4
-
![]()
![]()
![]()
![]()
![]()
Create Attractive Advanced Excel Dashboard for Data Analytics with Visual using Excel Tools, Functions and Excel Macros Microsoft Excel Dashboard help user visualizes complex scenarios and problem better....
Manage Everything with Monday in 2020
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Ready yourself! Graduate with real skills in Project Management with Monday! It's time to be organized and improve your strategic planning with the best tool out there....
Increasing Real Estate Management Profits: Harnessing Data Analytics
- 4.7
-
![]()
![]()
![]()
![]()
![]()
In this final course you will complete a Capstone Project using data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc....
Excel for Everyone: Data Analysis Fundamentals
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Perform advanced data wrangling, analysis and dashboard visualization to help drive strategic decision-making. Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data....
