Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi

Excel Dashboarding Tips

Home / Excel Dashboarding Tips
How to use CONDITIONAL FORMATTING in Excel
Excel Data Tips | Excel Dashboarding Tips

How to use CONDITIONAL FORMATTING in Excel

ByPradeep Kumar

Conditional Formatting helps to easily identify the usual and unusual numbers/ conditions, creating interactive visualization by means of Highlight Cells by Rules, Top/Bottom Rules, Data Bars, Color Scales and Icon Sets.

Read More How to use CONDITIONAL FORMATTING in ExcelContinue

Create Pareto Chart In Excel
Excel Data Tips | Excel Dashboarding Tips

Create Pareto Chart In Excel

Byexcelsirji
Watch Excel Tutorial Video - Create Pareto Chart In Excel What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the...

Read More Create Pareto Chart In ExcelContinue

Few Simple Excel Tips – Excel Learner Should Know
Excel Dashboarding Tips | Excel Data Tips

Few Simple Excel Tips – Excel Learner Should Know

Byexcelsirji

1. Change Direction When You Press Enter Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very simple. Do you…

Read More Few Simple Excel Tips – Excel Learner Should KnowContinue

Impress your Clients by Hiding these Simple Features
Excel Dashboarding Tips | Excel Data Tips

Impress your Clients by Hiding these Simple Features

Byexcelsirji

While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to…

Read More Impress your Clients by Hiding these Simple FeaturesContinue

Lock Cells to avoid editing, Hide Formulas
Excel Dashboarding Tips | Excel Data Tips

Lock Cells to avoid editing, Hide Formulas

Byexcelsirji
Watch Excel Tutorial Video - Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can...

Read More Lock Cells to avoid editing, Hide FormulasContinue

Protect Sheets, Share Workbook, Protect Workbook
Excel Dashboarding Tips | Excel Data Tips

Protect Sheets, Share Workbook, Protect Workbook

Byexcelsirji

Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change…

Read More Protect Sheets, Share Workbook, Protect WorkbookContinue

Hide Excel Sheet/Tab – Complete Guide
Excel Dashboarding Tips | Excel Data Tips

Hide Excel Sheet/Tab – Complete Guide

Byexcelsirji
Watch Excel Tutorial Video -Hide Excel Sheet/Tab – Complete Guide When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any changes...

Read More Hide Excel Sheet/Tab – Complete GuideContinue

How to Create dropdown List in Excel
Excel Dashboarding Tips | Excel Data Tips

How to Create dropdown List in Excel

Byexcelsirji
Watch Excel Tutorial Video - How To Create Dropdown List In Excel Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is...

Read More How to Create dropdown List in ExcelContinue

Create Dynamic Data Validation List – Offset Function Method
Excel Dashboarding Tips | Excel Data Tips

Create Dynamic Data Validation List – Offset Function Method

Byexcelsirji
Watch Excel Tutorial Video - Create Dynamic Data Validation List – Offset Function Method When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation”...

Read More Create Dynamic Data Validation List – Offset Function MethodContinue

  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search