XLNC
XLNC Logo

Analytics in Excel 

  • Offered byXLNC

Analytics in Excel
 at 
XLNC 
Overview

Getting Started with Excel for Data Analysis

Duration

6 months

Total fee

4,999

Mode of learning

Online

Official Website

Go to Website External Link Icon

Credential

Certificate

Analytics in Excel
 at 
XLNC 
Highlights

  • Earn a certificate after completion of course from XLNC
Details Icon

Analytics in Excel
 at 
XLNC 
Course details

Skills you will learn
Who should do this course?

All who use Excel on a regular basis wishing to learn more about performing various kinds of analysis and exploring more complex functions and calculations

Support staff, finance professionals and analysts wanting to increase their functional knowledge of Excel

What are the course deliverables?

Understanding Excel's capabilities for data analysis

Using Power Query for data transformation and automation of repetitive tasks

Using the Data Analysis Toolpak to perform basic statistical analysis.

Creating charts and graphs to visualize data patterns: bar charts, line charts, scatter plots, histograms, and more

More about this course

The Analytics in Excel course is designed to provide professionals with the skills to analyze data effectively and make informed decisions using Microsoft Excel

Excel is one of the most widely used tools for data analysis, and this course teaches participants how to leverage its powerful features for data manipulation, statistical analysis, and data visualization

This course equips you with the tools to gain insights, solve complex problems, and present data-driven findings with confidence

Analytics in Excel
 at 
XLNC 
Curriculum

Introduction
Work Files
 
Analytics for Decision Making
Analysis and Decisions
Introduction to Fundtions
SumIf and Countif
IF Statement
Multiple Conditions
IF Examples
Vlookup
Nested Statement with Vlookup
 
Excel Tools
Filters
Understanding Subtotals
Creating Subtotals
Conditional Formats
Using Formulas with Conditional Formats
 
Data Validation
Introduction to Validation
Constraining Data Input
Circling Invalid Data
Creating Static Lists
Dynamic Lists with Tables and Names
 
Charts and Graphs
Changes in Excel 2013
Creating Charts
Single Point Chart and Dialog Boxes
Titles that Work
Help with Chart Types
Sparklines
 
Trend lines
Forecasting with Autofill
Inserting Trend lines
Understanding the Types
The R Squared Value
 
Tables and Ranges
Named Ranges
Named Ranges continued
Excel Tables
Vlookup and Named Ranges
Merging and Spliting Cells
Upper and Lower Case
 
Understanding Plugins and Add Ins
Installing an Add In
Collections of Add Ins
Excel BackStage
 
Data Analysis Tools
Introduction to the Tools
Descriptive Statistics
Descriptive Statistics continued
Histogram
Histogram continued
 
What if Analysis
Overview of the Tools
Goal Seek
Goal Seek continued
Scenario
Scenario continued
Scenario Manager
Solver
Named Ranges and Solver
 
Data Tables
Understanding Data Tables
Single Criteria
Double Criteria
Criteria with Conditional Formatting
 
Pivot Tables
Intro to Pivots
Tables and Pivots
The Foundation
Working with the Slicer
Pivot Charts
Calculated Fields
 
Conditional statements
Highlighting Significant Data
Icon Sets
Formulas Coloring Columns
Formulas Rows
Customizing Icons and Highlights
 
Dashboards
What is a Dashboard
Creating a Dashboard
Creating a Dashboard Part II
Creating a Dashboard Part III
 
Automation
Developer Toolbar
Creating a Macro
Creating a Macro continued
Absolute vs Relative
Editing a Macro
Autocorrect
 
Report Writing
Starting with a Menu Page
Buttons rather than Hyperlinks
Key Points or Instructions
Interactive Spreadsheets
Scroll Bars
Radio Buttons
The Formulas
Motion
 
Presenting Data
Utilizing Shape
Working with SmartArt
Link Paste and Paste Special
Edit Links
Select Visible Cells
Pasting into PowerPoint
Motion in PowerPoint
otion continued
 
Comments and Review
A Twist on Comments
Comments with Data Validation
Protecting your Work
Protection continued

Other courses offered by XLNC

1.5 K
6 months
– / –
1.5 K
6 months
– / –
1.5 K
6 months
– / –
2 K
6 months
– / –
View Other 67 CoursesRight Arrow Icon
qna

Analytics in Excel
 at 
XLNC 

Student Forum

chatAnything you would want to ask experts?
Write here...