Dashboards & Reports in Excel

1.GETTING STARTED

i).What is a dashboard
ii). Do's and Don’ts on dashboards
iii). Dashboard principles
iv).Dashboard Cycle
v). Planning for the dashboard

2. DASHBOARD DESIGN PRINCIPLES

i). Advantages of dashboards
ii). Drawbacks of dashboards
iii). Steps in dashboard designing
iv). Sharing the dashboard
v). Upgrading the dashboard

3.ON DEMAND CHARTS IN EXCEL

i). Creating Charts
ii). Types of Charts
iii). Gauge Chart
iv). Animation
v). Trendlines
vi). Dynamic Charts
vii). Waterfall charts

4. DATA CLEANING

i). Trim
ii). Upper, Lower, Proper
iii). Left, Mid, Right
iv). Concatenate & Replace

5. CONDITIONAL FORMATTING

i). Use of Highlight cell rules
ii). Use of Icon sets
iii). Use of Colour sets
iv). Top Bottom rules
v). Data bars & Colour scales

6. DYNAMISM IN THE DASHBOARD

i).Slicers & Time lines
ii). Dynamic text box
iii). Filtering using user developed filters
iv). Data validation
v). Form controls

7.NAVIGATION

i).Text Hypelinks
ii). Objects Hypelinks
iii). Icons
iv). To Web Sites
v). To Other Files

8. WORK PROTECTION

i). Protecting Workbook
ii). Protecting Worksheet
iii). Protecting Range
iv). Selecting locked & Unlocked cells
v). Hiding & unhiding formulas

Proggramming Courses