Benton C J 2019 Microsoft Excel For Beginners 30 Formulas And Features The Step By Step Guide 2019

Benton C J 2019 Microsoft Excel For Beginners 30 Formulas And Features The Step By Step Guide 2019 | 26.29 MB
English | 163 Pages

Title: 2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide
Author: Benton, C.J.
Year: 2019​

Description:

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!

DOWNLOAD: