Upcoming New Horizon Knoxville Instructor-led Classes

Instructor-led Training in Knoxville, TN

With all the benefits of living in an online world, most of us still appreciate the value of meeting and learning face-to-face. With that in mind, Knoxville's New Horizons training center is offering our most popular classes in a traditional classroom setting, including:

  • Microsoft Office (Excel, PowerPoint, Access and Project)
  • Data Analysis with Excel
  • Microsoft Power BI
  • Business Skills
  • Project Management Training

In addition to our complete catalog of courses and learning options, these classes offer our corporate and government customers the benefit of “in person” training with expert trainers and facilitators.

Classes will be offered at our New Horizons Knoxville training center located at 408 N Cedar Bluff, Suite 555, Knoxville, TN 37923. Companies with four or more students interested in the same course should inquire about the option of a private class delivered either on location or at our training center.

Ready to learn more about traditional classroom training solutions in Knoxville? Contact New Horizons.

Business Skills Classes (click class for outline)

Ready to learn more about Instructor-led training solutions in Knoxville? Contact New Horizons.

Private Group Training

COURSE OUTLINE

1 - GETTING STARTED WITH MICROSOFT PROJECT
  • Topic A: Identify Project Management Concepts
  • Topic B: Navigate the Microsoft Project 2016 Environment
  • 2 - DEFINING A PROJECT
  • Topic A: Create a New Project Plan
  • Topic B: Define a Project
  • Topic C: Assign a Project Calendar
  • 3 - CREATING AND ORGANIZING TASKS
  • Topic A: Add Tasks to a Project Plan
  • Topic B: Import Tasks From Other Programs
  • Topic C: Create a Work Breakdown Structure
  • Topic D: Define Task Relationships
  • Topic E: Schedule Tasks
  • 4 - MANAGING PROJECT PLAN RESOURCES
  • Topic A: Add Resources to a Project Plan
  • Topic B: Create a Resource Calendar
  • Topic C: Enter Costs for Resources
  • Topic D: Assign Resources to Tasks
  • Topic E: Resolve Resource Conflicts
  • 5 - FINALIZING A PROJECT PLAN
  • Topic A: Optimize a Project Plan
  • Topic B: Set a Baseline
  • Topic C: Share a Project Plan
  • COURSE OUTLINE

    1 - EXECUTING A PROJECT
  • Topic A: Enter Task Progress
  • Topic B: Update Task Progress with SharePoint
  • Topic C: Update Work
  • Topic D: Update Costs
  • 2 - MONITORING PROJECT PROGRESS
  • Topic A: View Project Progress
  • Topic B: Add Custom Fields
  • Topic C: Create Custom Views
  • Topic D: Create a Network Diagram
  • Topic E: Analyze a Project Plan
  • 3 - CONTROLLING A PROJECT PLAN
  • Topic A: Edit the Task List
  • Topic B: Reschedule Tasks
  • Topic C: Update a Baseline
  • 4 - REPORTING ON PROGRESS
  • Topic A: Format and Share a Chart View
  • Topic B: View Existing Reports
  • Topic C: Create Custom Reports
  • Topic D: Create a Visual Report
  • 5 - CUSTOMIZING THE APPLICATION
  • Topic A: Change Project Options
  • Topic B: Create a Project Plan Template
  • Topic C: Share Resources
  • Topic D: Link Project Plans
  • COURSE OUTLINE

    1 - MODIFYING THE POWERPOINT ENVIRONMENT
  • Topic A: Customize the User Interface
  • Topic B: Set PowerPoint 2016 Options
  • 2 - CUSTOMIZING DESIGN TEMPLATES
  • Topic A: Modify Slide Masters and Slide Layouts
  • Topic B: Add Headers and Footers
  • Topic C: Modify the Notes Master and the Handout Master
  • 3 - ADDING SMARTART AND MATH EQUATIONS TO A PRESENTATION
  • Topic A: Create SmartArt
  • Topic B: Modify SmartArt
  • Topic C: Write Math Equations
  • 4 - WORKING WITH MEDIA AND ANIMATIONS
  • Topic A: Add Audio to a Presentation
  • Topic B: Add Video to a Presentation
  • Topic C: Customize Animations and Transitions
  • 5 - COLLABORATING ON A PRESENTATION
  • Topic A: Review a Presentation
  • Topic B: Store and Share Presentations on the Web
  • 6 - CUSTOMIZING A SLIDE SHOW
  • Topic A: Annotate a Presentation
  • Topic B: Set Up a Slide Show
  • Topic C: Create a Custom Slide Show
  • Topic D: Add Hyperlinks and Action Buttons
  • Topic E: Record a Presentation
  • 7 - SECURING AND DISTRIBUTING A PRESENTATION
  • Topic A: Secure a Presentation
  • Topic B: Broadcast a Slide Show
  • Topic C: Create a Video or a CD
  • COURSE OUTLINE

    1 - GETTING STARTED WITH POWERPOINT
  • Topic A: Navigate the PowerPoint Environment
  • Topic B: View and Navigate a Presentation
  • Topic C: Create and Save a PowerPoint Presentation
  • Topic D: Use PowerPoint Help
  • 2 - DEVELOPING A POWERPOINT PRESENTATION
  • Topic A: Select a Presentation Type
  • Topic B: Edit Text
  • Topic C: Build a Presentation
  • 3 - PERFORMING ADVANCED TEXT EDITING OPERATIONS
  • Topic A: Format Characters
  • Topic B: Format Paragraphs
  • Topic C: Format Text Boxes
  • 4 - ADDING GRAPHICAL ELEMENTS TO YOUR PRESENTATION
  • Topic A: Insert Images
  • Topic B: Insert Shapes
  • 5 - MODIFYING OBJECTS IN YOUR PRESENTATION
  • Topic A: Edit Objects
  • Topic B: Format Objects
  • Topic C: Group Objects
  • Topic D: Arrange Objects
  • Topic E: Animate Objects
  • 6 - ADDING TABLES TO YOUR PRESENTATION
  • Topic A: Create a Table
  • Topic B: Format a Table
  • Topic C: Insert a Table from Other Microsoft Office Applications
  • 7 - ADDING CHARTS TO YOUR PRESENTATION
  • Topic A: Create a Chart
  • Topic B: Format a Chart
  • Topic C: Insert a Chart from Microsoft Excel
  • 8 - PREPARING TO DELIVER YOUR PRESENTATION
  • Topic A: Review Your Presentation
  • Topic B: Apply Transitions
  • Topic C: Print Your Presentation
  • Topic D: Deliver Your Presentation
  • COURSE OUTLINE

    1 - GETTING STARTED WITH ACCESS
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access
  • 2 - WORKING WITH TABLE DATA
  • Modify Table Data
  • Sort and Filter Records
  • 3 - QUERYING A DATABASE
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
  • 4 - USING FORMS
  • Create Basic Access Forms
  • Work with Data on Access Forms
  • 5 - GENERATING REPORTS
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports
  • 6 - DESIGNING A RELATIONAL DATABASE
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
  • 7 - JOINING TABLES
  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets
  • 8 - USING DATA VALIDATION
  • Use Field Validation
  • Use Form and Record Validation
  • 9 - CREATING ADVANCED QUERIES
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • 10 - ORGANIZING A DATABASE FOR EFFICIENCY
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
  • 11 - USING ADVANCED REPORTING TECHNIQUES
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report
  • COURSE OUTLINE

    1 - GETTING STARTED
  • Housekeeping Items
  • Pre-Assignment Review
  • Workshop Objectives
  • The Parking Lot
  • Action Plan
  • 2 - WHAT ARE SOFT SKILLS?
  • Definition of Soft Skills
  • Empathy and the Emotional Intelligence Quotient
  • Professionalism
  • Learned vs. Inborn Traits
  • 3 - SOFT SKILL 1: COMMUNICATION
  • Ways We Communicate
  • Improving Non-Verbal Communication
  • Listening
  • Openness and Honesty
  • 4 - SOFT SKILL 2: TEAMWORK
  • Identifying Capabilities
  • Get Into Your Role
  • Learn the Whole Process
  • The Power of Flow
  • 5 - SOFT SKILL 3: PROBLEM SOLVING
  • Define the Problem
  • Generate Alternative Solutions
  • Evaluate the Plans
  • Implementation and Re-evaluation
  • 6 - SOFT SKILL 4: TIME MANAGEMENT
  • The Art of Scheduling
  • Prioritizing
  • Managing Distractions
  • The Multitasking Myth
  • 7 - SOFT SKILL 5 AND 6: ATTITUDE AND WORK ETHIC
  • What Are You Working For?
  • Caring for Others vs. Self
  • Building Trust
  • Work Is Its Own Reward
  • 8 - SOFT SKILL 7: ADAPTABILITY/FLEXIBILITY
  • Getting over the Good Old Days Syndrome
  • Changing to Manage Process
  • Changing to Manage People
  • Showing You're Worth Your Weight in Adaptability
  • 9 - SOFT SKILL 8: SELF-CONFIDENCE
  • Confident Traits
  • Self-Questionnaire
  • Surefire Confidence Building Tactics
  • Build Up Others
  • 10 - SOFT SKILL 9: ABILITY TO LEARN FROM CRITICISM
  • Wow, You Mean I'm Not Perfect?
  • Listen With An Open Mind
  • Analyze and Learn
  • Clear the Air and Don't Hold Any Grudges
  • 11 - SOFT SKILL 10: NETWORKING
  • Redefining Need
  • Identifying Others' Interests
  • Reaching Out
  • When to Back Off
  • 12 - WRAPPING UP
  • Words From The Wise
  • Review Of The Parking Lot
  • Lessons Learned
  • Recommended Reading
  • Completion Of Action Plans And Evaluations
  • COURSE OUTLINE

    1 - ANALYZING DATA WITH SELF-SERVICE BI
  • Data Analysis and Visualization for Business Intelligence
  • Self-Service BI with Microsoft Power BI
  • 2 - CONNECTING TO DATA
  • Create Data Connections
  • Model Data with Relationships
  • Save Power BI Files
  • 3 - PERFORMING ADVANCED DATA MODELING AND SHAPING
  • Clean and Transform Data with the Query Editor
  • Shape Data with the Query Editor
  • Combine and Manage Data Rows
  • 4 - VISUALIZING DATA WITH POWER BI
  • Create Visualizations in Power BI
  • Chart Data in Power BI
  • 5 - ENHANCING DATA ANALYSIS
  • Enhance Analysis with Customized Visuals and Pages
  • Enhance Analysis with Tooltips
  • 6 - MODELING DATA WITH CALCULATIONS
  • Create Calculations with Data Analysis Expressions (DAX)
  • Create Calculated Measures and Conditional Columns
  • 7 - CREATING INTERACTIVE VISUALIZATIONS
  • Create and Manage Data Hierarchies
  • Filter and Slice Reports
  • Create Dashboards in Power BI
  • COURSE OUTLINE

    1 - PREPARING DATA & CREATING PIVOTTABLES
  • Topic A: Prepare Data
  • Topic B: Create a PivotTable from a Local Data Source
  • Topic C: Create a PivotTable from Multiple Local Data Sources
  • Topic D: Create a PivotTable from an External Data Source
  • 2 - ANALYZING DATA USING PIVOTTABLES
  • Topic A: Summarize PivotTable Data
  • Topic B: Organize PivotTable Data
  • Topic C: Filter PivotTable Data
  • Topic D: Format a PivotTable
  • Topic E: Refresh and Change PivotTable Data
  • 3 - WORKING WITH PIVOTCHARTS
  • Topic A: Create a PivotChart
  • Topic B: Manipulate PivotChart Data
  • Topic C: Format a PivotChart
  • 4 - GETTING STARTED WITH POWER PIVOT
  • Topic A: Enable and Navigate Power Pivot
  • Topic B: Manage Data Relationships
  • 5 - VISUALIZING POWER PIVOT DATA
  • Topic A: Create a Power Pivot Report
  • Topic B: Create Calculations in Power Pivot
  • 6 - WORKING WITH ADVANCED FUNCTIONALITY IN POWER PIVOT
  • Topic A: Create a Key Performance Indicator
  • Topic B: Work with Dates and Time in Power Pivot
  • COURSE OUTLINE

    1 - WORKING WITH FUNCTIONS
  • Define Cell Ranges and Reference Them in Formulas
  • Perform Conditional Calculations
  • Carry Out Logical and Specialized Functions
  • Work with Date and Time Functions
  • Understand and Execute Text Functions
  • 2 - WORKING WITH LISTS
  • Sort and Filter Data
  • Learn the Capabilities of Database Functions
  • Query Data with Database Functions
  • Outline and Subtotal Data
  • 3 - ANALYZING DATA
  • Build and Modify Tables
  • Create Formatting Rules
  • Apply Conditional Formatting to Alter Groups of Cells
  • 4 - VISUALIZING DATA WITH CHARTS
  • Organize and Represent Data with Charts
  • Modify and Format Charts
  • Discover and Implement Advanced Chart Features
  • 5 - ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data Using Timelines and Slicers
  • COURSE OUTLINE

    1 - GETTING STARTED WITH MICROSOFT OFFICE EXCEL
  • Learn Your Way Around the Excel Menu
  • Understand and Apply Excel Formulas
  • Create and Save a Basic Workbook
  • Enter Data Into Cells
  • Access Excel Help
  • 2 - PERFORMING CALCULATIONS
  • Build Custom Worksheet Formulas
  • Insert Built-In Functions to Your Data
  • Save and Reuse Formulas
  • 3 - MODIFYING A WORKSHEET
  • Insert, Delete and Resize Cells, Columns and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
  • 4 - FORMATTING A WORKSHEET
  • Format Text and Numbers
  • Align Cell Data
  • Apply Styles, Themes and Basic and Conditional Formatting
  • Create and Select Worksheet Templates
  • 5 - PRINTING WORKBOOKS
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
  • 6 - MANAGING WORKBOOKS
  • Manage Worksheets and Workbook Properties
  • Create, Apply or Delete Workbook and Worksheet Views
  • COURSE OUTLINE

    1 - WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS
  • Reference Cells and Groups of Cells Across Worksheets
  • Link Cells to External Worksheets
  • Consolidate Data Across Worksheets
  • 2 - USING LOOKUP FORMULAS AND FORMULA AUDITING
  • Search Rows or Columns Using LOOKUP Functions
  • Display Relationships Between Cells and Formulas with the Trace Command
  • Watch Cells and Formulas From the Watch Tool
  • 3 - SHARING AND PROTECTING WORKBOOKS
  • Collaborate on Workbooks
  • Apply Varying Levels of Workbook Access and Protections
  • 4 - AUTOMATING WORKBOOK FUNCTIONALITY
  • Create and Manage Validation Rules and Lists
  • Search for Invalid Data and Formulas with Errors
  • Record Macros to Automate Tasks
  • 5 - CREATING SPARKLINES AND MAPPING DATA
  • Create Sparklines to Show Trends
  • Map Data
  • 6 - FORECASTING DATA
  • Determine Potential Outcomes Using Data Tables and Scenarios
  • Solve for Desired Outputs with the Goal Seek Feature
  • Forecast Data Trends
  • COURSE OUTLINE

    1 - PROJECT MANAGEMENT INTRODUCTION
  • PMP® Exam Details
  • Project Management Introduction Overview
  • Defining Projects
  • The Importance of Project Management
  • Project, Program, Portfolio and Operations Management
  • Key Components
  • Project Management Process Groups
  • Project Management Knowledge Areas
  • Project Data, Information, and Reports
  • Tailoring
  • Project Management Business Documents
  • Success Measurements
  • PMP® Test-Worthy Topics
  • Practice Questions
  • 2 - THE ENVIRONMENT IN WHICH PROJECTS OPERATE
  • The Environment in Which Projects Operate Overview
  • Enterprise Environmental Factors
  • Organizational Process Assets
  • Organizational Systems
  • Governance Frameworks
  • Management Elements
  • Organizational Structure Types
  • Project Management Office
  • PMP® Test-Worthy Topics
  • Practice Questions
  • 3 - THE ROLE OF THE PROJECT MANAGER
  • The Role of the Project Manager Overview
  • The Project Manager’s Sphere of Influence
  • Project Management Competencies
  • Leadership: Politics, Power, and Getting Things Done
  • Levels of Skills Capability
  • Competency Model
  • Comparison of Leadership and Management
  • Leadership Styles
  • Personality
  • Performing Integration
  • Navigating Complexity: A Practice Guide
  • PMP® Test-Worthy Topics
  • Practice Questions
  • 4 - INITIATING PROCESSES
  • Initiating Process Group Overview
  • Develop Project Charter
  • Identify Stakeholders
  • PMP® Test-Worthy Topics
  • Practice Questions
  • 5 - PLANNING PROCESSES
  • Planning Process Group Overview
  • Section A: Management Plans
  • Develop Project Management Plan
  • Subsidiary Management Plans
  • Plan Scope Management
  • Plan Schedule Management
  • Plan Cost Management
  • Plan Quality Management
  • Plan Resource Management
  • Plan Communications Management
  • Plan Risk Management
  • Plan Procurement Management
  • Plan Stakeholder Engagement
  • Change Management Plan and Configuration
  • Management Plan
  • PMP® Test-Worthy Topics
  • Practice Questions?
  • Section B: Scope, Schedule, and Cost Processes
  • Collect Requirements
  • Define Scope
  • Create WBS
  • Define Activities
  • Sequence Activities
  • Estimate Activity Resources
  • Estimate Activity Durations
  • Develop Schedule
  • Overview: Cost Planning Processes
  • Estimate Costs
  • Determine Budget
  • PMP® Test-Worthy Topics
  • Practice Questions
  • Section C: Risk Processes
  • Identify Risks
  • Perform Qualitative Risk Analysis
  • Perform Quantitative Risk Analysis
  • Plan Risk Responses
  • PMP® Test-Worthy Topics
  • Practice Questions
  • 6 - EXECUTING PROCESSES
  • Executing Processes Overview
  • Direct and Manage Project Work
  • Manage Project Knowledge
  • Manage Quality
  • Acquire Resources
  • Develop Team
  • Manage Team
  • Manage Communications
  • Implement Risk Responses
  • Conduct Procurements
  • Manage Stakeholder Engagement
  • PMP® Test-Worthy Topics
  • Practice Questions
  • 7 - MONITORING AND CONTROLLING PROCESSES
  • ? Monitoring and Controlling Process Group Overview
  • Monitor and Control Project Work
  • Perform Integrated Change Control
  • Validate Scope
  • Control Change
  • Control Schedule
  • Control Costs
  • Control Quality
  • Control Resources
  • Monitor Communications
  • Monitor Risks
  • Control Procurements
  • Monitor Stakeholder Engagement
  • PMP® Test-Worthy Topics
  • 8 - CLOSING PROCESSES
  • Closing Process Group Overview
  • Close Project or Phase
  • PMP® Test-Worthy Topics
  • Practice Questions
  • COURSE OUTLINE

    1 - GETTING STARTED WITH PROJECT MANAGEMENT
  • Define Project Management Basics
  • Identify Influencing Factors
  • Define Project Management Certifications
  • 2 - LAUNCHING PROJECTS
  • How Organizations Choose the Right Project
  • Identify Project Stakeholders and Their Expectations
  • Authorize a Project
  • Identify the Project Scope
  • 3 - ESTIMATING PROJECT WORK
  • Develop a WBS
  • Identify the Relationships Between Work Packages
  • Identify Resources
  • Estimate Time
  • 4 - CREATING A PROJECT SCHEDULE
  • Develop a Project Schedule
  • Create a Schedule Baseline
  • 5 - PLANNING PROJECT COSTS
  • Establish Project Costs
  • Establish the Cost Baseline
  • Reconcile Funding and Costs
  • 6 - PLANNING FOR RISK
  • Create a Risk Management Plan
  • Identify Risks and Their Causes
  • Analyze Risks
  • Develop a Risk Response Plan
  • 7 - PLANNING FOR QUALITY AND COMPLIANCE
  • Deliver the Desired Project Results
  • Verify Compliance Requirements
  • 8 - MANAGING THE PROJECT TEAM
  • Plan Your Project Team
  • Assemble the Team
  • Develop the Team
  • Manage the Team
  • 9 - MANAGING PROJECT PROCUREMENTS
  • Plan for Project Procurements
  • Obtain Responses from Vendors
  • Select the Right Vendor
  • Manage Vendors and Procurements
  • 10 - MANAGING CHANGE DURING PROJECT EXECUTION
  • Prepare for Project Execution
  • Manage Project Changes
  • Monitor the Project Scope
  • 11 - MONITORING AND CONTROLLING PROJECT SCHEDULE AND COST
  • Monitor and Control the Project Schedule
  • Optimize the Project Schedule
  • Monitor and Control Project Cost
  • 12 - MONITORING AND CONTROLLING RISK AND QUALITY
  • Monitor and Control Risks
  • Put Quality Plans into Action
  • Control Project Quality
  • 13 - COMMUNICATING AND REPORTING
  • Communicate During a Project
  • Distribute Project Information
  • Manage Stakeholder Relationships and Expectations
  • Report on Project Performance
  • 14 - CLOSING THE PROJECT
  • Deliver the Final Product
  • Close Project Procurements
  • Close the Project
  • COURSE OUTLINE

    1 - GETTING STARTED WITH PROJECT MANAGEMENT
  • Describe a Project
  • Describe the Project Management Life Cycle
  • Identify the Role of a Project Manager
  • 2 - INITIATING A PROJECT
  • Determine the Scope of a Project
  • Identify the Skills for a Project Team
  • Identify the Risks to a Project
  • 3 - PLANNING FOR TIME AND COST
  • Create a Work Breakdown Structure
  • Sequence the Activities
  • Create a Project Schedule
  • Determine Project Costs
  • 4 - PLANNING FOR PROJECT RISKS, COMMUNICATION, AND CHANGE CONTROL
  • Analyze the Risks to a Project
  • Create a Communication Plan
  • Plan for Change Control
  • 5 - MANAGING A PROJECT
  • Begin Project Work
  • Execute the Project Plan
  • Track Project Progress
  • Report Performance
  • Implement Change Control
  • 6 - EXECUTING THE PROJECT CLOSEOUT PHASE
  • Close a Project
  • Create a Final Report

  • Facilitator Bios

    Valerie Taylor

    Valerie is one of New Horizon's highest rated instructors in North America (and consistently has been since 2012), specializing in Microsoft Office training and Leadership Development. She excels at providing students with rich, vibrant learning experiences. Valerie has over eighteen years’ experience providing end-to-end learning and performance improvement solutions for a variety of clients.

    Barry Mulkhraj2

    Barry is a project management PMP certified facilitator and has worked in a wide range of organizations including Governmental Foreign Service, Technology Manufacturing, Oil and Gas, Insurance as well as the tobacco industry. His major accomplishments are in process streamlining and human behavioral sciences. He is currently a Project Management Instructor with clients in military, municipal government and the private sector.