Advanced Data Analytics with Microsoft Excel

LM
lms_admin

About This Course

INTRODUCTION

Welcome to Laures Academy’s Advanced Data Analytics with Microsoft Excel course! Developed and taught by leading data analysts, this innovative course is designed to help you leverage expert-level data analysis skills that can be applied to virtually every industry. As part of your enrollment in the course, you will receive a certificate to signify your newfound skills in Excel, including data organization, chart creation, report building, and more.

COURSE OBJECTIVES
  • Understand the principles behind data mining, power query, importing data, and organizing data.
  • Utilize techniques such as building charts, performing What-If scenarios, and using functions.
  • Leverage sampling techniques from data sets using the Data Analysis command
  • Apply Business Intelligence tools to transform data into useful information.
  • Know how and when to implement multiple data parameters, particularly within Power BI
  • Ensure the validity of data while locating errors or duplicates using rules and formula auditing
  •  

Why Learn from US

  • Relevant information for anyone in a data scientist or related role
  • Actionable insight to improve your aptitude within Excel
  • Vetted content by leading data scientists and analysts
  • Applicable information throughout every industry
  • Lessons to improve your organization, decision-making, visualization, and problem-solving skills.
  • Course certificate to boost your marketability
LEARNING OUTCOMES
  • Data mining and analysis techniques to effectively use data
  • Power business Intelligence to interpret data sets
  • Sampling techniques that improve accuracy
  • Data validation techniques for more dependable information
  • Data parameter management to filter variables
  • Formula auditing and error-checking
  • Data quality assessments that ensure quality inputs
  • What-If analyses to determine the impact of changes
  • Data source validation to properly use each data set
  • Data visualization to build relevant charts and tables

Course Outline

1. Database

1.1 databases

2. Data Mining

2.1. What is Data Mining?

2.2. Understand Your Data

2.3. Sources of Data

2.4. Import External Data into Worksheet Using the Text Import Wizard

2.5 Organizing Data

2.6. Data Extraction using LOOKUP Functions 

2.7. Power Query 

3. Analysis Techniques

3.1 Math Functions SUMIFS, COUNTIFS, AVERAGEIFS

3.2 Financial Functions using NPV, IRR, PMT, IPMT & PPMT

3.3 What-If Analysis using Goal Seek

3.4 What-If Analysis using Scenario Manager

3.5 Using Solver for Optimization

3.6 Use PivotTable & PivotChart for Data Summarization

3.7 Using Charts for Data Visualization & Analysis

4. Sampling Techniques

4.1 What is Sampling?

4.2 Loading Analysis Toolpak in Excel

4.3 Using Analysis Toolpak to Perform Sampling

5. Business Intelligence (BI) Tools

5.1 An Overview of BI & BI Tools

5.2 BI Tools used by Organizations

5.3 Using Power BI

6.Data Parameters

6.1 What is a Parameter

6.2 Setting Parameters

7. Data Quality Standards

7.1 Data Validation Tool

7.2 Validate Formulas

7.3 Removing Duplicate Data

Target Audience

  • Intermediate-level data scientists seeking to build on their skills
  • Entry-level professionals who want to become more marketable through Excel
  • Prospective analysts who will regularly use Excel within their roles
  • Anyone looking to expand their intermediate knowledge of Excel
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Compare
Wishlist 0
Open wishlist page Continue shopping