| Audience | This course is designed for individuals interested in learning the skills necessary to analyze and present data in Microsoft® Office Excel® 2013 workbooks in order to make informed, intelligent organizational decisions. This course covers Microsoft Office Specialist exam objectives to help individuals prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam. |
| Description | Upon successful completion of this course, participants will be able to:
|
| Prerequisites | To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
|
| Suggested Class Size | Minimum 3 Maximum 12 |
| Course Length | Full day |
| Table of Contents | Lesson 1: Customizing the Excel Environment Topic A: Configure Excel Options Topic B: Customize the Ribbon and the Quick Access Toolbar Topic C: Enable Excel Add-Ins Lesson 2: Creating Advanced Formulas Topic A: Use Range Names in Formulas Topic B: Use Specialized Functions Topic C: Use Array Formulas Lesson 3: Analyzing Data with Functions and Conditional Formatting Topic A: Analyze Data by Using Text and Logical Functions Topic B: Apply Advanced Conditional Formatting Lesson 4: Organizing and Analyzing Datasets and Tables Topic A: Create and Modify Tables Topic B: Sort Data Topic C: Filter Data Topic D: Use SUBTOTAL and Database Functions Lesson 5: Visualizing Data with Basic Charts Topic A: Create Charts Topic B: Modify and Format Charts Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Slicers |
Career
Login to
Virtual
Catalog and
Brazosport CollegeWebmail | ASTRA | F.A.S. | Institutional Profile | Library | Title IX/Sexual Misconduct | Campus Safety/Police Department
CARES ACT Required Postings | Equal Opportunity | BC Alert | Suicide Prevention | Employment Opportunities | Report a Problem with this Page
©2023 Brazosport College | 500 College Drive | Lake Jackson, TX 77566 | (979) 230-3000
A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459; Marshall.Campbell@brazosport.edu