Microsoft Excel Tutorial for Beginners 2022!
Microsoft Excel Tutorial for Beginners 2022!
Microsoft Excel Tutorial for Beginners 2022. Learn excel basics for beginners. This basic tutorial will show you how to navigate through Excel Spreadsheet, how to enter values and functions, and how to make your data look good. In this video I am using Excel 365, but is applicable to older versions of Excel (Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365). #excelforbegginers #exceltutorial #exceltips #excelformula
Check out All my Excel tips and tricks: • Excel Tips \u0026 Tricks
More Excel Tips and Tricks:
Excel Formulas: • Excel Functions
Excel Format: • Excel Format
Excel Shortcuts: • Excel Shortcuts
How to Import Data to Excel: • Import Data to Excel
Excel Pivot Table: • Excel Pivot Table
Spreadsheet with all my Tutorials and Practice Files FREE: https://docs.google.com/spreadsheets/…
Resources and Books: https://www.amazon.com/shop/excel_tip…
Excel Courses: https://www.the-excel-team.com/collec…
DISCLAIMER: This video and description contain affiliate links. If you click on one of them, I’ll receive a commission, which helps me to support my channel and create more tutorials. Thank you for your support!
Content
0.719 -> hi guys my name is Sarita today we're
4.02 -> going to do an introduction into
6.12 -> Microsoft Excel in this video I will
8.88 -> show you how to navigate around the
10.74 -> workbook where things are located and
13.5 -> how to input values functions and
16.02 -> formulas my goal is for you to work
19.38 -> comfortable in Excel and have fun with
21.539 -> it so let's Dive In
23.93 -> [Music]
26.22 -> here's my desktop simply click on the
28.92 -> Excel icon I'm using Excel 365. it's the
33 -> latest version of all features
35.34 -> now you can choose if you want to open
37.68 -> blank workbook or template
40.32 -> or you can open recently used Excel
42.96 -> documents
44.7 -> I'm going to open new workbook
47.46 -> this is a blank workbook on the top we
51.059 -> can see Excel ribbon tabs there are 10
54.059 -> tabs
55.739 -> file
58.379 -> home insert draw page layout formulas
62.94 -> data review View and help I suggest you
66.78 -> to go through each Tab and get familiar
69 -> with it
70.2 -> the Home tab is a default tab when Excel
73.32 -> is opened
74.76 -> before we start working in Excel I
77.4 -> recommend you to save your workbook
82.86 -> you can click on the icon or type Ctrl s
87.96 -> name your file
93 -> and save it to any location now let's
96.479 -> see how we can navigate around the
98.88 -> workbook you can move around the
101.159 -> workbook by scrolling down and up but
104.579 -> there's a quicker way you can use
106.799 -> keyboard instead you can use a single
109.68 -> Arrow key to move left
112.159 -> up down and right control home will
117.18 -> always bring you to A1
121.02 -> if you click on the cell you will select
123.479 -> it you will see a big border around the
126.36 -> cell
127.2 -> also you will see that column on the top
129.539 -> is highlighted and the row number is
132 -> highlighted as well
133.8 -> here column e and row number six are
137.34 -> highlighted
138.599 -> and over here in the name box shows cell
142.62 -> reference E6
145.2 -> if you want to select multiple cells you
148.02 -> can click and drag
149.7 -> or you can use a keyboard shift and
152.4 -> arrows
153.84 -> also you can highlight the whole column
156.84 -> by clicking on the column letter
159 -> and that picks up the whole column all
162.12 -> the way to the bottom
163.86 -> or you can select a single row by
166.8 -> clicking on the row number
169.019 -> now if you want to enter text into Excel
172.019 -> click on the cell and type what you need
174.42 -> to type I'm going to type sales report
178.86 -> if I click Escape data will disappear
182.22 -> if I click enter data will be accepted
185.459 -> and it will stay in the cell
188.4 -> also I can press the tab and data will
192.36 -> be entered and I will be moved to the
195.12 -> rate
196.92 -> now let's say I did this step and I want
199.62 -> to undo it you can simply click on this
202.319 -> Arrow to undo it like this
205.319 -> if you undone something and you want to
207.84 -> get it back you can click on this arrow
210.12 -> and data will come back
213.06 -> I'm going to add some more data to our
216 -> table this is going to be sales report I
219.78 -> will type sales reps names and their
222.36 -> sales for July 2022.
225.42 -> so let's type names
227.34 -> Sophia hit enter
230.099 -> Peter enter and Michael enter
234.84 -> and let's add their amount of sales
240.299 -> now let's say I need to add June to my
243.239 -> report
244.26 -> June needs to be before July
247.379 -> so in order to insert column to the left
250.68 -> of July I need to highlight July
254.76 -> column B right click and insert
259.859 -> and the new column appears to the left
262.5 -> of the column I had highlighted and that
266.04 -> will now become June or you can use a
269.46 -> shortcut Ctrl shift Plus
272.58 -> now I will put sales for June
277.34 -> we can do exactly the same thing for
280.56 -> rows let's say we need to add new person
283.5 -> between Peter and Sophia
285.96 -> select Rule Number Four
289.86 -> right click insert and row will appear
293.82 -> above highlighted row
296.16 -> or you can use a shortcut Ctrl shift
299.639 -> plus and now I can type here
308.4 -> if we need to delete column we need to
311.4 -> select it right click delete
315.32 -> or use shortcut Ctrl minus
319.32 -> same of the rows select right click
323.28 -> delete or shortcut Ctrl minus
327.74 -> now let's do something cool let's total
331.44 -> our sales
332.94 -> has a built-in function to help you to
335.699 -> calculate data so let's take a look how
338.759 -> to insert function to excel
341.639 -> click on the cell
343.68 -> type equal sign
346.56 -> and your function in my case it is some
350.699 -> function
352.38 -> select range
355.139 -> hit enter
357.96 -> and now I have a total amount of sales
360.78 -> for July
363 -> or you can choose a function in the
365.22 -> formula tab
367.02 -> click on formulas
369.3 -> in this selection you can choose any
371.82 -> formula you need
373.5 -> I'm going to click on all the sum
376.5 -> some my data is already selected hit
380.759 -> enter and I have my total now I want to
384.419 -> fix the table header I wanted to go
387.419 -> across the whole table you can easily
390.36 -> fix it by selecting cells
393.12 -> go home
394.8 -> click Merchant Center
397.44 -> also in this Home tab you can play
400.38 -> around with the font you can change
402.36 -> color make it bigger Etc
408.72 -> now let's make our table prettier first
412.02 -> we need to select table click home
415.44 -> format table and here we can choose any
418.68 -> format we like
421.44 -> and we're done we have a nice table with
424.199 -> values and functions
426.479 -> I hope now you have an understanding of
429.24 -> how Excel works and how you can easily
432.18 -> navigate around it
434.22 -> if you like my videos don't forget to
436.8 -> subscribe thank you
Source: https://www.youtube.com/watch?v=7Rap2aaCrys