We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

In this Excel dashboard course we will train you how to create dashboard in Excel by summarize the data in Excel worksheet. We will explain using the Excel tables, the most efficient way to store and present the data in Excel as a dashboard. We will teach you pivot tables, several types of conditional formats, and how to summarize your data using charts.

Microsoft Excel Dashboard Training Course Singapore uses very advanced functions of Pivot Table, Formulas, Several types of conditional formats, and how to summarize your data using charts. & Charts used for your management reports like Accounting, Finance, Profit & Loss, Sales & Marketing.

  • After Excel Dashboard Course You will be able to know:
  • How to create dashboard in Excel
  • Link worksheet data to cells and shapes
  • Hide and filter table data
  • Changing the Excel program window to meet your needs

    Register Today - https://exceltraining.com.sg/excel-dashboard-course-singapore/

Outline

Creating Advanced Formulas
  • Use Range Names in Formulas
  • Use Specialized Functions
Automating Workbook Functionality
  • Apply Data Validation
  • Work with Forms and Controls
Applying Conditional Logic
  • Use Lookup Functions
  • Combine Functions
Visualizing Data with Basic Charts
  • Create Charts
  • Modify and Format Charts
Advanced Charting Techniques
  • Use Advanced Chart Features
  • Create Sparklines
Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers
Reviews
Be the first to write a review about this course.
Write a Review

Excel Training is intended for current Microsoft Excel users who wish to deal with workbook and productivity features. It includes areas such as creating Complex Charts, Pivot Table, worksheet consolidation and linking with external data file, data analysis tools, and automating workbook operations using macros.


We have massive length of Excel courses to develop and improve your skills: Some are:
Microsoft Excel Course, Master Excel, Basic Excel, Intermediate & Advanced Excel and Many More..

Visit us - http://exceltraining.com.sg/

Excel Training
Singapore , International Plaza, Singapore 079903
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.