MS Excel | Tech Aficionado

Harshal Srivastava

Jul 8, 20211 min read

Plot X-Y coordinates using Microsoft Excel

Stuck with X-Y coordinates and unable to plot it? Well, Tech Aficionado brings a stepwise pictorial guide on how to easily plot X-Y...

7,939 views0 comments

Harshal Srivastava

Apr 20, 20211 min read

Make your Microsoft Cells speak for you(Speak Cells)

Want to know how to match your hard copy with a soft copy without even looking at it? Here's the article you might be interested to read....

Harshal Srivastava

Apr 13, 20211 min read

Referencing in Microsoft Excel

There are three types of referencing in Microsoft Excel Relative Reference- Basically when you write a formula, say "=B2+A2" in cell C2...

Harshal Srivastava

Apr 9, 20211 min read

Sum a column in Microsoft Excel

1. Open your excel worksheet containing the data or enter the desired data, say, the budget of an individual. 2. Go to the cell wherever...

Harshal Srivastava

Apr 7, 20211 min read

Change Date Format in Excel

Open your workbook consisting of the date. 2. Select all the cells consisting of Date by pressing "Ctrl" and left click. 3. Right-click...

Harshal Srivastava

Apr 5, 20211 min read

Highlight/GoTo cells that contain formulas

Open the worksheet you want to search formulas in. 2. Press "Ctrl+G". 3. Click on "Special" and then select "Formulas". 4. Hit OK. Cells...

Harshal Srivastava

Apr 4, 20211 min read

Customize Tabs In Ribbon( MS Excel)

1. Open your workbook. 2. Click on "File" on the ribbon. 3. Then click on the "Options" menu at the very bottom of the menu bar. 4. Click...

Harshal Srivastava

Apr 3, 20211 min read

Separate First name and last name in excel(Text to column)

1.Write down the data, say the full name of the people. 2. Press "Ctrl+Shift+Down Arrow Key". 3. Click on "DATA" at the top menu ribbon....