Microsoft Excel Start Here The Beginners Guide

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 ToolbarNavigation 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 & worksheetsFormatting, Sorting, & Filtering
• Font, number, & percent formatting
• Currency formatting
• Conditional formatting
• Sorting row data & filtering content based on specific criteriaExcel® Formula Fundamentals
• Sum (addition), Subtraction, Multiplication, & Division
• Average, Minimum, Maximum, & Count
• Date formulas: Today, Now, & Networkdays
• Informational formulas: Cell & Sheets
• AutoSum & the Function LibraryLearn more about the functionality of:
• Pivot Tables
• Data Validation
• The VLOOKUP formula
• IF and NESTED IF formulas

Table of Contents

CHAPTER 1 An Introduction To Microsoft® Excel® 11
CHAPTER 2 Opening Microsoft® Excel® & The Toolbar
CHAPTER 3 The Home Tab
CHAPTER 4 The Insert Tab
CHAPTER 5 The Page Layout Tab
CHAPTER 6 The Data Tab
CHAPTER 7 The Review Tab
CHAPTER 8 The View Tab
CHAPTER 9 Basic Formulas (Part 1)
CHAPTER 10 Basic Formulas (Part 2)
CHAPTER 11 Date Formulas
CHAPTER 12 Informational Formulas
CHAPTER 13 The Formulas Tab
CHAPTER 14 Next Steps – An Introduction To Excel® Intermediate Formulas & Features
CHAPTER 15 Microsoft® Excel® Shortcuts