## Microsoft Office Excel 2013: Level 2 Training

Upcoming Instructor Led Online and Public Microsoft Office Excel 2013: Level 2 classes
 Microsoft Office Excel 2013: Level 2 Training/Class 11 February, 2020 - 11 February, 2020 \$250
 Microsoft Office Excel 2013: Level 2 Training/Class 10 March, 2020 - 10 March, 2020 \$250
We offer private customized training for groups of 3 or more attendees.

### Course Description

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
Course Length: 1 Days
Course Tuition: \$250 (US)

#### Prerequisites

Before starting this course, students are recommended to take the following or possess equivalent knowledge: Microsoft Office Excel 2010 or 2013: Level 1.

#### Course Outline

 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   Appendix A: Microsoft Office Excel 2013 Exam 77-420 Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428 Appendix C: Financial Functions Appendix D: Date and Time Functions Appendix E: Working with Graphical Objects

### Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!