Vamsi.Excel

Home
India
Rayagada
Vamsi.Excel

💹 Daily
💡 Boost Your with Excel
👨‍🎓 Microsoft Certified Trainer
(2)

30/09/2023

Unknown Excel Shortcuts

27/09/2023

Common Excel Shortcuts

26/09/2023

Useful Excel Shortcuts

25/09/2023

Keyboard Shortcut Keys for Selection

24/09/2023

Simple Keyboard Shortcuts in Excel

22/09/2023

Excel Number Format Shortcut keys

21/09/2023

Excel Function key Shortcuts

19/09/2023

Excel Shortcuts - Ctrl + A-Z Shortcuts

CTRL + A Select All
CTRL + B BOLD
CTRL + C Copy
CTRL + D Fill Down
CTRL + E Flash Fill
CTRL + F Find
CTRL + G Go To
CTRL + H Find and Replace
CTRL + I Italic
CTRL + J None
CTRL + K Insert Hyperlink
CTRL + L Insert Excel Table (Same as Ctrl + T)
CTRL + M None
CTRL + N New Workbook
CTRL + O Open
CTRL + P Print
CTRL + Q Quick Analysis
CTRL + R Fill Right
CTRL + S Save
CTRL + T Insert Excel Table (Same as Ctrl + L)
CTRL + U Underline
CTRL + V Paste
CTRL + W Close current workbook
CTRL + X Cut
CTRL + Y Redo (Repeat last action)
CTRL + Z Undo

30/08/2023

📊 Demystifying Excel's Powerful Counting Functions! 📊

If you've ever felt lost in the world of data analysis, fear not! 🚀 Excel offers a set of counting functions that can help you make sense of your data, whether you're dealing with numbers, text, or a combination of both. Let's dive into the world of COUNT, COUNTA, COUNTIF, COUNTIFS, and COUNTBLANK functions and unravel their magic. ✨

1. COUNT Function: 🧮
The COUNT function is your go-to for tallying numeric values within a range. It counts cells that contain numbers and ignores empty cells and cells with text. Syntax: =COUNT(range).

2. COUNTA Function: 📊
Need to count all non-blank cells, regardless of whether they contain numbers or text? That's where COUNTA shines. It includes text, numbers, and logical values. Syntax: =COUNTA(range).

3. COUNTIF Function: 🎯
Imagine you have a list of sales figures, and you want to know how many exceeded a certain threshold. COUNTIF comes to the rescue! It counts cells based on a single condition. Syntax: =COUNTIF(range, criteria).

4. COUNTIFS Function: 🎯🎯
Expanding on COUNTIF, COUNTIFS lets you count cells that meet multiple criteria. Say you want to know how many sales were made by a specific salesperson in a certain month. Syntax: =COUNTIFS(range1, criteria1, range2, criteria2, ...).

5. COUNTBLANK Function: 📝
Cleaning data often involves spotting gaps. COUNTBLANK helps by counting empty cells within a range, helping you gauge data completeness. Syntax: =COUNTBLANK(range).

🔍 Utilizing these functions can save you countless hours of manual counting and analysis. From financial data to project tracking, these functions empower you to derive insights efficiently. 💡

29/08/2023

The SUM Guide you need ever

1️⃣SUM
Add numbers together

👉Arguments
number1 - The first value to sum.
number2 - [optional] The second value to sum.
number3 - [optional] The third value to sum.

👉Syntax
=SUM(number1, [number2], [number3], ...)

2️⃣SUMIF
Sum cells in a range that meet criteria

👉Arguments
range - Range to apply criteria to.
criteria - Criteria to apply.
sum_range - [optional] Range to sum. If omitted, cells in range are summed.

👉Syntax
=SUMIF(range, criteria, [sum_range])

3️⃣SUMIFS
Sum cells in a range that meet criteria

👉Arguments
sum_range - The range to be summed.
range1 - The first range to evaulate.
criteria1 - The criteria to use on range1.
range2 - [optional] The second range to evaluate.
criteria2 - [optional] The criteria to use on range2.

👉Syntax
=SUMIFS(sum_range, range1, criteria1, [range2], [criteria2], ...)

4️⃣SUMPRODUCT
Multiply, then sum arrays

👉Arguments
array1 - The first array or range to multiply, then add.
array2 - [optional] The second array or range to multiply, then add.

👉Syntax
=SUMPRODUCT(array1, [array2], ...)

28/08/2023

The LOOKUP Guide

1️⃣LOOKUP
Look up a value in a one-column range

Arguments
lookup_value - The value to search for.
lookup_vector - The one-row, or one-column range to search.
result_vector - [optional] The one-row, or one-column range of results.

Syntax
=LOOKUP(lookup_value, lookup_vector, [result_vector])

2️⃣VLOOKUP
Lookup a value in a table by matching on the first column

Arguments
lookup_value - The value to look for in the first column of a table.
table_array - The table from which to retrieve a value.
column_index_num - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

Syntax
=VLOOKUP(lookup_value, table_array, column_index_num, [range_lookup])

3️⃣HLOOKUP
Look up a value in a table arranged horizontally

Arguments
lookup_value - The value to look up.
table_array - The table from which to retrieve data.
row_index - The row number from which to retrieve data.
range_lookup - [optional] A Boolean to indicate exact match or approximate match. Default = TRUE = approximate match.

Syntax
=HLOOKUP(lookup_value, table_array, row_index, [range_lookup])

4️⃣XLOOKUP
Lookup values in range or array

Arguments
lookup - The lookup value.
lookup_array - The array or range to search.
return_array - The array or range to return.
not_found - [optional] Value to return if no match found.
match_mode - [optional] 0 = exact match (default), -1 = exact match or next smallest, 1 = exact match or next larger, 2 = wildcard match.
search_mode - [optional] 1 = search from first (default), -1 = search from last, 2 = binary search ascending, -2 = binary search descending.

Syntax
=XLOOKUP(lookup, lookup_array, return_array, [not_found], [match_mode], [search_mode])

26/08/2023

Must know DATE & TIME Functions
1️⃣DATE
The Excel DATE function creates a valid date from individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.

Syntax
=DATE(year, month, day)

Example
=DATE(2010,6,1) // returns Jun 1, 2010

2️⃣YEAR
The Excel YEAR function returns the year component of a date as a 4-digit number.

Syntax
=YEAR(date)

Example
=YEAR("11-May-2019") // returns 2019

3️⃣MONTH
The Excel MONTH function extracts the month from a given date as number between 1 to 12.

Syntax
=MONTH(serial_number)

Example
=MONTH("11-May-2019") // returns 5

4️⃣DAY
The Excel DAY function returns the day of the month as a number between 1 to 31 from a given date.

Syntax
=DAY(date)

Example
=DAY(A1) // returns 15

5️⃣TIME
The Excel TIME function is a built-in function that allows you to create a time with individual hour, minute, and second components.

Syntax
=TIME(hour, minute, second)

Example
=TIME(8,30,0) // 8.5 hours

6️⃣HOUR
The Excel HOUR function returns the hour component of a time as a number between 0-23. For example, with a time of 9:30 AM, HOUR will return 9.
Syntax
=HOUR(serial_number)

Example
=HOUR("9:00 AM") // returns 9

7️⃣MINUTE
The Excel MINUTE function extracts the minute component of a time as a number between 0-59. For example, with a time of 9:45 AM, minute will return 45.

Syntax
=MINUTE(serial_number)

Example
=MINUTE("9:45 AM") // returns 45

8️⃣SECOND
The Excel SECOND function returns the second component of a time as a number between 0-59. For example, with a time of 9:10:15 AM, second will return 15.

Syntax
=SECOND(serial_number)

Example
=SECOND("10:45:17 AM") // returns 17

24/08/2023

New Functions & Its Uses

VSTACK
Combine ranges or arrays vertically

TOCOL
Transform array to single column

TEXTBEFORE
Extract text before delimiter

TEXTSPLIT
Split a text string with a delimiter

WRAPROWS
Wrap array into rows

TAKE
Get a subset of an array

EXPAND
Expand array by adding rows or columns

HSTACK
Combine ranges or arrays horizontally

TOROW
Transform array to single rowlly

TEXTAFTER
Extract text after delimiter

TEXTJOIN
Join text values with a delimiter

WRAPCOLS
Wrap array into columns

DROP
Remove portion of an array

IMAGE
To insert image from an URL

21/08/2023

Comment Function name to make a tutorial video on it

Excel 2023 new Functions
1. VSTACK & HSTACK
2. TEXTSPLIT, TEXTBEFORE & TEXTAFTER
3. IMAGE FUNCTION
4. TOCOL & TOROW
5. WRAPROWS & WRAPCOLS
6. TAKE, DROP & EXPAND

18/08/2023

Which version Excel do you have? Comment below 👇

16/08/2023

Do you know these functions

1. SUM, SUMIF, SUMIFS
2. LEN
3. TRIM
4. LEFT, MID, RIGHT
5. CONCATENATE
6. AVERAGE
7. COUNTA, COUNTIF, COUNTBLANK
8. IF
9. VLOOKUP, HLOOKUP
10. INDEX-MATCH
11. XLOOKUP

Do you want me to make a tutorial video on these?

15/08/2023

Day 11 of the Excel Shortcut Series

Alt+Shift+Right Arrow Group

Alt+Shift+Left Arrow Ungroup

Ctrl + Mouse Wheel Up Zoom In Ctrl + Mouse Wheel Down Zoom Out

Ctrl + Shift + F4 Find Previous Match (After Initial Find) Ctrl + F4 Find Next Match (After Initial Find)

Drag Move Cells Or Ranges Ctrl + Drag Copy Cells Or Ranges

Ctrl + Shift + O Select Cells Containing Comments

Alt + Q To Quickly Jump To Search

Alt + C Clear Slicer Filter

Alt + 'Open Modify Cell Style Dialog Box

14/08/2023

Day 10 of the Excel Shortcut Series

Ctrl + F1 To Expand Or Collapse The Ribbon
Ctrl + F2 To Open The Print Preview Window
Alt + F8 Macro Dialog Box
Ctrl + F3 Name Manager
Ctrl + F4 Close Applicaton
Shift + F10 Opens Context Menu
Shift + F2 To Add Or Edit A Cell Comment
Shift + F3 To Open The Insert Function Dialog Box
Ctrl + Alt + F9 To Force Calculate All Workbooks
Ctrl + Shift + F3 To Create Names From Values In Rows And Columns
Alt + Down Arrow Display Autocomplete List
Ctrl + Shift + * Select Current Region Around Active Cell
Ctrl + Shift + U Expand Or Collapse The Formula Bar
Ctrl + Shift + Enter Enter Array Formula
Shift + Click Expand Selection

11/08/2023

Day 7 of the Excel Shortcut Series

Ctrl + ; Current Date
Ctrl + Shift + ; Current Time
Ctrl + Alt + + To Zoom In Inside A Workbook
Ctrl + Alt + - To Zoom Out Inside A Workbook
Ctrl + Tab Switch Through Opened Workbooks
Ctrl + Shift + L Activate Filter
Alt + Down Arrow To Activate Filters For Cells
Ctrl + D Duplicate Object
Ctrl + Click Select Non-Adjacent Worksheets
Ctrl + Alt + V Paste Special
Ctrl + [ Select Direct Precedents
Ctrl + Shift + { Select All Precedents
Ctrl + ] Select Direct Dependents
Ctrl + Shift + } Select All Dependents

09/08/2023

Day 6 of Excel Shortcuts Series

SHORTCUT KEY FOR SELECTION

Shift + Left Arrow Select Left Cells
Shift + Right Arrow Select Right Cells
Shift + Up Arrow Select Upwards
Shift + Down Arrow Select Downwards
Ctrl + Shift + Left Arrow Select till First Column
Ctrl + Shift + Right Arrow Select till Right Column
Ctrl + Shift + Up Arrow Select till First Row
Ctrl + Shift + Down Arrow Select till Last Row
Shift + Space Select A Row
Ctrl + Space Select A Column
Ctrl + Shift + Space Select All
Ctrl + A Select All
Shift + Page Up Extend Selection Up One Screen
Shift + Page Down Extend Selection Down One Screen
Alt + Shift + Page Down Extend Selection Right One Screen
Alt + Shift + Page Up Extend Selection Left One Screen
Shift + Home Extend Selection To Start Of Row(S)
Ctrl + Shift + Home Extend Selection To First Cell In Worksheet
Ctrl + Shift + End Extend Selection To Last Cell In Worksheet

08/08/2023

Day 5 of Excel Shortcut Series

SHORTCUT KEYS FOR NAVIGATION

Ctrl + Left Arrow Go To First Column
Ctrl + Right Arrow Go To Last Column
Ctrl + Up Arrow Go To First Row
Ctrl + Down Arrow Go To Lastrow
Ctrl + Page Up Move To Previous Sheet
Ctrl + Page Down Move To Next Sheet
Ctrl + Home Go To First Cell
Ctrl + End Go To Last Cell
Page Up Scroll Up
Page Down Scroll Down
Alt + Page Up Scroll Left
Alt + Page Down Scroll Right

07/08/2023

04/10 Excel Shortcuts - Number Formatting

CTRL+SHIFT+-- General Format

CTRL+SHIFT+! Number Format CTRL + SHIFT + @-Time Format

CTRL+SHIFT+ # Date Format

CTRL + SHIFT + $ Currency Format

CTRL+SHIFT+% - Percentage Format

CTRL+SHIFT+ A- Scientific Format

CTRL+SHIFT+ &- Add Outline Border CTRL+SHIFT+! - Remove Border

04/08/2023

I've received 1,000 reactions to my posts in the past 30 days. Thanks for your support. 🙏🤗🎉

Address

Rayagada

Telephone

+917735809884

Website

https://zaap.bio/vamsi

Alerts

Be the first to know and let us send you an email when Vamsi.Excel posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Vamsi.Excel:

Videos

Use this code to create Macro Code 👇 Sub CreateTOC() 'Created by @vamsi.excel 'This VBA code will create/refresh a table of contents. 'Just click it... and get it done!! ' ' Dim lngIdxRow As Long Dim lngSrNo As Long Dim objWS As Worksheet Dim objTOCSht As Worksheet 'In following code, change name of the index sheet within the double quotes with your index sheet Set objTOCSht = ThisWorkbook.Sheets("Contents") lngIdxRow = 2 lngSrNo = 1 'Follwing code will create a Table of Contents With objTOCSht 'Clear/Initialize the existing TOC .Range("A" & lngIdxRow & ":B" & lngIdxRow + 255).Clear .Range("A" & lngIdxRow).Value = "Sr#" .Range("B" & lngIdxRow).Value = "Worksheet Name" lngIdxRow = lngIdxRow + 1 For Each objWS In ThisWorkbook.Sheets If objWS.Name <> .Name Then .Cells(lngIdxRow, 1).Value = lngSrNo .Hyperlinks.Add Cells(lngIdxRow, 2), "", _ "'" & objWS.Name & "'!A1", , objWS.Name lngSrNo = lngSrNo + 1 lngIdxRow = lngIdxRow + 1 End If Next objWS 'Following code will format the TOC table With .Range("A2:B" & lngIdxRow - 1) .Font.Size = 12 .Font.Bold = True .IndentLevel = 1 .VerticalAlignment = xlCenter .Borders(xlEdgeLeft).LineStyle = xlContinuous .Borders(xlEdgeTop).LineStyle = xlContinuous .Borders(xlEdgeRight).LineStyle = xlContinuous .Borders(xlEdgeBottom).LineStyle = xlContinuous .Borders(xlInsideHorizontal).LineStyle = xlContinuous .Borders(xlInsideVertical).LineStyle = xlContinuous End With .Range("A2:A" & lngIdxRow - 1).HorizontalAlignment = xlCenter .Range("A1").Select End With End Sub #excelshortcutkeys #exceltipsandtricks #corporatehacks #advancedexcel #exceltutorial #worksmarternotharder #spreadsheets #students #excelisfun #excelautomation #exceltraining #excel #excelskills #vamsiexcel #vba #excelvba #excelmacros

=FILTER(A2:A21, NOT(COUNTIF(B2:B21, A2:A21))) 2. Find Uncommon data of list #2 using this 👇 =FILTER(B2:B21, NOT(COUNTIF(A2:A21, B2:B21))) 3. Combine both lists =VSTACK(C2#,D2#) #excelhacks #microsoft #exceltutorials #excelshortcutkeys #excelguru #microsoftexcel #excelisfun #excelskills #exceltips #workhacks #exceltricks #students #excel #corporatehacks #vamsiexcel

How to Highlight Cells? Formula =C7=$D$4 Follow @vamsi.excel for the next part #exceltutorial #excelshortcutkeys #students #exceltipsandtricks #excelskills #exceltraining #workhacks #microsoftexcel #excelshortcuts #excelhacks #excelfunctions #excelisfun #exceltips #vamsiexcel

Posted @withregram • @vamsi.excel 🚨 Low Stock Alert: Inventory Levels Running Thin 🚨 "In this step-by-step tutorial, I'll guide you through utilizing the powerful FILTER function in Excel to gain valuable insights into your inventory management. With a focus on identifying stocks with low quantities, we'll delve into the world of data manipulation to streamline your decision-making process. The FILTER function, a robust tool within Excel, enables us to efficiently extract specific data based on given criteria. By leveraging this function, we can swiftly pinpoint which stocks are currently experiencing low quantities, allowing us to take timely actions to replenish them and maintain a seamless supply chain. Through clear and concise explanations, I'll walk you through the process of setting up the FILTER function, establishing the appropriate criteria for identifying low stock items, and generating a dynamic list that updates in real-time as your inventory evolves. No more manual scanning or time-consuming sorting – this tutorial equips you with the skills to automate the identification of low stock items and allocate your resources wisely. Whether you're a seasoned Excel user or just beginning your journey with spreadsheets, this tutorial is designed to cater to all skill levels. By the end, you'll have the tools to enhance your inventory management efficiency, ensure items are always available when needed, and make data-driven decisions that keep your operations running smoothly. Let's dive into the world of data analysis and revolutionize the way you handle stock quantities! #worksmarternotharder #excelforbeginners #exceltutorial #corporatehacks #students #exceltips #excelformulas #exceltutorials #workhacks #excelguru #vamsiexcel #exceltraining

Create this awesome Deadline Alert using this trick to be reminded by your Excel when you see it #exceldashboard #student #excelshortcut #excelhacks #datavisualization #corporatehacks #excelshortcuts #excelfunctions #students #excelshortcutkeys #spreadsheets #exceltips #excelformulas #worksmarternotharder #vamsiexcel

The benefits of using VLOOKUP with multiple criteria include: 📌Sales: You can use VLOOKUP with multiple criteria to find all customers who have purchased a specific product within a certain timeframe. This information can then be used to target these customers with specific marketing campaigns. 📌Operations: You can use VLOOKUP with multiple criteria to find all inventory items that are below a certain stock level or that are due to expire within a certain timeframe. This information can then be used to ensure that you have enough stock on hand and that you are not wasting any inventory. 📌Finance: You can use VLOOKUP with multiple criteria to find all transactions that exceed a certain amount or that were made on a specific date. This information can then be used to identify potential fraud or to track your spending. Overall, VLOOKUP with multiple criteria is a very powerful and versatile tool that can be used to improve your efficiency and accuracy in a wide variety of tasks. #exceltips #Excel #exceltipsandtricks #excelshortcuts #excelfunctions #dataanalytics #dataanalysis #dataanalyst

👇Comment "YES" if you want me to make more videos like this Follow @vamsi.excel for more #exceltutorial #exceltricks #excelisfun #excelskills #excelshortcuts #exceltips #spreadsheets #corporatehacks #students #worksmarternotharder #vamsiexcel

Use this trick to find Uncommon Data Steps 1. Find Uncommon data of list #1 using this 👇 =FILTER(A2:A21, NOT(COUNTIF(B2:B21, A2:A21))) 2. Find Uncommon data of list #2 using this 👇 =FILTER(B2:B21, NOT(COUNTIF(A2:A21, B2:B21))) 3. Combine both lists =VSTACK(C2#,D2#) #excelhacks #microsoft #exceltutorials #excelshortcutkeys #excelguru #microsoftexcel #excelisfun #excelskills #exceltips #workhacks #exceltricks #students #excel #corporatehacks #vamsiexcel

Unlock the power of data manipulation with torow() and tocol() Excel functions! 📊 Easily extract values from ranges by converting rows and columns into single arrays. Simplify complex calculations and streamline your spreadsheet workflow like never before. #excel #excelfunctions #exceltraining #exceltutorial

Jumble Menu Tabs #excelfunctions #exceltipsandtricks #spreadsheets #excelforbeginners #worksmarternotharder #exceltutorial #workhacks #exceltricks #exceltraining #excelhacks #excelskills #advancedexcel #excelshortcut #student #exceldashboard #excelshortcutkeys #excelguru #excelshortcuts #students #datavisualization #microsoftexcel #exceltutorials #excel #vamsiexcel

Excel not Responding - Prank 😂 Steps 1. First open a new Excel workbook 2. Then take a screenshot of it 3. Now use that screenshot as Desktop Background 4. Now hide Desktop Icons #excelguru #office365 #excelskills #excelhacks #exceldashboard #excel #workhacks #advancedexcel #excelformulas #excelforbeginners

Day 11 of the Excel Shortcut Series Alt+Shift+Right Arrow Group Alt+Shift+Left Arrow Ungroup Ctrl + Mouse Wheel Up Zoom In Ctrl + Mouse Wheel Down Zoom Out Ctrl + Shift + F4 Find Previous Match (After Initial Find) Ctrl + F4 Find Next Match (After Initial Find) Drag Move Cells Or Ranges Ctrl + Drag Copy Cells Or Ranges Ctrl + Shift + O Select Cells Containing Comments Alt + Q To Quickly Jump To Search Alt + C Clear Slicer Filter Alt + 'Open Modify Cell Style Dialog Box #excelshortcut #excelskills #exceltipsandtricks #excel #excelshortcuts #excelguru #excelautomation #corporatehacks #excelshortcutkeys #exceltutorial #exceltutorials #excelforbeginners #office365 #spreadsheets

Day 7 of 21 Days 21 Excel Pranks Lock Horizontal Scrolling Steps 1. Select all visible columns except first column 2. Hide those columns 3. Now go to the next column 4. Now freeze that column 5. Unhide all columns #productivity #excel #training #excelfunctions #excelisfun #studentslife #excelshortcuts #funtime #officehumor

Day 6 of 21 Days 21 Excel Pranks Corrupt Formulas Steps 1. Go to File 2. Then Options 3. Now go to Formulas 4. Bow check the R1C1 Reference Style 5. Then click Ok #productivity #excel #training #officehumor #excelshortcuts #exceltips #exceltipsandtricks #exceltricks #exceltraining #excelfunctions #excelisfun #studentslife #exceltutorial #exceltutorials #funtime #prank #prankvideo #prankvideos

Day 5 of 21 Days 21 Excel Pranks Steps 1. Go to File 2. Go to Options 3. Click on Advanced 4. Scroll to Display section 5. Select No comments #prank #prankvideo #funtime #excelfunctions #excelisfun #studentslife #officehumor #productivity #Excel #training #exceltricks #exceltraining #exceltutorial #exceltips #exceltipsandtricks #exceltutorials #excelshortcuts

Day 4 of 21 Days 21 Excel Pranks Steps to Hide sheet 1. First right click on sheet name 2. Click View Code 3. Press Ctrl + R to view Project Explorer 4. Press F4 to view Properties Window 5. Now select sheet which you want to hide 6. Then go to Properties window 7. Now go to Visible property 8. Then select Very Hidden there #productivity #Excel #training #exceltraining#excelfunctions #excelisfun #funtime #officehumor #studentslife #excelshortcuts

Day 3 of 21 Days 21 Excel Pranks Hide Sheets & Scroll Bars Steps 1. Press Ctrl + A to Select All 2. Now press Merge & Center or use Alt + H + M + C 📌 Note - Change it back after having fun 😉 #funtimes #productivity #Excel #training #excelfunctions #excelisfun #studentslife #officehumor #exceltips #exceltipsandtricks #exceltricks #exceltraining #exceltutorial #excelshortcuts #prank #prankvideo #prankvideosfunny

Disable Fill Handle in Excel

Day 2 of 21 Days 21 Excel Pranks Disable Fill Handle Steps 1. Go to File 2. Go to Options 3. Click on Advanced 4. Uncheck Enable Fill Handle option Just remember to change it back before they freak out too much. 😉 #funtime #officehumor#studentslife #excelshortcuts #excelfunctions #excelisfun #exceltricks #microsoftexcel #vamsiexcel #productivity #exceltraining #exceltutorial

Day 1 of 21 Days 21 Excel Pranks Hide Sheets & Scroll Bars Steps 1. First click on File 2. Click on Options 3. Click on Advanced 4. Scroll to the Display section area 5. Then uncheck Sheet Tabs, Horizontal & Vertical Scroll Bars 📌 Note - Change it back after having fun 😉 #funtimes #productivity #Excel #training #excelfunctions #studentslife #officehumor #exceltips #exceltipsandtricks #exceltricks #exceltraining #exceltutorial #exceltutorials #excelshortcuts #prank #prankvideo #prankvideosfunny

😊Do you want a series of shortcuts like this Steps 1. Select Columns with headings that you want to calculate 2. Now Go to Formulas > Create Form Selection 3. Select Top Row for Heading 4. Now click OK 5. Now write your formula using your Heading Names #Excel #excelshortcutkeys #exceltraining #exceltips #exceltricks #exceltipsandtricks #student #corporate #excelshortcuts #worksmarternotharder #worksmarter

Do you want to know F1-F12 use case Then comment yes Ctrl+1 Format cells dialog box Ctrl+2 Bold Ctrl+3 Italic Ctrl+4 Underline Ctrl+5 Strikethrough Ctrl+6 Show/Hide objects Ctrl+7 Show/Hide Standard toolbar Ctrl+8 Toggle Outline symbols Ctrl+9 Hide rows Ctrl+0 Hide columns #excelshortcuts #dataanalysis #dataanalyst #dataanalytics #excelshortcutkeys #ExcelForBeginners #exceltraining #Excel #ExcelAutomation #excelskills #exceltutorial #corporatehack #spreadsheets

Create Data Bars using REPT #exceltipsandtricks #excelshortcuts #ExcelForBeginners #excelskills #ExcelCharts #chartanalysis #excelformulas #spreadsheet #spreadsheets #exceltips #ExcelGuru #dataanalyst #dataanalytics #dataanalysis