Excel in 1 Hour, Excel Course, Excel Basic, Basic Excel, Guide to Excel, Excel Tutorial, Learn Exce

Learn Excel in just 1 hour. Make sure you learn Excel before your interview and add that in your Resume.

Excel Basics Tutorial - The Beginner's Guide to Excel. In this step-by-step tutorial, learn many of the beginners skills & shortcuts that you'll need in order to be able to use Excel effectively.

Detailed video has been made by experienced tutor / teacher so you can understand things in a better way.

If you have any questions or doubts please feel free to ask and I will revert
Microsoft Excel is a part of Microsoft Office.

In next video I will show how to make basic VBA Macro

00:00 Introduction / Start
01:05 Layout - Top Menu Description - Tabs, Ribbon, Groups, Home, Insert, Page Layout, Formula, Data, View, etc.
01:48 Components of excel file - Sheet, worksheet, workbook
01:59 Add and Delete Sheets. Key board Short cut to delete sheets
02:36 Introduction to Columns and Rows and Cells.
02:51 See how cell address is defined
03:34 Range of cells
04:01 Entering /Inputting data in excel - Directly or through Formula Bar - Data stored in cells
05:00 Re-sizing columns
05:22 Navigating in cells down, up, right, left. Enter, Tab, Shift Enter, Shift Tab
06:00 Selecting table using shortcut CTRL A or Control A
06:25 Bold, Italic, Underline along with keyboard shortcuts to apply and remove formatting
06:58 Format number. Different ways of formatting the numbers. Introduction to Launch Button
08:04 Center alignment / Centre Alignment
08:12 Different way of editing data in cell. Difference between being on the cell and being inside the cell
09:09 Font type, size, shortcuts on ribbon
09:53 Font color / colour formatting
10:13 Using Format Painter more than 1 time
11:00 Wrap Text
11:35 Middle Align
12:01 Selecting columns and rows and then Adding Deleting column and rows using key board
13:39 Merge and Center
14:24 Border , all borders, single border, draw border, thick border, color border
15:32 Undo and Redo along with their shortcuts
16:01 Filter, keyboard shortcut to filter, Apply / Remove filter,
17:40 How to learn short cuts yourself by pressing ALT
18:58 Applying number filter to check greater than or less.
19:38 Applying more than 1 filter condition or greater than or less than
20:33 Color filtering, No Fill or filter by colors
21:05 Text filter. Contains, begins with, etc. Using more than 1 filter condition
22:04 Sort. Selecting correct data before sorting with example
26:00 Sorting on more than 1 column. Add level for sort
26:59 Insert Delete Comment. Show comment on mouse over / hover
27:50 Formula starts with equal = sign. Formula inside the cell but outside the calculated value is visible
28:53 Mathematical operators multiply, divide, add, subtract, plus, minus
29:43 Concept of math BODMAS i.e. Bracket Operator Division Multiplication Addition Subtraction
30:23 Using brackets in formulas
30:58 Different ways to copy or drag formula to other cells
32:08 Paste special values to replace the formula
32:58 Control D or Control R shortcut to copy cells down or on right cells
33:18 Upper Case, Lower Case, Proper Case
34:16 Sum and different ways of adding cells along with short cut
35:19 Freeze columns or rows or both columns and rows together. Including keyboard shortcuts
37:19 Length of characters or text in cell. LEN
37:46 Average, Max, Min to find the Average or maximum or minimum in range of cells
38:34 ROUND, ROUNDUP, ROUNDDOWN along with decimal place
40:30 Date formatting
41:49 SUM, SUMIF, SUMIFS to sum based on 1 or more than 1 criteria.
45:33 COUNT, COUNTIF, COUNTIFS
47:03 Left and Right formula to get specific number of characters from a cell / string
48:00 Combine 2 (two) cells, concatenate or use & formula
49:38 IF formula – Checks if condition is met it returns 1 value if not met it returns another value
52:56 VLOOKUP formula with concepts cleared. Static and Dynamic cell concept using $ sign
59:45 PIVOT Table
01:03:52 Bar Graph / Chart, Line Chart, Legend, Heading, Gridlines, Formatting Graphs, Data Labels
01:04:40 Line Chart / Graph, Formatting Graphs, Data Labels
01:06:06 PIE chart / Graph

#Excelin1hour #Excel #ExcelTutorial #MicrosoftExcel #ExcelForBeginners #ExcelinExcel

Excel for Beginners Tutorial - Level 2 & Level 3 to follow soon

Microsoft Excel - MS Excel, Best Excel Course, Excel Master, best Excel tutor, Best Excel, Learn Excel quickly, Beginners Tutorial, Excel Tips And Tricks 2019, Excel shortcuts, Every Excel User Should Know, Excel Sekhe. Learn Excel in 1 hour, Excel in Excel, Seekhe Excel 1 ghante mein, Learn Quick Excel, Learn Excel Quickly, Best Excel Tricks and Tips, Best Excel course, Excel at its best, All you need to know about excel, Excel before interview, How to Microsoft Excel, How to learn excel, quick excel course, best excel course, learn excel fast,

Excel in Excel, Microsoft Excel, MS Excel, Best Excel Course, Excel Master, Best Excel Tutor, Beginners Tutorial, Excel Tips And Tricks 2019, Excel Basics, Basic Excel, Excel in Excel,