This media is not supported in your browser
VIEW IN TELEGRAM
SEARCHABLE π Dropdowns in Excel #shorts
This media is not supported in your browser
VIEW IN TELEGRAM
Delete Empty Rows with these Excel Shortcuts #shorts
Media is too big
VIEW IN TELEGRAM
Excel LOOKUP Function Only PROS Use (simple to complex examples)
This media is not supported in your browser
VIEW IN TELEGRAM
Quick Tips for Excel for the Web #shorts
Media is too big
VIEW IN TELEGRAM
Properly Handling Date Grouping in Excel Pivot Tables (Change Grouping, Get All dates)
This media is not supported in your browser
VIEW IN TELEGRAM
How to Freeze βοΈ Top Row and First Column in Excel when Scrolling #shorts
π4β€1
Media is too big
VIEW IN TELEGRAM
Excel VSTACK π - Quickly Combine Data from Multiple Sheets (Regional Director vs VSTACK)
Media is too big
VIEW IN TELEGRAM
How to Get your Own Data Types πΌ in the Excel Menu (Intern vs manager vs Power BI)
β€1
This media is not supported in your browser
VIEW IN TELEGRAM
2 Simple Ways to Remove Duplicates | Create List of Unique Values in Excel #shorts
π2
Media is too big
VIEW IN TELEGRAM
Bulk Combine PDF files to Excel without losing formatting & NO 3rd party software
Media is too big
VIEW IN TELEGRAM
How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)
Media is too big
VIEW IN TELEGRAM
Advance Excel π₯Full Course 2022 | Microsoft Excel Course | Microsoft Excel Tutorial | Simplilearn
β€4π3
π¬ππππ π»ππππ π οΈ
π3β€1
This media is not supported in your browser
VIEW IN TELEGRAM
How to Create a Dynamic Numbered List in Excel #shorts
π5π₯1
This media is not supported in your browser
VIEW IN TELEGRAM
NEW! Enter zeros before a number in Excel and keep the leading zeros #shortcuts
π2π₯1
This media is not supported in your browser
VIEW IN TELEGRAM
How to Assign Letter Grades in Excel #shorts (forget IF function)
π5β€1π₯1
Media is too big
VIEW IN TELEGRAM
Noob vs Pro | Excel LOOKUP Values with two spreadsheets
π5π₯2β€1
Media is too big
VIEW IN TELEGRAM
NEW! Convert Picture to Data in Excel DESKTOP - Fail or Pass?
β€6π1
SHORTCUT KEYS:-
F2 Edit the selected cell.
F5 Go to a specific cell. e.g. C6
F7 Checks the spellings
F11 Create chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert new worksheet.
Shift + F3 Opens the Insert Function window.
Shift + F5 Opens Find and Replace dialog box with find tab.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + P Bring up the Print dialog box to begin printing.
Ctrl + Z Undo the last action.
Ctrl + F9 Minimize current workbook.
Ctrl + F10 Maximize currently selected workbook.
Ctrl + F6 Switch between open workbooks/windows.
Ctrl + Page Up Move to the previous sheet between Excel worksheets in the same Excel document.
Ctrl + P Bring up the Print dialog box to begin printing.
Ctrl + Z Undo the last action.
Ctrl + F9 Minimize current workbook.
Ctrl + F10 Maximize currently selected workbook.
Ctrl + F6 Switch between open workbooks/windows.
Ctrl + Page Up Move to the previous sheet between Excel worksheets in the same Excel document.
Ctrl + Page Down Move to the next sheet between Excel worksheets in the same Excel document.
Ctrl + Tab Move between two or more open Excel files.
Alt + = Create a formula to sum all of the above cells.
Shift + Home Go to the first cell in the current row.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Space Select entire column.
Shift + Space Select entire row.
β€8π2
Ctrl + N : Create a new workbook.
Ctrl + O : Open an existing workbook.
Ctrl + S : Save the current workbook.
Ctrl + W : Close the current workbook.
Ctrl + C : Copy selected cells.
Ctrl + X : Cut selected cells.
Ctrl + V Paste copied or cut data.
Ctrl + D Copy content from the cell above.
Ctrl + R Copy content from the cell to the left.
Ctrl + Home Move to the beginning of the worksheet.
Ctrl + End Move to the last cell with data.
Ctrl + Arrow Key Navigate to the edge of the data region.
Alt + Enter Insert a line break within a cell.
Ctrl + Shift + "+" Insert a new row or column.
Ctrl + "-" Delete the selected row or column.
Ctrl + ` :Toggle between showing formulas and results.
F4 : Repeat the last action or lock cell references.
Ctrl + T : Create a table from selected data.
β€9π7