2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide (The Excel 2019 Step-By-Step Series, Band 1) - Softcover

Buch 1 von 3: The Excel 2019 Step-By-Step Series

Benton, C.J.

 
9781674846804: 2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide (The Excel 2019 Step-By-Step Series, Band 1)
Softcover
ISBN 10: 1674846800 ISBN 13: 9781674846804
Verlag: Independently published, 2019

Inhaltsangabe

Learn Excel By Example - Updated for Office version 2019!

Ready to learn Microsoft Excel®, 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!

    • Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

    Verlag
    Independently published
    Erscheinungsdatum
    2019
    Sprache
    Englisch
    ISBN 10 
    1674846800
    ISBN 13 
    9781674846804
    Einband
    Taschenbuch
    Anzahl der Seiten
    158
    Kontakt zum Hersteller
    Nicht verfügbar
    Verantwortliche Person
    Nicht verfügbar