Microsoft Excel 2016 - Full Tutorial for Beginners [COMPLETE in 13 MINUTES!]*

Aug 14, 2023

Microsoft Excel 2016 - Full Tutorial for Beginners [COMPLETE in 13 MINUTES!]*

[VOICE + TEXT] Thanks for 1700 amazing LIKES ♥! Get into a new Way of Learning Microsoft Excel 2016. Excel 2016 tutorial for beginners, getting started, basics.
Full Guide here: http://bit.ly/microsoftoffice2016
Enable SUBTITLES if you have troubles at understanding the accent. Leave feedback if you can!

Welcome to The Skills Factory™! A new brilliant Latin teacher will guide you through the most important softwares available. Leave a comment to make tutorial requests! Subscribe to start learning anything! ♥ Muah!

Content

8.23 -> Hello, welcome to this video! Let's see how to start quickly and easily

14.23 -> with Microsoft Excel 2016!

18.23 -> Leave us comments to improve our next guides in the future!

23.5 -> Excel 2016 is a software used to collect, calculate, save data and

31 -> represent it properly through tables, charts and graphs. This is quite

37 -> great if you need to manage and collect data. Let's see everything you need

43 -> to know to start using Excel.

46.5 -> When you open Excel, you need to start a new Excel file, also called

52.5 -> Workbook. Here you can choose different templates, each focused on

58 -> different purposes, just choose the one you like.

62.5 -> If you need to start from zero, just click on Blank Workbook. This appears

69 -> like a huge endless table, with rows, indicated by numbers, and columns,

76.5 -> indicated through letters. Letters and numbers locate each single cell. You

82 -> can check the selected cell through the small box on the extreme left.

88.5 -> Each of these cells can contain either numeric values or strings in letters.

95 -> Just double-click on a cell and type inside for its content.

101 -> If you need to collect a great amount of data, you may need to use the

105.5 -> Excel workbook to create databases.

109 -> Pick the columns and the rows you prefer, and start collecting data. Type

115 -> inside the cells to write titles to columns and rows, and type the numeric

121 -> values inside the respective cells. In case the cell size is not enough, it

128 -> may go over other cells nearby. In this case, simply enlarge its column by

135.5 -> clicking and dragging it externally.

139 -> Observe the default allignment inside the cell. If the content is collapsed

146 -> on the right, Excel recognizes it as a numeric value; if it is on the left,

153 -> it is recognized as a string, so something that must be 'read' and not

159 -> something to 'calculate with'.

161.5 -> To edit a cell, just double-click on it and type again. On top, in the Home

168 -> section, adjust the font type, style, font and color. This will affect the

175 -> whole cell content, either as string or numeric value.

181 -> While you manage your database, you will often move data from one place to

186 -> another. To cut or copy data, just select the cell interested, right-click

193 -> and go to Cut or Copy. Such cell will have a dashed contour as a reminder.

199.5 -> To paste data, just select another cell, right-click and go to Paste. You

207 -> can cut, copy and paste more cells at the same time, just click and drag to

214 -> select all the ones you need. Mind that, when you paste, all data will be

220.5 -> pasted starting from the white cell.

225 -> To cut, copy and paste whole rows or columns, just select those by clicking

232 -> on their numbers or letters. In this case your pointer becomes a

239 -> black arrow.

241 -> In case you want to remove data, right-click on selected cells or

246.5 -> rows/columns and go to Delete.... If you ever mistake while working, use

252.5 -> CTRL+Z to undo.

255.5 -> When you select one or more cells, you can notice a small black node in a

260.5 -> corner. If you drag it, you will copy data on other cells following the

266.5 -> same array, increasing the number. If you drag against your selection, you

272.5 -> will delete data instead.

276.5 -> In case you need to adjust advanced properties and settings related to

281.5 -> cells and their content, just right-click on the selected cells and go to

287 -> Format Cells...

289 -> One of the most powerful tools inside Excel is the possibility to make fast

295 -> calculations with your data by using formulas or Functions.

301 -> For example, let's suppose to sum the content of two values inside cells.

307.5 -> If you type inside one cell the equals sign, and then you select a cell,

314 -> this will appear with its name and color inside the cell selected. Then, to

320 -> sum, simply type the plus sign, and select the second cell to add its value.

327 -> If you press Enter key, the result will show up in the cell. You can make

333.5 -> longer sums by adding new cells with more plus signs. You can also subtract

342 -> by using the minus sign, multiply using the asterisk, and divide by using

348.5 -> the slash symbol. Mind to use just cells with numeric content, otherwise

357 -> the calculation is not done of course.

362 -> The main cell will also save its function and will refresh live the result

367 -> whenever any cell taken in the formula has its value changed. You can check

374 -> the function applied anytime by checking the Function bar on top. You can

380 -> also use this one to type and apply your formulas.

385.5 -> There are lots of advanced functions available in Excel. If you type a

390 -> letter, you can use your Up and Down Arrow keys to browse through the

395 -> different functions available. Hover on these to have hints about them.

401 -> To select a function, just double-click on it. Excel will suggest you how

408 -> to compose and complete the function with its punctuation and its arguments,

413.5 -> represented in bold. As arguments you can select single cells, multiple

420 -> cells or a full array of a row or column. Arrays are always indicated by a

426.5 -> double dot symbol. Use Enter key to complete and calculate the result of the

434 -> function.

435 -> You can also compose functions by going to Formulas above, choosing the

440.5 -> kind and then its arguments.

444.5 -> In case you need, you can also add comments to data. Just right-click on a

450 -> cell and go to Insert Comment. A cell corner will be colored in red,

456 -> showing the comment when you hover on it. You can also insert Pictures and

462 -> shapes going to Insert section on top.

466.5 -> It's very important to import data inside Excel. You can do this in

472 -> different ways, just go to Data on top. You can import from Microsoft

478 -> Access, or directly from the Web. If data comes from non-Office softwares,

485.5 -> you can import from standard text files, like .txt and .csv. Just browse

493 -> for the interested file, and go to Import. The new dialog box guides you at

499 -> importing the file correctly, just check the preview below, and carefully

504 -> tune the settings.

506 -> When you are done, go to Finish. Data will be imported starting from the

512 -> selected cell you have.

516 -> Excel is also able to make tables and charts very useful to show off data.

522.5 -> If you select a complete set of cells, the Quick Analysis icon appears in

528 -> the bottom right corner. With this, you can do many different things with

534 -> just one click.

536 -> Inside Formatting and Sparklines you can add graph representations to give

541.5 -> a quick impression on the data distribution. Hover on the options to check

547 -> a very good preview on your cells.

549.5 -> Under Totals, Excel creates a table that ends with a last row used for

556 -> simple basic calculations.

559 -> Under Tables, you can create fast tables starting from your selected cells.

566 -> Double-click on cells to adjust titles and values, and, through Design

572.5 -> section on top, adjust the table properties, like color, background

578 -> and style.

580 -> You can also expand the table on other cells, just click and drag from the

585 -> bottom right corner. To remove, remember to select, right-click and go

591.5 -> to Delete.

593.5 -> An advanced table is the PivotTable, check it out when you get practice!

599.5 -> With Excel you can also create Charts to make graphic representations of

605 -> your data. You can do this from Quick Analysis, under Charts or under

612 -> Insert section in Charts. If you go to See All Charts, under All Charts,

619.5 -> choose your favorite template on the left. This Chart can be edited

625.5 -> completely. You can move it in your workbook or any of its parts inside

632.5 -> simply by clicking and dragging. If you double-click on the chart, a dialog

637.5 -> box opens on the right, in order to edit any property, such as chart style

643 -> and colors, filling, contour, and size. On top, under Design, you can change

651.5 -> the basic chart template and the basic layout, and, under Format, you can

659.5 -> change the text style and add shapes to make the chart more comprehensible.

667 -> Each chart is composed by pieces of text and images called elements, that

673 -> you can move and scale as you like. Select one and edit its properties on

679 -> the right or on top. To edit cell values and titles, you need to edit the

686 -> original cells instead. The chart will refresh automatically.

692 -> On the right, you have other important options. With Chart Elements, you

697.5 -> can show or hide text elements; Chart Styles to change the template; and

705 -> Chart Filter to show or hide chart elements you like.

711 -> When finishing your work, save and export it! Just go to File and

716 -> then to Save As... and save is as .xslx if you want to open and edit

723.5 -> it later.

725 -> If you want to export your data instead, you have different possible ways.

730.5 -> If you want to show its tables and graphs in order to print your work, you

736 -> have to save it as .pdf. Go to File and then to Export, and choose

742 -> Create PDF.

745 -> If you need to export your database instead, you need to choose text

749.5 -> formats, like .txt or .csv. In File and in Export, go to Change File Type

759 -> and choose any text format under Other File Types. Then go to Save As. Mind

767 -> that these kinds of files do not save charts or other graphic options, but

772.5 -> just strings, numeric values and cells placement.

777.5 -> Thanks for watching this video! Check out our channel for more videos for

782.5 -> Microsoft Office 2016!

Source: https://www.youtube.com/watch?v=HacWD9HSww0