Microsoft Excel Start Here the Beginners Guide

Download or read book Microsoft Excel Start Here the Beginners Guide written by C J Benton and published by . This book was released on 2015-12-18 with total page 94 pages. Available in PDF, EPUB and Kindle. Book excerpt: Ready to learn more about Microsoft(r) Excel(r), but not sure where to start? 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, including examples for the British Pound and Euro 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