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

Basic Excel

Home / Basic Excel
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

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?
Excel Formula Tips | Excel Data Tips

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

Byexcelsirji

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…

Read More TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?Continue

VBA Code to Add New Sheet at Beginning or End of Excel File
Excel VBA Codes/Macros

VBA Code to Add New Sheet at Beginning or End of Excel File

Byexcelsirji

In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet at the end of Excel file…

Read More VBA Code to Add New Sheet at Beginning or End of Excel FileContinue

  • 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