2019 Microsoft Excel For Beginners + 30 Formulas & Features The Step-By-Step Guide - Brossura

Benton, C.J.

Brossura

ISBN 10: 1674846800 ISBN 13: 9781674846804

Casa editrice: Independently published, 2019

Riassunto

Learn Excel By Example - Updated for Office version 2019!

Ready to learn Microsoft Excel®, but not sure where to start? This user-friendly and practical resource is tailored for beginners and will teach you how to navigate Excel and 30 of the most frequently used formulas & features. Each example includes step-by-step instructions with screenshots.

Organized into 3 step-by-step sections, allowing you to grow your knowledge of Excel at your own pace:

Exercise Files Included!

Section 1 - Basic Commands

Opening Excel and the Toolbar (Ribbon)

Customizing the Ribbon & Quick Access Toolbar

How to create and save a new spreadsheet

The segments of a worksheet

Printing tips

How to add Headers & Footers to your spreadsheets

Section 2 - Toolbar (Ribbon) Navigation

Review of the various Copy, Cut, & Paste options

Font & number formatting, including currency examples for the British Pound £ and Euro €

Inserting charts

Conditional formatting

Sorting & filtering data based on specific criteria

Protecting workbooks & worksheets

Section 3 - Formulas

Sum (addition), Subtraction, Multiplication, & Division

Average, Min, & Max

Today, Now, & NetWorkDays

Text, Len, Trim, Concat, & Mid

The VLOOKUP with 2 step-by-step examples

IF, SumIF, AverageIF, CountIF, & CountIFS

How to create and format a Pivot Table

And More!

Dettagli dell?edizione

• Editore: Independently published
• Data di pubblicazione: 2019
• ISBN 10: 1674846800
• ISBN 13: 9781674846804
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 158
• Contatto del produttore: non disponibile