Microsoft Excel Start Here The Beginners Guide

ISBN-13: 9781522713371 / Angielski / Miękka / 2015 / 94 str.

C. J. Benton

Opis

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 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