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

By C.J. Benton

Learn Excel By Example - Updated for Office version 2019

Ready to learn Microsoft Excel(R), 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 CommandsOpening Excel and the Toolbar (Ribbon)Customizing the Ribbon & Quick Access ToolbarHow to create and save a new spreadsheet The segments of a worksheetPrinting tipsHow to add Headers & Footers to your spreadsheets

Section 2 - Toolbar (Ribbon) Navigation Review of the various Copy, Cut, & Paste optionsFont & number formatting, including currency examples for the British Pound and Euro Inserting chartsConditional formattingSorting & filtering data based on specific criteriaProtecting workbooks & worksheets

Section 3 - FormulasSum (addition), Subtraction, Multiplication, & DivisionAverage, Min, & MaxToday, Now, & NetWorkDaysText, Len, Trim, Concat, & MidThe VLOOKUP with 2 step-by-step examplesIF, SumIF, AverageIF, CountIF, & CountIFS How to create and format a Pivot TableAnd More

• Format: Paperback
• Language: English
• ISBN: 1674846800
• ISBN13: 9781674846804
• Release Date: December 2019
• Publisher: Independently Published
• Length: 160 Pages
• Weight: 0.51 lbs.
• Dimensions: 0.3" x 6.1" x 9.2"