Excel School

ঈদ মোবারাক
তাকাবাল্লাহু মিন্না ওয়া মিন কুম

Pivot Table Shortcut

Excel Custom Number Format Millions and Thousands
Many times, you might have large numbers in an Excel report and it is hard to decipher and read the number at one glace.
The best way is to show the numbers in Thousands or Millions .
Say, a number 45,200,000 will be displayed as 45.2 Million.

By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions.

"Excel Your Self with MS Excel" at ICAB Ctg

Open Excel Files in Bulk

Rather than open files one by one when you have multiple files you need to handle, there is a handy way to open them all with one click. Select the files you would like to open then press the Enter key on the keyboard, all files will open simultaneously.

Excel Hacks That Can Make Anyone An Excel Expert

1. One Click to Select All
You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, as shown in the screenshot below, all data will be selected in seconds.

That would be me, I'm Balayet Hossan, Founder of My Online Excel School.
I have been working with Excel since 2006 and teaching since 2010. I'm excited to be able to share what I have learned with you.
Back when I started using Excel I was lucky, in that you weren't expected to know how to use it! As you'd know, that's not the case these days.