Excel Satish

24/03/2024

Save and Share it

Follow Excel Satish for more

💼 Unlock your Excel potential with these tips and tricks.

DM for credit

03/02/2024

Shortcut Series Of Alt + W keys

99% EXCEL USERS don't know

Share And Like it

📊Freelancer ( ) sharing excel tricks & tips

💼 Unlock your Excel potential with these tips and tricks.

🚝Follow for more videos

📳 Join our telegram channel link in bio

📨💳DM for Story Promotion, Paid Promotion & collaboration

📩Email : [email protected]

30/12/2023

16/12/2023

Follow the Excel 2 Data (Freelancer) channel on

WhatsApp:

04/12/2023

Just Whatsapp for any query
https://wa.me/message/4NBUMSXUWHDQE1

25/11/2023

Big shout out to those who’ve recently engaged with me!

Dar Jumadi, Deepak Wadhwa, Sunny Khan Kan, Sandra Roberts, Uttam Kumar, Amin Khan, Answer Ranratu, Anis Tirkey, Christos Kolatsos, Peeyush Kumar Gautam, Deepika Samariya, Ely Butt, Harivadan Naginbhai, Pabitra Mondal, Upender Gupta, Samsul Hoque, Satyajit Das, Yabka Al Amal, Amadou Sarr, Aditya Kushwaha, Foreign Man, Jeremiah Baldicanas Gagabo-an, Asfak Siddiquie, Sk Sahid, Raju Kumar, RaNa Saif, Chandra Shekhar, Nheil Ruba, Chada Nor, Nayum Mia, Satyanand Kushvansh, Dubey Ji, Elochukwu Obiefuna, मनीष सिंह उज्जैन, Michael Bartholomew

23/11/2023

ICAI Exam Date Sheet Released for December 2023

BREAKING NEWS | ICAI EXAM | DATE SHEET RELEASED DECEMBER TO MARCH | 📚 ICAI Exams Preparation Guide | Tips, Tricks, and Strategies 📚Are you geari...

12/11/2023

Diwali symbolises the spiritual victory of good over bad with the victory of light over darkness. The festival witnesses homes, temples, shops and offices decorated with lights and diyas, friends and relatives sharing sweets, gifts and warm messages.

Happy Diwali Everyone

09/11/2023

ALT & CTRL Excel Keyboard Shortcuts: Display
Follow Satish Gupta for more posts

Alt or F10 = Turn key tips (Ribbon keyboard shortcuts)
Alt + W + F + F = Freeze Panes
Alt + W + I = Page Break Preview
Alt + W + L = Normal View
Alt + W + Q = Display the Zoom dialog box
Alt + W + VG = View/hide gridlines
Ctrl + ` = Toggle between (1) displaying cell values and (2) displaying formulas in worksheet
Ctrl + 6 = Alternate between hiding and showing object(s)
Ctrl + F1 = Expand or collapse the Ribbon
Ctrl + F10 = Maximize/restore current selected workbook window
Ctrl + Scroll Mouse Wheel = Zoom in/out
Ctrl + Shift + U = Toggle between expanding and collapsing the Formula Bar

04/11/2023

Why do we use Vlookup ?

Follow Satish Gupta for more posts

VLOOKUP, which stands for "Vertical Lookup" is a popular function in Microsoft Excel that is used to search for a specific value in a vertical column of data (typically in a table or range) and retrieve a corresponding value from a specified column.

It is often used for tasks such as data analysis, data validation, and data retrieval.

Here are some common reasons for using VLOOKUP in Excel:

Finding specific information: VLOOKUP helps you locate and extract information quickly from large datasets, such as product names, employee IDs, or prices.

Data validation: You can use VLOOKUP to validate data entries by checking if a value exists in a reference table or list. This can help reduce errors and ensure data accuracy.

Creating dynamic reports: VLOOKUP can be used to build dynamic reports by pulling in relevant data from different tables or sources based on specific criteria.

Reconciliation: It's useful for reconciling data from multiple sources by matching and retrieving corresponding values.

Combining data: VLOOKUP can combine data from multiple tables or worksheets based on a common identifier, making it easier to analyze information from different sources.

Automating tasks: You can use VLOOKUP within Excel formulas to automate calculations and data retrieval, reducing the need for manual data entry.

Inventory management: VLOOKUP can help track inventory levels, prices, and other information related to products in a database.

Customer and employee databases: It's often used to retrieve information about customers, employees, or other entities based on unique identifiers, such as customer IDs or employee codes.

The VLOOKUP function in Excel has the following syntax:

scss

Vlookup Formula:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value: The value you want to look up in the first column of the table_array.

table_array: The range of cells that contains the data you want to search. This range should include the column where the lookup_value will be matched and the column from which you want to retrieve the corresponding data.

col_index_num: The column number from which you want to return a value in the table_array. The first column is 1, the second is 2, and so on.

range_lookup (optional): This argument can be set to either TRUE (approximate match) or FALSE (exact match). TRUE is used when you want to find an approximate match, while FALSE is used for an exact match.

VLOOKUP can be a powerful tool for working with data in Excel, but it does have some limitations, such as requiring the lookup column to be on the leftmost side of the table_array and only handling one-dimensional searches.

For more advanced and flexible lookups, you can use functions like INDEX and MATCH or the newer XLOOKUP function available in recent Excel versions.

01/11/2023

Excel Formula Auditing:
Follow Satish Gupta for more posts

Trace Precedents: Alt + M, P to display arrows showing which cells are referred to in a formula.

Trace Dependents: Alt + M, D to display arrows showing which cells depend on the selected cell.


Evaluate Formula: Alt + M, V to step through a formula calculation.

01/11/2023

Excel offers numerous shortcuts and tricks to help you work more efficiently.
If you found this relevent for you please follow me for future posts
Here are some popular Excel shortcuts and tricks:

Copy and Paste:
Copy: Ctrl + C
Cut: Ctrl + X
Paste: Ctrl + V
Paste Special: Alt + E, S (for values), Alt + E, V (for values and number formats)
Navigation:
Move to the beginning of data: Ctrl + Home
Move to the end of data: Ctrl + End
Move between worksheets: Ctrl + Page Up or Ctrl + Page Down
AutoFill:
Fill down or right: Click and drag the fill handle (a small square in the lower-right corner of the selected cell).
Insert and Delete:
Insert row or column: Ctrl + Shift + + (plus key)
Delete row or column: Ctrl + - (minus key)
Format Painter: Copy the format of one cell and apply it to another by using the Format Painter button on the Home tab or by pressing Ctrl + Shift + C to copy and Ctrl + Shift + V to paste.
Quick Calculations:
Sum: Alt + = (in a cell below a column of numbers)
Average: Alt + Shift + = (in a cell below a column of numbers)
Autofilter: Alt + Down Arrow to quickly apply filters to your data.
Freeze Panes: Alt + W, F, F to freeze the top row or left column.
Group and Outline: Use data grouping for collapsible sections in large datasets. Data > Group (Alt + Shift + Left Arrow).
Quick Chart: Select data and press F11 to create a quick chart.
Conditional Formatting: Home > Conditional Formatting to highlight cells based on criteria.
Find and Replace: Ctrl + F to find and Ctrl + H to find and replace.
PivotTables: Alt + N, V to create a PivotTable from selected data.
Hyperlinks: Ctrl + K to insert or edit hyperlinks.
Quick Data Entry: Ctrl + Semicolon (;) to enter the current date, Ctrl + Shift + Semicolon (;) for the current time.
Comment: Shift + F2 to add or edit cell comments.
Split Text: Data > Text to Columns to split text into multiple cells.
Data Validation: Data > Data Validation to restrict data input.
Go To Special: Ctrl + G, Special to find and select cells with specific characteristics.
Quick Save: Ctrl + S to save your workbook.
These are just a few of the many Excel shortcuts and tricks available.

11/10/2023

Join us on whatsapp

https://whatsapp.com/channel/0029VaBNrPw72WTyF4rhn229

07/10/2023

Very important information 👇
Follow for more
Shortcut Keys System!!

CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
CTRL+Z. . . . . . . . . . . . . . . . . Undo
CTRL+B. . . . . . . . . . . . . . . . . Bold
CTRL+U. . . . . . . . . . . . . . . . . Underline
CTRL+I . . . . . . . . . . . . . . . . . Italic
F1 . . . . . . . . . . . . . . . . . . . . . . Help
F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
F6 . . . . . . . . . . . . . . . . . . . . . Shifts focus in Windows Explorer
F10 . . . . . . . . . . . . . . . . . . . . Activates menu bar options
ALT+TAB . . . . . . . . . . . . . . . . Cycles between open applications
ALT+F4 . . . . . . . . . . . . . . . . . Quit program, close current window
ALT+F6 . . . . . . . . . . . . . . . . . Switch between current program windows
ALT+ENTER. . . . . . . . . . . . . . Opens properties dialog
ALT+SPACE . . . . . . . . . . . . . . System menu for current window
ALT+¢ . . . . . . . . . . . . . . . . . . opens drop-down lists in dialog boxes
BACKSPACE . . . . . . . . . . . . . Switch to parent folder
CTRL+ESC . . . . . . . . . . . . . . Opens Start menu
CTRL+ALT+DEL . . . . . . . . . . Opens task manager, reboots the computer
CTRL+TAB . . . . . . . . . . . . . . Move through property tabs
CTRL+SHIFT+DRAG . . . . . . . Create shortcut (also right-click, drag)
CTRL+DRAG . . . . . . . . . . . . . Copy File
ESC . . . . . . . . . . . . . . . . . . . Cancel last function
SHIFT . . . . . . . . . . . . . . . . . . Press/hold SHIFT, insert CD-ROM to bypass auto-play
SHIFT+DRAG . . . . . . . . . . . . Move file
SHIFT+F10. . . . . . . . . . . . . . . Opens context menu (same as right-click)

27/08/2023

Excel shortcut from Ato Z

13/08/2023

Follow Satish Gupta for more tricks
Excel 2023 Shortcut Tricks

19/07/2023

Shout out to my newest followers! Excited to have you onboard!

Krishnakumar Calicut, Damian Hernan Cristante, Mohmed Omar Elsibaey, Niraj Kumar, Marilou Dela Cruz, Kashyap Nikumbh, Maureen Price D'Angelo, Krishna Prasad Acharya, Ram Kumar, Bharat Bhushan Vashishth, Murali Behera, Thami Mothakathi, Froilan Bote De Leon, Koskei Julius, Cindy E Zimmerman, Krix Anthony Hernaez, Abdul Wahab, Manoj Mishra, Anwar Khan, اكرم هايل عامري, Jenivie Gulayan Cañas, Vijayakumar Rathinam, Jinky Estangco, Dhiren Patel, Badreia Alnoman, رضوان خلف ابو رضوان, Touqeer Ahmed, Kamlesh Kapoor Suri, Ramesh Pimplekar, Muhammad Usman, Manish Srivastav, Kiran Parekh, Jyotiranjana Kara, Joko Siapudan, Amir Rana, Shibasis Sen, Joelouis Agnel, Talib Pathan, Hitesh Bhardwaj, بلو داون, SK Rajesh, حازم العابد, Raj Kumar Pal, Asaf Samad Asaf Samad, Cliff Shayo, Satish Karumuri, Hữu Trí Nguyễn, Rahul Kumar, Min Arka, Mdmusharraf Reza

19/07/2023

Shout out to my newest followers! Excited to have you onboard!

Thami Mothakathi, Anwar Khan, Jyotiranjana Kara, Joko Siapudan, Amir Rana, Shibasis Sen, Joelouis Agnel, Talib Pathan, Hitesh Bhardwaj, SK Rajesh, Asaf Samad Asaf Samad, Rahul Kumar, Mdmusharraf Reza, MD Nasiruddin Molla, Nampally Srinivas, Cosmos Ouko, Kenneth Ponce, Guru Prasad, Muhammad Aziz Malik, Ch Umair Umair, Paula Lear, Frank Imperial Jr., Chandru B H, Firose Khan, Brajesh Verma, عبدالله الركاني, Baghylakshmi Munnam, Alicia Huang, Michael Steward, Amir Farhan, Indranil Chowdhury, Rajeshbhai Abhesinh Khant, Rahul Mistry, Amani Amani, Abijah Fongong, Jihad Noyon, Rajesh Kumar, Farooq Shahzad, Mohsin Ali, Mahipal Kumar, M Jana, Mandeep Singh Singh, Ayden Leon, Annē Fuenteš, Ayan Das, Rae Gem, Muhammad Abdul Hamid, Jeff Cissie Sorensen, Alim Qureshi, Mahesh Dixit

20/05/2023

currency note will remain legal tender after 30th September too. RBI expects that 4 month time is enough for people to exchange notes with the banks. Most of the Rs 2000 notes that are in circulation will return to banks within the given time frame of 30th September.

12/05/2023

I've just reached 27K followers! Thank you for continuing support. I could never have made it without each one of you. 🙏🤗🎉