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.
How to create and save a new spreadsheet
Customizing the Toolbar (Ribbon) & Quick Access Toolbar
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
Font, number, & percent formatting
Currency formatting
Conditional formatting
Sorting row data & filtering content based on specific criteria
Sum (addition), Subtraction, Multiplication, & Division
Average, Minimum, Maximum, & Count
Date formulas: Today, Now, & Networkdays
Informational formulas: Cell & Sheets
AutoSum & the Function Library
Pivot Tables
Data Validation
The VLOOKUP formula
IF and NESTED IF formulas
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)
Navigation and Printing
Formatting, Sorting, & Filtering
Excel® Formula Fundamentals
Learn more about the functionality of:
