Limit this search to....

2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide
Contributor(s): Benton, C. J. (Author)
ISBN: 1674846800     ISBN-13: 9781674846804
Publisher: Independently Published
OUR PRICE:   $10.44  
Product Type: Paperback
Published: December 2019
Qty:
Additional Information
BISAC Categories:
- Computers | Desktop Applications - Spreadsheets
Physical Information: 0.34" H x 6.14" W x 9.21" (0.51 lbs) 160 pages
 
Descriptions, Reviews, Etc.
Publisher Description:
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