Microsoft® Word 2016/365 Crash Course: Learn Word in One Day!

Click Here For More Information
Loading Courses

November 2019

Extreme Microsoft® Excel: Functions and Features for the Power User

November 5 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
$395.00 15 tickets left

Description: This course is designed for individuals with a high level of aptitude in using Excel functions and formulas. The function categories range from Math and Trig, Date and Time, Text, Lookup and Reference, Statistical, Financial, Logical, and Information. Power users will create several business profitability formulas and will also be presented with data analysis tools for management decision making. Highlights: FORECAST; AVERAGE; COUNT; COUNTBLANK; RANK; VLOOKUP; LOOKUP; INDEX; MATCH; PMT; FV; PV; IPMT; PPMT; CUMPPMT; CUMIPMT; SUMIF; SUMIFS; ROUND;…

Find out more »

Microsoft® Excel 2016: Data Tables & PivotTables Featuring PowerPivot

November 6 @ 8:30 am - 4:15 pm
$395 15 tickets left

Description: This course is the combination of two half-day split sessions. The first half is designed for those who have a general aptitude with Excel functionality when it comes to working with data lists and tables. There will be a brief review of the basic concepts of sorting and filtering data along with subtotaling data lists before one-dimensional PivotTables will be developed. This will morph into multi-dimensional PivotTables, using filters and slicers, and creating Pivot Charts. The second half features…

Find out more »

Microsoft® Excel 2016 Level III Advanced Topics

November 12 @ 8:30 am - 4:15 pm
$395

Course Outline: Validating, Protecting, and Auditing Forms and Templates Using Data Validation And Tracing Invalid Data How To Validate Data Input How To Compose A Data Input Message How To Create An Error Alert Message How To Circle Invalid Data Creating A New Workbook Based On A Template How To Create A New Workbook Base On A Template How To Create A New Template How To Create A New Workbook Base On Your Own Template How To Edit The Template…

Find out more »

Microsoft® Excel 2016 Formulas, Functions & PivotTables for the Advanced Excel User

November 13 @ 8:30 am - 4:15 pm
$395

Take this course if you want to learn useful tools, tricks and tips for utilizing functions and formulas available in Microsoft® Excel 2013. Learn which are best suited from over 300 available built-in functions. If you need to analyze large amounts of data quickly and easily, this class covers PivotTables – Excel’s best resource for doing so. Course Content: Lesson 1: The Interface Quick Access Toolbar Home Ribbon Insert Ribbon Page Layout Ribbon Formulas Ribbon Data Ribbon Review Ribbon Lesson…

Find out more »

Microsoft® Excel 2016: Data Analysis with PowerPivot

November 19 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
$395

Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models…

Find out more »

December 2019

Microsoft® Excel 2016: Data Tables & PivotTables Featuring PowerPivot

December 11 @ 8:30 am - 4:15 pm
$395 15 tickets left

Description: This course is the combination of two half-day split sessions. The first half is designed for those who have a general aptitude with Excel functionality when it comes to working with data lists and tables. There will be a brief review of the basic concepts of sorting and filtering data along with subtotaling data lists before one-dimensional PivotTables will be developed. This will morph into multi-dimensional PivotTables, using filters and slicers, and creating Pivot Charts. The second half features…

Find out more »

Microsoft® Excel 2016: Data Analysis with PowerPivot

December 12 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
$395

Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources for advanced Pivot Table creation is not theoretically possible. By using the Power Pivot add-in program, Excel power users can now create effective data models…

Find out more »

Extreme Microsoft® Excel: Functions and Features for the Power User

December 30 @ 8:30 am - 4:15 pm
Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
$395

Description: This course is designed for individuals with a high level of aptitude in using Excel functions and formulas. The function categories range from Math and Trig, Date and Time, Text, Lookup and Reference, Statistical, Financial, Logical, and Information. Power users will create several business profitability formulas and will also be presented with data analysis tools for management decision making. Highlights: FORECAST; AVERAGE; COUNT; COUNTBLANK; RANK; VLOOKUP; LOOKUP; INDEX; MATCH; PMT; FV; PV; IPMT; PPMT; CUMPPMT; CUMIPMT; SUMIF; SUMIFS; ROUND;…

Find out more »
+ Export Events

This course is offered by group request or onsite.

Target Student: This course is designed for students who are interested in learning fundamentals through advanced features needed to create and modify professional Microsoft Word documents that include advanced formatting such as Table of Contents, multiple columns, Headers and Footers, and more.

Course Content
  • Create and view new documents
  • Format text
  • Create bulleted and numbered lists
  • Setting up page margins, paper size and orientation
  • Creating page and section breaks
  • Adding Headers and Footers
  • Inserting/formatting text boxes
  • Adding Shapes, Pictures & WordArt
  • Using Tabs
  • Creating Watermarks
  • Working with Objects and Illustrations
  • Creating and using Styles
  • Working with Templates
  • Using Automating Features
  • Creating Columns
  • Formatting Columns
  • Creating a Table of Contents
  • Using Word with Excel, PowerPoint, Access and Outlook
  • Object Linking and Embedding (OLE)

Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Course Information
  • Prerequisite:Familiarity with the Windows operating system
  • Credit:PDUs: 6.5
  • Fee:$345
  • Length:1 day
  • Hours:8:30 a.m. - 4:15 p,m
  • Delivery:Instructor Led/Group Live
  • PMI_Activity_ID:ID: #000361

Related Courses