• 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
Microsoft Excel Start Here The Beginners Guide

Microsoft Excel Start Here The Beginners Guide

Paperback

Applications

ISBN10: 1522713379
ISBN13: 9781522713371
Publisher: St Paul Pr
Published: Dec 18 2015
Pages: 94
Weight: 0.32
Height: 0.19 Width: 6.14 Depth: 9.21
Language: English
Ready to learn more about Microsoft(R) Excel(R), but not sure where to start?

This book is tailored for beginners and will guide you through the basic functionality of Microsoft(R) Excel(R). Providing a review of the most commonly used toolbar commands. How to create a new spreadsheet, including formatting, saving, and printing. In addition to this, you'll learn the fundamental Excel(R) formulas and keyboard shortcuts.

Opening Excel(R) and the Toolbar (Ribbon)

  • How to create and save a new spreadsheet
  • Customizing the Toolbar (Ribbon) & Quick Access Toolbar

    Navigation and Printing

  • Copy, Cut, & Paste
  • How to print and adjust margin settings
  • How to add Header & Footers to your spreadsheets
  • Freeze panes and split screen
  • Protecting workbooks & worksheets

    Formatting, Sorting, & Filtering

  • Font, number, & percent formatting
  • Currency formatting
  • Conditional formatting
  • Sorting row data & filtering content based on specific criteria

    Excel(R) Formula Fundamentals

  • Sum (addition), Subtraction, Multiplication, & Division
  • Average, Minimum, Maximum, & Count
  • Date formulas: Today, Now, & Networkdays
  • Informational formulas: Cell & Sheets
  • AutoSum & the Function Library

    Learn more about the functionality of:

  • Pivot Tables
  • Data Validation
  • The VLOOKUP formula
  • IF and NESTED IF formulas
  • Also in

    Applications