The world is filled with two kinds of people: a handful of people who are masters of Excel, and the millions of others who wish they were If you’ve mastered Microsoft Excel 2016, then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to businesses’ critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel. This is our most requested training course! If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are just getting started with Excel, let our Microsoft Certified Trainers, Barbara Evers and Christina Tankersley, walk you through the basics of what you need to know about Microsoft Excel 2016. Topics covered include: Navigating around Excel Creating and saving a workbook Using basic Office features including Undo, Redo, and Office clipboard The basics of functions and formulas Applying formatting Managing workbook properties Lesson Introduction Navigating the Interface Selecting Data Using Commands Creating a New Workbook Entering Cell Data Using AutoFill Using Flash Fill Using Excel Help Creating Formulas Inserting Functions Copying Formulas and Functions Using Absolute References Inserting and Deleting Cells Searching and Replacing Using Proofing and Researching Tools Applying Text Formats Applying Number Formats Customizing Number Formats Aligning Cell Contents Applying Cell Styles Applying Themes Iserting Hyperlinks Applying Conditional Formatting to Numbers Applying Conditional Formatting to Text and Dates Applying Comparative Analysis Formatting Using Templates Printing Workbooks Setting the Page Layout Inserting Page Breaks Configuring Headers and Footers, Part 1 Configuring Headers and Footers, Part 2 Managing Worksheets, Part 1 Managing Worksheets, Part Managing Worksheets, Part 2 Creating a Custom View Managing Worksheet Views Managing Workbook Views Managing Workbook Properties Customizing General Options Customizing the Ribbon Customizing the Quick Access Toolbar
