Рет қаралды 22,291
Learn 51 Excel Formulas & Functions with example Step-by-Step in detail.
We covered the following topics:
00:00 Introduction to Excel Formulas
00:18 Press Ctrl + A (To Activate Function Argument Box in Excel)
01:08 Press Tab (To go next box in Function Argument Box in Excel)
01:18 Press Shift + Tab (To go the previous box in Function Argument Box in Excel)
01:37 Press Shift + F3 ( To Open Same Function Argument Box in Excel)
02:08 Press Ctrl + ` (To show Formulas Use in Background in Excel)
03:25 Press Ctrl + 1 (To Activate Format Cells in Excel)
03:59 Press Ctrl + ; (How to get Today's date in Excel)
04:18 Press Ctrl + Shift + 3 (To Change Date format in Excel)
04:47 Press Alt + H + K (To get comma style to excel shortcut key)
05:18 Press Alt + H + 9 (To Reduce Decimal in Excel)
05:47 Press Ctrl + F2 (How to get Print Preview in Excel)
05:57 Press Ctrl + F1 (How to Hides the Ribbon in Excel)
06:23 Press Alt + ; (How to select Visible Cells in Excel)
07:48 Press Ctrl + Pg Up/PgDn (To Toggle Between Sheets in Excel)
08:20 Press Ctrl + Arrow Keys (To Range Navigation in Excel)
09:11 Press Ctrl + Shift + Arrow Keys (How to Choose Data in Excel)
10:32 Press Ctrl + Backspace (Go to header with selection intact in Excel)
10:37 Press Ctrl + Spacebar (To choose an entire column in Excel)
10:40 Press Shift + Spacebar (To choose an entire row in Excel)
11:04 Press Ctrl + Minus (To Delete in Excel)
11:07 Press Ctrl + Plus (To Insert in Excel)
12:22 Press Ctrl + ` (To Show all Formulas in Excel)
13:09 Press Alt + E + S (to activate Paste Special in Excel)
15:25 Press Alt + I + C (To Insert Column in Excel)
15:53 Press Alt + I + R (To Insert Row in Excel)
16:15 Press Ctrl + Spacebar (To choose an entire Column in Excel)
16:25 Press Shift + Spacebar (To choose an entire row in Excel)
16:49 Press Shift + Ctrl + Plus (To Insert Column in Excel)
17:58 Press Ctrl + Minus (To delete the entire row in Excel)
21:00 Press Shift + Ctrl + End (To select active cell to last use cell in Excel)
23:46 How to use PMT Formula in Excel
25:46 How to use Goal Seek Function in Excel
27:55 How to Sort Data in Excel
30:52 Error while Inserting Row or Column in Excel
32:46 How to use ROUND Formula in Excel
34:14 How to use ROUNDUP Formula in Excel
35:01 How to use ROUNDDOWN Formula in Excel
36:07 How to use POWER Formula in Excel
39:59 How to use EOMONTH Formula in Excel
40:40 How to find 5th of the current month using EOMONTH Formula in Excel
41:13 How to find 1st of the current month using EOMONTH Formula in Excel
42:22 How to use Group Function in Excel
45:09 How to use Paste Special in Excel
51:12 How to use Remove Duplicate Function in Excel
57:08 How to use ISNUMBER Formula in Excel
57:47 How to use ISTEXT Formula in Excel
57:57 How to use ISERROR Formula in Excel
58:15 How to use ISNA Formula in Excel
58:32 How to use ISREF Formula in Excel
58:51 How to use ISFORMULA in Excel
01:00:25 How to use ISBLANK Formula in Excel
01:00:37 How to use LEN Formula in Excel
01:01:41 How to use Pivot Table in Excel
01:02:01 How to Insert Data in Pivot Table
01:02:29 How to Format Data in Pivot Table
01:02:41 How to add Percentage in Pivot Table
01:03:23 How to use Group Function in Pivot Table
01:05:34 How to use TEXT Formula in Excel
01:07:17 How to use Spark Line Function in Excel
01:07:55 How to use Consolidate 2 Dimensions in Excel
01:12:02 How to use TEXT to Column Function in Excel
01:16:05 How to Data Clean in Excel
01:19:50 IF Logical Statement Parameter in Excel
01:21:28 How to use IF Logical Formula in Excel
01:26:16 How to use Trace Precedents in Excel
01:26:43 How to use Trace Dependents in Excel
01:29:35 How to use VLOOKUP Formula in Excel
01:37:25 Difference between Vlookup vs. Hlookup in Excel
01:38:37 How to use Hlookup in Excel
01:40:40 How to use INDIRECT Formula in Excel
01:45:12 How to use MATCH Formula in Excel
01:49:22 How to use IF SUM Formula in Excel
01:50:59 How to use SUM INDIRECT Formula in Excel
01:56:29 How to use IF AND Formula in Excel
01:58:55 How to use VLOOKUP with MATCH Formula in Excel
02:04:29 How to Protect Formula in Excel
02:09:16 How to Unprotect the Excel Sheets
02:18:38 Press Ctrl + E (To use Flash Fill in Excel)
02:19:43 Press Ctrl + H (To Open Find and Replace in Excel)
02:22:01 How to use Value Function in Excel
02:24:14 How to use Conditional Formula in Excel
02:25:02 How to Insert Slicer in Excel
02:25:43 Press Fn + F11 (To Create Chart in Excel)
51 Excel Formulas & Functions for BEGINNERS | Excel Course
#Excel #excelformulas #excelfunctions
Keep Yourself Updated. Follow Us Now!!!
Like us on / yodalearning
Tweet us on / yodalearning
Follow our boards at / yodalearning