This book is tailored for beginners and will guide you through the basic functionality of Microsoft(r) Excel(r). Providing a review of the most commonly used toolbar commands.Read more...
This book is tailored for beginners and will guide you through the basic functionality of Microsoft(r) Excel(r). 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(r) formulas and keyboard shortcuts.
Opening Excel(r) 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(r) 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