Librería Portfolio

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Microsoft Office Specialist (MOS) exam, this all-in-one study guide features:


Full, objective-by-objective exam coverage
Easy-to-follow procedures and illustrations to review essential skills
Hands-on practice tasks to apply what you've learned; files included
Online pre-test to assess your readiness
Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office-and earn the credential that proves it!

Exam 77-420: Microsoft Excel 2013
Chapter 1 : Create and Manage Workbooks and Worksheets
1.1 Create workbooks and worksheets
1.2 Navigate through worksheets and workbooks
1.3 Format worksheets and workbooks
1.4 Customize options and views for worksheets and workbooks
1.5 Configure worksheets and workbooks to print or save
Objective review
Chapter 2 : Manage Cells and Ranges
2.1 Insert data in cells and ranges
2.2 Format cells and ranges
2.3 Order and group cells and ranges
Objective review
Chapter 3 : Manage Tables
3.1 Create tables
3.2 Modify tables
3.3 Filter and sort tables
Objective review
Chapter 4 : Apply Formulas and Functions
4.1 Utilize cell ranges and references in formulas and functions
4.2 Summarize data by using functions
4.3 Utilize conditional logic in functions
4.4 Format and modify text by using functions
Objective review
Chapter 5 : Create Charts and Objects
5.1 Create charts
5.2 Format charts
5.3 Insert and format objects
Objective review
Appendix : About the Author