2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide

Learn Excel By Example - Updated for Office version 2019! Ready to learn Microsoft Excel®, but not sure where to start? This user-friendly and practical resource is tailored for beginners and will teach you how to navigate Excel and 30 of the most frequently used formulas & features. Each example includes step-by-step instructions with screenshots. Organized into 3 step-by-step sections, allowing you to grow your knowledge of Excel at your own pace: Exercise Files Included! Section 1 - Basic Commands Opening Excel and the Toolbar (Ribbon) Customizing the Ribbon & Quick Access Toolbar How to create and save a new spreadsheet The segments of a worksheet Printing tips How to add Headers & Footers to your spreadsheets Section 2 - Toolbar (Ribbon) Navigation Review of the various Copy, Cut, & Paste options Font & number formatting, including currency examples for the British Pound £ and Euro € Inserting charts Conditional formatting Sorting & filtering data based on specific criteria Protecting workbooks & worksheets Section 3 - Formulas Sum (addition), Subtraction, Multiplication, & Division Average, Min, & Max Today, Now, & NetWorkDays Text, Len, Trim, Concat, & Mid The VLOOKUP with 2 step-by-step examples IF, SumIF, AverageIF, CountIF, & CountIFS How to create and format a Pivot Table And More! CHAPTER 1 An Introduction To Microsoft® Excel® Training Segments List of Formulas & Features Detailed In This Book Files For Exercises SECTION ~ ONE - Basic Commands CHAPTER 2 Navigating Excel® Starting Excel® Creating a New Spreadsheet (Step-By-Step Example) Workbook Worksheet Cell Toolbar (Ribbon) Quick Access Toolbar Customizing The Ribbon & Quick Access Toolbar Ribbon & Workbook Display Options Name Box Formula Bar SECTION ~ TWO - Toolbar (Ribbon) Navigation CHAPTER 3 The Excel® Ribbon (Menu Descriptions) File Home Insert Formulas Data Review View Help & Tell me what you want to do SECTION ~ THREE 25 Excel Step-By-Step Formula Examples CHAPTER 4 Basic Formulas Is there a difference between a Formula and a Function? SUM (Addition) SUBTRACTION MULTIPLICATION DIVISION CHAPTER 5 Calculating Averages AVERAGE Function CHAPTER 6 Determining the Minimum & Maximum number in a list MAX MIN CHAPTER 7 Basic Date & Time Functions TODAY & NOW (functions) NETWORKDAYS CHAPTER 8 Text Functions Part 1 – TEXT, PROPER, UPPER, & LOWER TEXT PROPER UPPER LOWER CHAPTER 9 Text Functions Part 2 – LEN, TRIM, CONCAT, & MID LEN TRIM CONCAT MID CHAPTER 10 Rounding Numbers ROUND CHAPTER 11 The Vlookup Function VLOOKUP The 4 - Parts of a VLOOKUP (Explained) CHAPTER 12 Logic tests – cell evaluation IF IFERROR CHAPTER 13 Conditional Functions SumIF AverageIF CountIFS CountIF CHAPTER 14 PivotTables – (Step-By-Step Example) What Are The Main Parts Of A PivotTable? Step-By-Step Example: How To Create A Basic PivotTable Why Do The ‘∑ Values’ Fields sometimes default to Count instead of Sum? How To Drill-Down PivotTable Data CHAPTER 15 Microsoft® Excel® Shortcuts Thank you! More Books Available From This Author Questions / Feedback