HARTMANN software group

Microsoft Office Excel 2013: Level 2 Training in Jefferson City

Enroll in or hire us to teach our Microsoft Office Excel 2013: Level 2 class in Jefferson City, Missouri by calling us @303.377.6176. Like all HSG classes, Microsoft Office Excel 2013: Level 2 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Excel 2013: Level 2 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

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!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.