Brief Introduction
Perform advanced data wrangling, analysis and dashboard visualization to help drive strategic decision-making.
Description
This advanced Excel course builds on the teachings of Course 1: Core Foundations and Course 2: Data Management. Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data.
Whether you need to process numbers for personal projects or for organizational purposes like sales, inventory, human resources, or IT, knowing how to make sense of data is critical. You will develop in-demand skills to gain a competitive edge and value to your organization, including how to extract actionable organizational intelligence from raw data, and present it in a visual format to help drive organizational decision-making Learn how to get Excel to do the hard work for you with sophisticated automation, spreadsheet design and powerful dashboards.
Knowledge
- How to apply advanced formulas and conditional logic.
- How to analyze and report on data frequently.
- Automating complex or repetitive tasks.
- How to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
- Protecting your workbooks.
- Performing Formula Audits and Data Validation.
- Creating Macros and usingVisual Basic.
- How to use Advanced Charting Techniques to build professional dashboards.
Lean Six Sigma Green Belt Online Course (2020)
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Prepare for CSSGB Certification-154 Lect/ 15 Hrs/Minitab/Download 108 Resources/LSS Case Study/Eng Subtitles ___________________________________ COURSE UPDATED IN 2020 Includes Subtitles in English...
Business Fundamentals 2020 Accounting Excel & Stock Research
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn accounting, Excel and stock due diligence with a professional analyst This course covers accounting principles, Excel modeling, reading and analyzing a company’s SEC filings, 10K's & 10Q's....
Microsoft Project Beginner to Advanced Bundle
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Claim 35 PDUs! The Ultimate Microsoft Project Bundle covering 2016 & 2019 editions and taking you from novice pro **Course includes practice exercise files and LIFETIME access....
Introduction to R Programming for Data Science
- 4.8
-
![]()
![]()
![]()
![]()
![]()
When working in the data science field you will definitely become acquainted with the R language and the role it plays in data analysis....
