This PDF will be accessible from your Account page after purchase and requires PDF reading software, such as Acrobat® Reader®.
The eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Register your product to gain access to bonus material or receive a coupon.
Advance your everyday proficiency with Excel!
And earn the credential that proves it!
Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers:
Sharpen the skills measured by these objectives:
1 Manage worksheets and workbooks
Objective 1.1: Import data into workbooks
Objective 1.2: Navigate within workbooks
Objective 1.3: Format worksheets and workbooks
Objective 1.4: Customize options and views
Objective 1.5: Configure content for collaboration
2 Manage data cells and ranges
Objective 2.1: Manipulate data in worksheets
Objective 2.2: Format cells and ranges
Objective 2.3: Define and reference named ranges
Objective 2.4: Summarize data visually
3 Manage tables and table data
Objective 3.1: Create and format tables
Objective 3.2: Modify tables
Objective 3.3: Filter and sort table data
4 Perform operations by using formulas and functions
Objective 4.1: Insert references in formulas
Objective 4.2: Calculate and transform data by using functions
Objective 4.3: Format and modify text by using functions
5 Manage charts
Objective 5.1: Create charts
Objective 5.2: Modify charts
Objective 5.3: Format charts