logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
5 GMAIL HACKS
November 13, 2019
Wildcards
November 28, 2019

5 Things to avoid in MS Excel

November 19, 2019

While MS Excel can be a great tool to automate your work, save loads of time and make your work flexible, there are certain things that you need to keep in mind to avoid unnecessary complications.

⦁ ‘/’ Instead of ‘.’

Excel doesn’t recognize date formats such as 23.09.2019. Applying formulas, filtering data in tables that have dates, work only when dates are entered as 23/09/2019 instead.

date1 gif

Use Ctrl+H to replace ‘.’ With ‘/’

date 2 gif

⦁ Inappropriate charts

Excel provides a variety of charts for a reason, but not every chart is suitable for every data.
When analyzing market share, the pie chart is more informative than the line chart.

Image 1

While when showing GDP growth, the line chart is more relevant than the pie chart.
Moreover, pie charts can show only one set of data at a time. Here, the line chart shows the GDP growth of both the countries in the same chart, which also helps in analyzing as to which country is performing better. Whereas two pie charts need to be created for different countries and the information is not even clear. (Pie chart only for Country A is shown in the picture)

Image 2

⦁ Not using absolute cell references

When creating formulas, not fixing cells with ‘$’, is like wasting one of the key functions of Excel. It helps you keep some inputs in the formula constant while you’re dragging it across the sheet, say per unit revenue in the video below without having to type the formula again for different months.

Absolute Reference-gif

⦁ Merging Cells

Pivot is a great tool to summarize data in excel. However, merging cells in the table refrains us from making full use of the same by giving blank cells for merged cells.

When Merged

Image 3

When not merged

Image 4

⦁ Not using the freeze function

When working with huge data, it is always advisable to freeze column and row headings when moving anywhere across the sheet.

freeze rows gif

Contributor: Sonia Keswani

I am a B.Com(Hons.) graduate from South City College (Morning) and have been working at Leveraged Growth as a Finance Intern for the past 1 month. I am pursuing CFA and aspire to be a Financial Analyst in future.
IMG-20191023-WA0003_2
Share
0

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'