Excel Dashboard Training in Saudi
Arabia, Riyadh, Jeddah, Dammam, Khobar
Build
Dashboards in Excel That Persuade, Inform and Engage
Wow your boss and take your career
to the next level.
Course Overview | Dashboard Training
with MS Excel
A good visualization can communicatethe nature and potential impact of information and ideas more powerfully than
any other form of communication. This visual language is used everywhere in the
world, from live sports to the news to ļ¬tness apps. Even if you think you can’t
speak this language, you hear it and understand it every day.
Building good dashboards in excel is
quickly becoming a need-to-have skill for managers. If you're not doing it,
other managers are, and they're getting noticed for it and getting credit for
contributing to the company's success. So, it’s time to learn to speak it, too.
Microsoft Excel Training in Saudi
Arabia is an excellent choice for creating and distributing dashboards due to
its ease of use and universal availability. It is a tool to make powerful
dashboards that can provide analysis, insight and alert managers in timely
manner.
In this comprehensive Excel
Dashboard Course you will learn the techniques you can apply in Excel to make
killer dashboards that will set your skill level apart from the crowd and
enable you to report, communicate, analyze, check and plan quantitative
information.
We will teach you how to create
amazing interactive Excel dashboards, that update with the click of the Refresh
button, or with a simple copy and paste of your new data into your spreadsheet.
Target Audience
·
Anyone
who is interested in making effective business Communication through Data using
excel.
·
Manager
working in any stream who requires to present / Project / Analyse the data
·
Employee
whose work is to create reports and present it in Effective Format
·
Corporate
Executives
·
Business
Analysts
·
Any
advance or intermediate Excel user who wants to learn more skills in Excel
Course Benefits
This hands-on training on dashboard
reporting in excel will provide you with an extremely advanced toolkit worth of
knowledge that will take the design of your reports to the next level. You will be
able to present valued information in a more accurate and concise way, which
can be updated and interpreted easily to make good decisions.
You will be able to display key trends, comparisons
and data graphically and interactively, so that you can see what you need
immediately.
This course will help you turn plain
and uninspiring information into smart, effective visualizations that
powerfully convey ideas.
By applying the rules, we will share
with you, you will have the skills to be able to create reports that save
loads of time (allowing you to go home early J) and you’ll
quickly become known as Excel Data Visualization Stars with
reports that are:
· Quick
and easy to update.
· Fully
interactive so the reader can change the view themselves.
· Easy
to read and interpret
· Professional
presentation
Participants should possess moderate
level of Excel knowledge to get more out from this course.
Microsoft
Excel – Executive Dashboards Training
EXCEL DASHBOARD DESIGN STRATEGIES
FOR CREATING ADVANCED SUMMARY AND LOOKUP TABLES:
·
Layout
And Organize The Raw Data That Your Excel Dashboards Will Use
·
Aggregation
Functions: Summarize Your Excel Dashboard Data Using SUMIF, SUMIFS,
COUNTIF, COUNTIFS, SUM, MAX, MIN, AVERAGE, RANK, SMALL, LARGE...
·
Lookup
Your Excel Dashboard Data Using VLOOKUP, MATCH, INDEX, LOOKUP...
·
Search
For And Return Entire Data Columns Or Rows For Your Excel Dashboard Using
INDIRECT, INDEX, MATCH And String Concatenation
·
Deal
With Dates And Time In Your Excel Dashboard Using The TEXT, YEAR, DAY, MONTH,
NETWORKDAYS.INTL, NOW, TODAY, TIME, TIMEVALUE, DATEVALUE, DAYS And SECONDS
Functions
·
Process
Your Worksheet Text In Your Excel Dashboard Using The LEFT, RIGHT, MID,
SUBSTITUTE, REPLACE, SEARCH, LEN, TRIM, CLEAN And TEXT Functions
·
Use
Advanced String Concatenation To Help Build Your Excel Dashboard Formulas And
Displays
EXCEL DASHBOARD DESIGN KEY WORKSHEET
LOGIC FUNCTIONS AND OPERATORS
·
Build
Logic Decisions Using The Relational Operators: <, >, <=, >=, <
>, =
·
Build
Logic Decisions Using The IF, AND, OR, IFERROR Logical Functions, Using Choose
Functions
·
Use
The IS Functions To Detect Cell Inputs And Formula Problems
·
Use
Logic In General, Figure Out The Strategies, Build Multiple Decisions, Figure
Out Logical Triggers And Use Them In Your Excel Dashboards
USING ADJUSTABLE NAMES AND EXCEL
TABLES IN EXCEL DASHBOARD DESIGN
·
Names
That Automatically Adjust To Changing Data Size, The Key To Building Advanced
Excel Dashboards
·
Use
Excel Table Syntax And Names In Your Excel Dashboard Formulas
·
Build
Adjustable Cell And Range Names From Formulas
·
Cell
And Range Naming Rules That Aid In Tracking Your Changing Data
·
Design
Table, Column And Row Names That Automatically Adjust To Changing Raw Data And
Start/Stop Positions Using The INDIRECT, OFFSET, COUNTA, COUNTIF And
MATCH Functions
ADVANCED EXCEL CHARTS FOR DASHBOARD
DESIGN
·
Creating
A Chart
·
Switching
The Row And Column Orientation
·
Changing
The Chart Type
·
Adding
And Deleting Chart Elements
·
Formatting
Chart Elements
·
Understanding
Chart Types
·
Creating
Combination Charts
·
Creating
And Using Chart Templates
·
Charting
A Noncontiguous Range
·
Converting
A Chart To A Picture
·
Linking
Title Text To A Cell
·
Working
With Chart Axes
·
Working
With Gridlines
·
Working
With Data Labels
·
Combining
Different Chart Types In One Chart
·
Creating
Custom Markers
·
Creating
Miniature Charts Suitable For Dashboards
·
Using
Sparklines
·
Target
Vs Actual Charts
·
Waterfall
Charts
·
Mix
Drawing Shapes With Charts To Produce Advanced Excel Dashboards
EXCEL DASHBOARD DESIGN STRATEGIES
FOR CREATING VARIOUS SPEEDOMETER STYLE GAUGES
·
Layout
And Build The Formulas And Tables That Your Speedometer Style Charts Will Use
·
Create
And Format The Pie Charts Turning Them Into Speedometer Style Gauges
·
Combine
Pie Charts With Doughnut Charts and Drawing Shapes To Create Speedometer
Style Gauges
USING PIVOT TABLES EFFECTIVELY FOR
DASHBOARD DESIGN
·
Creating
A Basic Pivot Table
·
Customizing
Your Pivot Table
·
Formatting
Numbers
·
Changing
Summary Calculations
·
Suppressing
Subtotals
·
Hiding
And Showing Data Items
·
Sorting
Your Pivot Table
·
Producing
Pivot Table Views
·
External
Data Sources
ENHANCING PIVOT TABLES
·
Grouping
Data
·
Working
With Field Settings
·
Creating
Calculated Field
·
Creating
A Calculated Item
·
Using
Slicer Tool Effectively For Creating Dashboards
·
Using
Powerpivot Feature To Create Report From Multiple Tables
USING PIVOT CHART DISPLAYS IN
EXCEL DASHBOARD DESIGN
·
Layout
And Organize The Raw Data That Your Pivot Table And Pivot Chart Will Use
·
Construct
A Pivot Table For Your Pivot Chart Taking Advantage Of Dynamic Names And Excel
Tables
·
Build
A Pivot Chart For Your Pivot Table
·
Create
Slicers And Timelines That Will Filter Your Pivot Tables And Charts
·
Format
Your Pivot Charts, Slicers And Timelines For That Microsoft Excel Dashboard
Look
·
Use
Conditional Formatting In Your Excel Dashboard Pivot Table
·
Create
Running Totals, Ranks... In Your Excel Dashboard Pivot Table
USING CONDITIONAL FORMATTING IN
EXCEL DASHBOARD DESIGN
·
Change
The Look Of Worksheet Cells Using Conditional Formatting
·
What
Is A Conditional Formatting Rule And Set Them Up
·
Manage
Your Conditional Formatting Rules
·
Setup
The Logic That Applies Multiple Conditional Formatting Rules To One Cell
·
Use
Advanced Logic In Your Conditional Formatting, The Key To Building Advanced
Excel Dashboard Displays
·
The
Key Conditional Formatting Rules That Will Help You Make Your Excel Dashboards
EXCEL DASHBOARD DESIGN STRATEGIES
FOR BUILDING STATUS DISPLAYS
·
Use
Conditional Formatting To Create Tables That Color Complete Areas Based Upon
Logic
·
Use
Conditional Formatting To Create Name Lists, Product Lists... That Change Color
When Their Logical Criterion Have Been Met In Other Tables
·
Use
Conditional Formatting To Create Icon Sets And Data Bars For Dashboard Tables
·
Applying
Conditional Formatting In Pivot Table
CHARTLESS VISUALIZATION TECHNIQUES
·
Dynamic
Labels
·
Linking
Formulas To Text Boxes
·
In-Cell
Charting
·
Using
Symbols
CREATING INTERACTIVE DASHBOARD
COMPONENTS
·
Adding
A Scroll Bar To A Data Window
·
Adding
Option Buttons To A Chart
·
Using
A Spin Button
·
Using
A Combo Box Drop-Down Menu
·
Using
A List Box Control
·
Using
The Check Box Control
SCENARIOS
·
Creating
Scenarios
·
Options
For Choosing Different Scenarios
DATA VALIDATION
·
Creating
Data Validation
·
Working
With List & Dependent List
·
Creating
List With Dynamic Ranges
·
Create
Formulas In Your Data Validation That Allow It To Adjust To Changing Excel
Dashboard Conditions
·
Create
Cells That Only Allow Certain Date Ranges To Be Entered
·
Handling
Input And Error Alerts
SECURING
AND DISTRIBUTING YOUR DASHBOARDS AND REPORTS
·
Securing
Access To The Entire Workbook
·
Limiting
Access To Specific Ranges
·
Protecting
The Workbook Structure
·
Linking
Excel Dashboards To Powerpoint
·
Building
Navigation Buttons
·
Distributing
Your Dashboards Via PDF
No comments:
Post a Comment