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, &NetworkdaysInformational formulas: Cell&SheetsAutoSum & the Function Library Learn more about the functionality of:
Pivot Tables Data Validation The VLOOKUP formula IF and NESTED IF formulas
