Intermediate Microsoft Excel 2016
- Worksheet Management
- Database Management
- Database Functions
- PivotTables & PivotCharts
- Logical Functions
- Statistical Functions
- Pivot Tables
The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.
Intermediate SQL Course
- Subqueries
- Insert, Update, Delete
- Create Tables
- Create Views
- Create Indexes
Create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.
Beginner Access
- Navigate Access Environment
- Customize Configuration
- Organize/Manage Data
- Queries to Join, Sort & Filter
- View, Access & Input Forms
- Create Custom Reports
Covers the basic skills, including: identifying the components of the Microsoft Access 2016 environment, identifying the components of a database, organizing data in tables, viewing data in tables, querying a database, designing forms and generating reports.
Advanced Microsoft PowerPoint 2016
- Designing
- Collaborating
- Commenting
- Navigation
- Using Multimedia
- Layered Objects
- Charts from Excel
- Tables from Excel
- Custom Shows
- Recording a Slideshow
Concentrates on some more advanced skills, including: customizing the PowerPoint environment, customizing a design template, adding SmartArt graphics to a presentation, adding special effects to a presentation, customizing a slide show, collaborating on a presentation and securing and distributing a presentation
Advanced Microsoft Excel 2016
- Special Formatting
- Advanced Functions
- What If Analysis
- Advanced Analytical Tools
- Advanced Database Functions
- Introduction to Macros
Our advanced Excel training will delve into data tables, goal seek, advanced database functions (including INDEX-MATCH), recording macros, and advanced analytical tools. Throughout the course you'll be building speed with our revolutionary time-saving tricks.
Beginner SQL Course
- Simple Queries
- Conditional Criteria
- Organize Data
- Join Tables
- Aggregate Functions
Use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.
Beginner Microsoft Excel 2016
- Perform Calculations
- Modify Text
- Format a Worksheet
- Create Charts and Tables
- Manage Workbooks
This beginner Excel course covers the fundamentals, including basic formulas, functions, formatting, printing, charts, & calculations. We'll also introduce you to some essential shortcuts to start boosting your speed. This class is the perfect introduction to Excel that will help you set a solid foundation in the software.
Beginner Microsoft PowerPoint 2016
- Creating Presentation
- Images
- SmartArt
- Shapes
- Layered Objects
- Tables
- Charts
- Proofing and Editing
- Animation
- Running a Presentation
Covers the basic skills, including: exploring the PowerPoint 2016 interface and familiarizing yourself with the interface, creating a presentation, formatting text on slides, adding graphical objects to a presentation, modifying graphical objects on slides, working with tables in a presentation, importing charts to a presentation, and preparing to deliver a presentation
Intermediate Access
- Design a Relational Database
- Join Tables to Retrieve Data
- Validate Data Entered
- Advanced Queries
- Efficiency & Performance
- Maintain Data Integrity
- Customize Reports
Concentrates on some more advanced skills, including: streamlining data entry and maintaining data integrity, joining tables to retrieve data from unrelated tables, creating flexible queries to display specified records, allowing for user-determined query criteria, modifying data using queries, improving forms, customizing reports to organize the displayed information, producing specific print layouts and sharing data between Access and other applications.