Microsoft Office Excel 2016: Part 1 Beginner Level

Excel formulas perform simple or complex mathematical computations in worksheets.

You can use formulas to perform tasks such as adding up a row or a column of numbers, multiplying sales figures by commission rates, and applying tax to sales. (Excel Formulas, The Formula Bar, Elements of Excel Formulas, Common Mathematical Operators, The Order of Operations, Reference Operators)

Learn how to use the massive set of built-in formulas. 

Learn how to use functions will save you time, effort, and possibly a few headaches down the road. (Functions, Basic Function Syntax, The Function Library Group, The Function Arguments Dialog Box, Graphical Cell and Range Reference Entry, The AutoSum Feature, Other Commonly Used Functions, The Formula AutoComplete Feature) 

By reusing your content, you can eliminate the hassle and reduce the likelihood of entering numerous errors in your workbooks. 

Excel provides you with a number of methods to reuse nearly any of your content, including formulas and functions, basically by using a variety of copy and paste techniques. (Formulas and the Cut, Copy, and Paste Commands, Drag-and-Drop Editing, The Paste Options, The Paste Special Options, Relative References, Absolute References, Mixed References, AutoFill and Formulas, Worksheet References, Excel Errors) 

At some point in your data entry process, the amount of text you need to display in a cell may be more than the cell can hold or you may have to add a row or a column right in the middle of existing data. (The Insert and Delete Options, Width and Height Adjustments, The Hide and Unhide Commands)

Learn how to easily find and correct multiple errors in a worksheet contain thousands of rows' and columns' worth of data. (The Find Command, The Replace Command, The Go To Dialog Box) 

Many times you’ll need to add a new column or row to your worksheet. 

Learn how to make sure all of your content is correct before sharing some data with others. 

Learn how proofing tools can help you make sure your worksheets are accurate and look professional. (The Spelling Dialog Box, The AutoCorrect Feature) 

Learn how to find and correct mistakes throughout your workbooks quickly and easily. 

The Insights task pane uses the active cell's contents as a search query to run in Microsoft's Bing® search engine. (The Insights Task Pane, Smart Lookup) 

Excel 2016 provides you with a number of options to help you create spreadsheets that are easy to read and interpret, and that allow the important information to stand out. 

Learn how to add a level of visual appeal, which can facilitate a greater level of engagement when you present your data to others. (Fonts, The Font Group, Live Preview, The Format Cells Dialog Box, The Colors Dialog Box, Hyperlinks, The Format Painter) 

By applying number formatting to your worksheet cells, you can control the display of items such as currency figures, dates and times, fractions, decimal places, and negative numbers. 

By understanding how the different number formats work, and by knowing how and when to apply them, you'll have the flexibility needed to work with and analyze all of your numeric data. (Number Formats, Number Format Categories, Custom Number Formats) 

Excel 2016 provides you with the ability to control where your content appears horizontally and vertically within your worksheet cells. 

Familiarizing yourself with the text alignment options available in Excel 2016 will allow you keeping your organizational data orderly, readable, and functional. (Alignment Options, The Indent Commands, The Wrap Text Command, Orientation Options, The Merge & Center Options) 

Learn how to apply a variety of formatting options to your worksheet cells, will not only save you time and effort, but can also help you consistently present data to your audiences in ways that are clear and instantly recognizable. (Cell Styles, Galleries, The Merge Styles Dialog Box, Themes, Custom Themes Considerations, Guidelines for Using Themes) 

Excel provides you with a number of options for quickly applying a variety of formatting options to your worksheet cells. This will help you consistently present data to your audiences in ways that are clear and instantly recognizable. 

An Excel template is a file that contains a number of preconfigured or pre-entered workbook elements, such as formatting, formulas, themes, and functions, that you can use to create and work with new workbooks. 

Using conditional formatting, Excel displays data that meets specified criteria with the specified formatting applied.

Conditional Formatting can transform enormous sets of seemingly random bits of data into useful organizational intelligence that you can use to make sound decisions. (Conditional Formatting, The Highlight Cells Rules, The Top/Bottom Rules, Data Bars) 

Excel enables you to leverage your existing workbooks to create similar new workbooks. By taking advantage of this functionality, you can save a lot of effort, and research that went into creating your workbooks for future use. (Templates, Templates and the Backstage View) 

Although most information these days exists digitally, you will likely still, on occasion, require hard copies of a document. But spreadsheets are not the same as most other documents. 

Learn to use the variety of printing options that can save your document recipients from having to sift through mounds of irrelevant data. (The Print Tab, The Print Settings, Page Orientation, Margins, Print Preview) 

Excel 2016 has many options for printing. Knowing what configurations are available and how to set them will allow you to create more visually helpful and appealing printouts. 

Learn what configurations are available and how to set them will allow you to create more visually helpful and appealing printouts. (The Page Setup Dialog Box, The Print Area, The Print Titles Command, Page Breaks, The Page Break Preview View) 

Learn hot to add print-only elements quick and easy through the use of headers and footers. 

There's plenty of other identifying information you might want to include on all or most of your printed pages—like numbering each individual page, your company's name, the date the workbook was printed, and so on. (Headers and Footers, The Page Layout View, The Header & Footer Tools Contextual Tab, Header and Footer Options) 

Learn how to manage the overall structure of your workbooks. 

Workbooks with just a few worksheets are fairly easy to manage without much effort. But what if you're developing a workbook with dozens of worksheets or more? (Tab Formatting Options, Methods of Repositioning Worksheets, Methods of Inserting and Deleting Worksheets, The Hide and Unhide Worksheets Options) 

Learn how to leverage Excel's different view options, to be able to easily review data from different sources simultaneously. 

With the View Options you can e.g. copy and paste data to the correct location without risking error, and save yourself time and headaches by avoiding scrolling through endless rows and columns of data. (Custom Views, The Add View Dialog Box, The Split Command, Syncronous Scrolling The Freeze Panes Options) 

Workbook Properties can help you search through numerous workbook files to find precisely the one you need. 

A workbook property is, quite simply, a bit of information about a workbook file. Learn how workbook properties can help you to manage numerous workbook files. (Workbook Properties, Workbook Properties in the Backstage View, The Properties Dialog Box, Custom Workbook Properties) 

Congratulations. You finished Excel 2016: Part 1 (Beginner Level). In the second part of this series, you will advance your foundational knowledge and begin taking advantage of some of the higher-level functionality.

Click here to go directly to the next level of Excel 2016: Part 2 (Intermediate):

https://www.udemy.com/office-excel-2016-intermediate/