Font size:


In this course, you will: · Customize the Excel environment. · Create advanced formulas. · Analyze data by using functions and conditional formatting. · Organize and analyze datasets and tables. · Visualize data by using basic charts. · Analyze data by using PivotTables, slicers, and PivotCharts


To ensure successful completion of this course we recommend taking Microsoft Office Excel 2013/2016 Level 1 or have the equivalent knowledge.


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


Standard and Professional Desktop Application & Professional Development classes may be cancelled or rescheduled by the client at least four (4) business days in advance without penalty. A full credit (no refunds) will be applied to future training on all cancelled classes that meet the above-stated criteria. A cancellation fee equal to the course fee will be incurred if a student provides less than 4 days’ notice for any Standard or Professional Desktop Applications, or Professional Development Skills class cancellations. Technical courses or Private classes may be cancelled or rescheduled (no refunds) greater than two weeks in advance without charge. The client is responsible for 50% of the class fee if a technical or private class is canceled or rescheduled within two weeks of the class date, and full price if the course is canceled or rescheduled within one week of the class date.

The course you have selected has limited or no upcoming scheduled training dates!

Please browse similar courses or request more information for assistance.'s training support team will respond within one business day with relevant offerings.