Overview
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 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
This item is Non-Returnable
Customers Also Bought
Details
- ISBN-13: 9781674846804
- ISBN-10: 1674846800
- Publisher: Independently Published
- Publish Date: December 2019
- Dimensions: 9.21 x 6.14 x 0.34 inches
- Shipping Weight: 0.51 pounds
- Page Count: 160
Related Categories
