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!
Author(s): Benton, C.J.
Year: 2019
Language: English
Pages: 160
Tags: Begginners guide to Learn Excel By Example - Updated for Office version 2019!
CHAPTER 1
An Introduction To Microsoft® Excel®
Training Segments
List of Formulas & Features Detailed In This Book
Files For Exercises
SECTION ~ ONE - Basic Commands
CHAPTER 2
Navigating Excel®
Starting Excel®
Creating a New Spreadsheet (Step-By-Step Example)
Workbook
Worksheet
Cell
Toolbar (Ribbon)
Quick Access Toolbar
Customizing The Ribbon & Quick Access Toolbar
Ribbon & Workbook Display Options
Name Box
Formula Bar
SECTION ~ TWO - Toolbar (Ribbon) Navigation
CHAPTER 3
The Excel® Ribbon (Menu Descriptions)
File
Home
Insert
Formulas
Data
Review
View
Help & Tell me what you want to do
SECTION ~ THREE 25 Excel Step-By-Step Formula Examples
CHAPTER 4
Basic Formulas
Is there a difference between a Formula and a Function?
SUM (Addition)
SUBTRACTION
MULTIPLICATION
DIVISION
CHAPTER 5
Calculating Averages
AVERAGE Function
CHAPTER 6
Determining the Minimum & Maximum number in a list
MAX
MIN
CHAPTER 7
Basic Date & Time Functions
TODAY & NOW (functions)
NETWORKDAYS
CHAPTER 8
Text Functions Part 1 – TEXT, PROPER, UPPER, & LOWER
TEXT
PROPER
UPPER
LOWER
CHAPTER 9
Text Functions Part 2 – LEN, TRIM, CONCAT, & MID
LEN
TRIM
CONCAT
MID
CHAPTER 10
Rounding Numbers
ROUND
CHAPTER 11
The Vlookup Function
VLOOKUP
The 4 - Parts of a VLOOKUP (Explained)
CHAPTER 12
Logic tests – cell evaluation
IF
IFERROR
CHAPTER 13
Conditional Functions
SumIF
AverageIF
CountIFS
CountIF
CHAPTER 14
PivotTables – (Step-By-Step Example)
What Are The Main Parts Of A PivotTable?
Step-By-Step Example: How To Create A Basic PivotTable
Why Do The ‘∑ Values’ Fields sometimes default to Count instead of Sum?
How To Drill-Down PivotTable Data
CHAPTER 15
Microsoft® Excel® Shortcuts
Thank you!
More Books Available From This Author
Questions / Feedback
