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

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

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

$16.02 USD
$16.02 USD
Sale Sold out
Shipping calculated at checkout.

Shipping: $8.00 or FREE when you spend $100+

by C. J. Benton (Author)

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
    Number of Pages: 160
    Dimensions: 0.34 x 9.21 x 6.14 IN
    Publication Date: December 14, 2019
    • View full details