18 and older
This course builds upon the foundation knowledge presented in the Excel - Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that you can use to create a dashboard. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.Excel Versions That Can Attend:
Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)Course Taught With:
Excel version 2016 (Microsoft Windows PC) Software and Courseware
Not Appropriate For:
Macintosh versions of ExcelPrerequisite:
Excel - Level 1Course Outline
Lesson 1: Using Names in Formulas and Functions
- Topic A: Examine Dashboards
- Topic B: Use Range Names in Formulas
- Topic C: Use Specialized Functions
Lesson 2: Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Work with Forms and Controls
Lesson 3: Applying Conditional Logic
- Topic A: Use Lookup Functions
- Topic B: Combine Functions
Lesson 4: Visualizing Data with Basic Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
Lesson 5: Using Advanced Charting Techniques
- Topic A: Create Dual-Axis Charts and Trendlines
- Topic B: Create Sparklines
Lesson 6: Analyzing Data with PivotTables, PivotCharts, and Slicers
Headsets for free, Guaranteed to Run, Re-Takes for free (Up to 6 months), Interactive Classroom environment.Registration Note:
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Slicers
We can only accept students into our classes whose tuition is being paid by an employer or sponsoring organization. Self-paying individuals cannot enroll.
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.
The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.
Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.