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