Siirry suoraan sisältöön
2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide
Tallenna

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

Kirjailija:
pokkari, 2019
englanti
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
  • Kirjailija
    C J Benton
    ISBN
    9781674846804
    Kieli
    englanti
    Paino
    231 grammaa
    Julkaisupäivä
    14.12.2019
    Sivumäärä
    160