Skip to content
ExcelSirJi
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Excel Functions
  • Excel Shortcuts Keys
  • Productivity Tools
Courses
ExcelSirJi

Excel Dashboarding Tips

Home / Excel Dashboarding Tips
CONDITIONAL FORMATTING In  Excel
Excel Data Tips | Excel Dashboarding Tips

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 CONDITIONAL FORMATTING In ExcelContinue

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

Create Pareto Chart In Excel

Byexcelsirji

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 causes. So if we closely monitor and solve 20% of…

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

Few Excel Tips 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…

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

How to Hide Ribbon &Formula bar in excel? 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…

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

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 protect the sheets, workbooks and…

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

How to protect and share your workbook? 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…

Read More Protect Sheets, Share Workbook, Protect WorkbookContinue

How to Hide Sheet in Excel with or without VBA?
Excel Dashboarding Tips | Excel Data Tips

How to Hide Sheet in Excel with or without VBA?

Byexcelsirji

Video: How to Hide Worksheet in Excel? Hide Sheet in Excel When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any…

Read More How to Hide Sheet in Excel with or without VBA?Continue

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 How to Create a Dropdown list in excel?  Microsoft Excel is what most professionals are using for their day-to-day office.  Creating a drop-down…

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

Create Dynamic Data Validation List When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all…

Read More Create Dynamic Data Validation List – Offset Function MethodContinue

DMCA.com Protection Status
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2023 ExcelSirJi

  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Excel Functions
  • Excel Shortcuts Keys
  • Productivity Tools
Search