Online Library TheLib.net » Microsoft Excel Start Here: The Beginners Guide
cover of the book Microsoft Excel Start Here: The Beginners Guide

Ebook: Microsoft Excel Start Here: The Beginners Guide

Author: C.J. Benton

00
29.01.2024
0
0

Ready to learn more about Microsoft® Excel®, but not sure where to start?

This book is tailored for beginners and will guide you through the basic functionality of Microsoft® Excel®. 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® formulas and keyboard shortcuts.

Opening Excel® 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® 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
  • Download the book Microsoft Excel Start Here: The Beginners Guide for free or read online
    Read Download

    Continue reading on any device:
    QR code
    Last viewed books
    Related books
    Comments (0)
    reload, if the code cannot be seen