top of page
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,996 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....
75 views0 comments
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...
36 views0 comments
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...
42 views0 comments
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...
17 views0 comments
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...
15 views0 comments
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...
18 views0 comments
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....
22 views0 comments
bottom of page