top of page


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...
Harshal Srivastava
Jul 8, 20211 min read
8,187 views
0 comments


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 20, 20211 min read
75 views
0 comments

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 13, 20211 min read
38 views
0 comments

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 9, 20211 min read
42 views
0 comments

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 7, 20211 min read
18 views
0 comments

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 5, 20211 min read
15 views
0 comments

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 4, 20211 min read
21 views
0 comments

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....
Harshal Srivastava
Apr 3, 20211 min read
22 views
0 comments
bottom of page