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

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

#evba #kingexcel #etipfree #eama