• Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide

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

Paperback

Applications

ISBN10: 1674846800
ISBN13: 9781674846804
Publisher: Independently Published
Published: Dec 14 2019
Pages: 160
Weight: 0.51
Height: 0.34 Width: 6.14 Depth: 9.21
Language: English
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!
  • Also in

    Applications