Excel 2019 - Complete Beginner to Advanced Course

Let’s get started with excel, hope you are looking forward to this as Excel is a valuable skill to have.

Excel Start Screen is divided into two panels; 1) Left panel and 2) Right panel.

The rectangular grid of rows and columns described in Excel Spreadsheets is only one part of the Excel user interface. Surrounding the worksheet window are several command interfaces, each of which allows you to receive information about, or apply functions to, the data on the worksheet.

The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed.

Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows you to quickly find, understand, and use commands for completing a certain task. The ribbon in Excel is made up of four basic components: tabs, groups, dialog launchers, and command buttons.

A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template.

When you share a workbook from Excel, you're actually giving others access to the exact same file. This lets you and the people you share with edit the same workbook without having to keep track of multiple versions. In order to share a workbook, it must first be saved to your OneDrive.

Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel. You can choose to create a new workbook - either with a blank workbook or a predesigned template or open an existing workbook.

The keys provide some interesting shortcuts for common computer functions that can be useful tools in everyday computing. The keys are frequently used in combination with other keys such as the CTRL key, the ALT key, and the SHIFT key.

Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column—in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).

Whenever you're working with a spreadsheet, it's a good idea to use appropriate number formats for your data. Number formats tell your spreadsheet exactly what type of data you're using, like percentages (%), currency ($), times, dates, and so on.

The dates in Excel are actually stored as numbers, and then formatted to display the date. The default date format for US dates is “m/d/yyyy” (1/27/2016). The dates are referred to as serial numbers in Excel.

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.

Excel is an amazing tool for analysing data. ... To change the order of your data, you'll want to sort it.

Relative references change when a formula is copied to another cell.

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Absolute references, on the other hand, remain constant no matter where they are copied.

The order in which Excel performs operations in formulas · Calculation order Formulas calculate values in a specific order. · Operator precedence in Excel formulas.

A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

The Microsoft Excel SUM function adds all numbers in a range of cells and returns the result. The SUM function is a built-in function. The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

Two of the more useful yet simple functions that Microsoft Excel offers are 'MIN' and 'MAX'. These two functions find the smallest and largest value in an array. It could be an array of constants (literal values) or an array of cells (range of cells).

The Microsoft Excel AVERAGE function returns the average (arithmetic mean) of the numbers provided. As a worksheet function, the AVERAGE function can be entered as part of a formula in a cell of a worksheet.

There are two very similar functions in Excel: COUNT() and COUNTA(). The difference between them is that COUNT only counts cells containing numbers but COUNTA counts all cells that aren't empty. Think of it as “Count Anything”.

When you move or copy a cell, Excel moves or copies the cell, including formulas and their resulting values, cell formats, and comments. You can move cells in Excel by drag and dropping or using the Cut and Paste commands.

Inserting and deleting entire rows and columns in a worksheet is very similar to inserting new cells into a range - or deleting cells from the same range.

To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.

Hide or unhide columns in your spreadsheet to show just the data that you need to see or print.

Regardless of the method you choose to rename a worksheet, Excel highlights the name on the worksheet tab and allows you to type a new name. To enter a new name, just start typing.

To delete worksheets in Excel, select the worksheet name tabs of the sheet or the sheets to delete.

Learn how to move an entire worksheet from one Excel workbook to another, or create a duplicate.

Format Cells: - Excel cell format option is used for changing the appearance of number without any changes in number. We can change font, protect the file, etc. To formatting the cells there are five tabs in Format Cells.

Percentages are calculated by using the equation amount / total = percentage. For example, if a cell contains the formula =10/100, the result of that calculation is 0.1. If you then format 0.1 as a percentage, the number will be correctly displayed as 10%.

Best practice on spreadsheet accessibility advises against the use of Merged Cells. You might also find when you merge cells in Excel, some of your formula might not give you the value you expected. This is because merging cells loses the integrity of columns and rows.

Quickly format a cell by choosing a cell style. You can also create your own cell style in Excel. Quickly format a range of cells by choosing a table style.

Conditional formatting in Excel enables you to highlight cells with a certain colour, depending on the cell's value.

You can easily add a wide variety of shapes to your Microsoft Excel worksheets, including squares, circles, stars, arrows, smiley faces, lines, equation shapes, and callouts.

Create a SmartArt graphic to make a visual representation of your information quickly and easily. You can choose from among many different layouts, to effectively communicate your message or ideas.

In word processing, print preview refers to formatting a document for the printer, but then displaying it on the display screen instead of printing it. Print preview is more commonly called preview or previewing.

If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page.

You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table. You can also print a workbook to a file instead of to a printer.

A template is a predesigned spreadsheet you can use to create new spreadsheets with the same formatting and predefined formulas. With templates, you don't need to know how to do the math, or even how to write formulas—these are already integrated into the spreadsheet.

To create a new workbook using a template · Click Sample templates to choose a built-in template.

A custom template can make this go a lot faster. Template files are more or less the same as standard Excel files, but with formatting and boilerplate content already set.

Let's wrap up Excel Beginner