Events

Loading Courses

« All Courses

  • This course has passed.

Microsoft® Excel 2016 Crash Course: Learn Excel in Two Days!

October 1, 2019 @ 8:30 am - October 2, 2019 @ 4:15 pm

$595.00

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

The Path to PMP® Certification Free Webinar

Virtual Live

Take your project management skills to the next level with the PMP certification, a gold standard recognized for its emphasis on competent leadership and team direction. This credential not only solidifies your existing skills but also makes you a preferred choice for employers, providing a boost to your earnings. To guide you on this journey, we offer our ‘Path to PMP® Certification’ webinar. It provides prospective PMP® candidates with essential information such as exam requirements, application tips, useful prep course…

Book Now Free 49 tickets left

Project Management Professional (PMP®) Certification Prep Course – Tuesday/Thursday, 2 weeks plus 1/2 day Tuesday (35 hours)

Virtual Live

This course runs for four full days, Tuesdays and Thursdays from 8 a.m. until 5 p.m. for the first four sessions, the last Tues. will be a half day from 8:00 a.m. - 12:00 p.m. The PMI's Project Management Professional (PMP)® credential stands as a crucial industry-recognized certification for project managers worldwide. Holding the PMP® signifies your proven competence, experience, and education in leading and directing projects. The value of this certification is reflected in enhanced attractiveness to employers and…

Book Now $1,795.00

Project Management Professional (PMP®) Certification Prep Course – 4.5 Days

Virtual Live

This course runs for four full days, Monday through Thursday from 8 a.m. - 5 p.m., then 1/2 day on Friday, 8:00 a.m. - 12:00 p.m. The PMI's Project Management Professional (PMP)® credential stands as a crucial industry-recognized certification for project managers worldwide. Holding the PMP® signifies your proven competence, experience, and education in leading and directing projects. The value of this certification is reflected in enhanced attractiveness to employers and higher potential earnings. As depicted in the PMI Project…

Book Now $1,795.00

Microsoft® Excel Basic Formulas and Charts

Virtual Live

The Basic Formulas portion of the class will acquaint the user with an overview of Excel formulas where cell addresses are featured for effective formula copying. Relative vs. absolute referencing is discussed and demonstrated as well as exposure to general formula functions such as SUM, AVERAGE, MAX, MIN, and COUNT. The user will also be shown various Date functions such as TODAY, NOW, MONTH, YEAR, and DAY. Objective: Upon completion of this course the novice Excel user will be able…

Book Now $199.00

Microsoft® Excel Advanced Formulas: Logicals and Lookups

Virtual Live

This more advanced Excel course will demonstrate to the user how to use formulas that extend across multiple worksheets, use conditional formulas namely in the Logical category, as well as exploring the deeper function category Lookup and Reference. Aggregate functions with testing conditions will be featured where mixed-cell referencing is involved along with formulas utilizing named ranges. In addition, this course will also delve into data mining and further will expose the user on how to create array formulas. Objective:…

Book Now $199.00

Microsoft® Excel VBA Level I: Macros, Constants and Variables

Virtual Live

Microsoft® Excel VBA Level I: Macros, Constants and Variables is divided in two parts.  Part 1 will demonstrate to the user how to effectively coordinate macros along with exposing them to the basic foundations of Visual Basic programming. The macro recorder will be used to create the base code that will be edited using coherent VB fundamentals. Objective: Upon completion of this course the user will be able to create a blueprint for developing a macro project by applying the…

Book Now $199.00

Microsoft® Excel VBA Level 2: Branching, Looping & Custom Functions & Forms

Virtual Live

Microsoft® Excel VBA Level 2: Branching, Looping & Custom Functions & Forms will explore the programming capabilities of conditional branch constructs as well as repetitive looping structures. The builds will be cumulative, beginning with the core basics and expanding to include interactive message boxes to control program flow. In addition, basic error-trapping techniques will be featured. Objective: The user will coordinate constructive code blocks that will run coherent loops controlled by conditional statements. They will also use the IF…Then…Else construct to…

Book Now $199.00

Microsoft® Power BI for the Desktop User: Part 1

Virtual Live

Objective: Upon successful completion of this course the user will be able to navigate the Power BI interface, explore data diagrams, model and query data. Microsoft Power BI for the Desktop User:  Part I is course is designed for individuals with a high level of aptitude in using data collection and storage programs, namely Excel and or Access. It is highly beneficial that the user has a moderate to advanced knowledge of data normalization and working with relational data. This course…

Book Now $199.00

Microsoft® Excel Crash Course: Learn Excel in Two Days!

Virtual Live

This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level, as well as those who are self-taught and want to learn short cuts and tips, plus some of the more advanced features. Packed full of information, topics range from fundamentals (using shortcuts) through advanced topics. The topics in this class are the most often-used and are a combination of features taught in the Foundations, Intermediate and Advanced Topics courses.…

Book Now $399.00

Microsoft® Excel Advanced Formulas: Logicals and Lookups

Virtual Live

This more advanced Excel course will demonstrate to the user how to use formulas that extend across multiple worksheets, use conditional formulas namely in the Logical category, as well as exploring the deeper function category Lookup and Reference. Aggregate functions with testing conditions will be featured where mixed-cell referencing is involved along with formulas utilizing named ranges. In addition, this course will also delve into data mining and further will expose the user on how to create array formulas. Objective:…

Book Now $199.00
Recurring

Project Management Professional (PMP®) Exam Prep Virtual Course – M/W/F, 12:00 p.m. – 4:30 p.m.

Virtual Live

PMI’s Project Management Professional (PMP)® credential is the most important industry-recognized certification for project managers. Globally recognized and demanded, the PMP® demonstrates that you have the experience, education and competency to lead and direct projects.

This recognition is seen through increased marketability to employers and higher salary; according to the PMI Project Management Salary Survey–Eighth Edition, certification positively impacts project manager salaries.

Book Now $1,795.00

Microsoft® Excel Basic Formulas and Charts

Virtual Live

The Basic Formulas portion of the class will acquaint the user with an overview of Excel formulas where cell addresses are featured for effective formula copying. Relative vs. absolute referencing is discussed and demonstrated as well as exposure to general formula functions such as SUM, AVERAGE, MAX, MIN, and COUNT. The user will also be shown various Date functions such as TODAY, NOW, MONTH, YEAR, and DAY. Objective: Upon completion of this course the novice Excel user will be able…

Book Now $199.00

Course Description: This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level, as well as those who are self-taught and want to learn short cuts and tips, plus some of the more advanced features.  Packed full of information, topics range from fundamentals (using shortcuts) through advanced topics.  The topics in this class are the most often-used and are a combination of features taught in the Foundations, Intermediate and Advanced Topics courses.

Course Outline:

Use the Excel Ribbon
Contextual Tabs
Quick Access Toolbar
Shortcut menus
Changing views

Entering Data Into a Worksheet
Entering text (labels)
Editing text with the formula bar
Replacing contents of cells
Using delete, undo/redo
Using AutoFill to enter data
Customize AutoFill
Use a List to enter data

Using a Simple Formula
Resizing the Formula Bar
Enter a Formula using the keyboard
Enter a cell or Range Reference using the mouse
Using AutoSum to calculate totals
Using Relative References
Using Absolute References

Using Simple Functions
Enter a function directly
Using AutoComplete to create formulas
Turn Formula Autocomplete on and off
Insert other functions using AutoSum button
Using AutoCalculate to do a calculation without a formula

Adjusting Rows and Columns
Adjust Rows and columns using the mouse and the Menu
Hide/Unhide rows and columns
Freeze a column or a row
Split a worksheet into panes

Formatting Cells Using Ribbons
Change the font and font properties
Align data in a cell
Indent data in a cell
Merge cells
Change numbers to percentages
Increase/decrease decimal places
Copy a format using Format Painter

Creating A Chart
How To Insert a Chart
How To Move a Chart
How To Resize a Chart
How To Change The Chart Type
How To Add, Edit or Remove a Chart Data Source
How To Swap Labels In The Legend With The Horizontal Axis
How To Change The Order Of a Data Series
How To Move An Existing Chart To a New Worksheet

Formatting a Chart
How To Select a Chart Element
How To Format The Chart Elements
How To Format Text In a Chart Using WordArt
How To Change The Text Orientation
How To Change The Color Of a Chart Element
How To Create a Combination Of Chart Types
How To Create a Pie Chart
How To Set The 3-D Rotation
How To Explode a Wedge In A Pie Chart
How To Create a Picture Chart

Setting Up a Page and Printing
How To Insert And Remove a Page Break
How To Set And Clear The Print Area
How To Change The Margin In The Page Layout View
How To Change The Page Orientation
How To Change The Scaling
How To Change The Paper Size
How To Change The Page Margin
How To Align To The Center Of The Page
How To Add A Header / Footer
How To Add An Image As a Watermark

Previewing and Printing
How To Preview The Print
How To Print Active Sheets
How To Print Selected Cells
How To Print A Chart
How To Print Multiple Copies

Creating Tables
How To Create a Table
How To Change The Style Of a Table
How To Create A New Table Style
How To Show Or Hide Table Elements
How To Create A Calculation In a Table
How To Insert And Delete A Table Row
How To Resize a Table
How To Convert A Table To a Range
How To Sort The Data In a Table
How To Perform Multiple Sort
How To Customize The Sort Order

Using The AutoFilter
How To Enable / Disable The AutoFilter
How To Apply / Remove The Filter
How To Customize The Filter

Using The Advanced Filter
How To Define The Criteria Range
How To Use The Advanced Filter

Creating a PivotTable
How To Create a PivotTable
Updating a PivotTable
How To Update The Information In a PivotTable
How To Change The Layout Of a PivotTable
How To Add An Information Field To a PivotTable
How To Arrange Information In a PivotTable
How To Filter The Report In a PivotTable
How To Filter Specific Records

Exploring What-If Tables
How To Create a One Variable What-If Table
How To Create a Two Variables What-If Table

Using Scenarios
How To Create Scenarios
How To Apply a Scenario

Implementing Problem Solving
How To Use The Goal Seek Tool
How To Load Add-Ins
How To Use The Solver Tools

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

Protecting Worksheet Styles, Contents And Elements
How To Protect The Worksheet
How To Unprotect The Worksheet
How To Unlock Cells For Editing In A Protected Sheet
How To Hide A Cell Formula
How To Set A Password To Edit A Specific Range
How To Grant Selected Users Permission To Edit A Range Without A Password

Auditing Worksheets And Tracing Cell References
How To Find Cells That Provide Data To An Active Cell (Precedents)
How To Find Cells That Are Referred To By An Active Cell (Dependents)
How To Correct Calculation Errors
How To Set Error Checking Options
How To Scan And Correct All Errors
How To Use The Watch Window

Working with Advanced Formatting, Styles and Outlining
Customizing The Appearance Of Data With Advanced Formatting
How To Use The Built-In Number Formats
How To Customize The Number Format
How To Customize The Date Format

Using Conditional Formatting
How To Use The Conditional Formatting To Highlight Cells
How To Use The Data Bars
How To Use The Color Scales
How To Use The Icon Sets
How To Edit The Rules
How To Change The Precedence Of The Rules
How To Stop A Rule
How To Clear The Rules

Using Data Outlining
How To Create An Outline Automatically
How To Remove An Outline
How To Create An Outline Manually
How To Use A Subtotal To Create An Outline
How To Show / Hide Details Using Outline Symbols

Working With Multiple Worksheets and Workbooks
Managing Data in Multiple Worksheets
How To Select Adjacent Worksheets
How To Select Non-Adjacent Worksheets
How To Enter Data Into Multiple Worksheets

Using Range Names
How To Define Names Quickly
How To Define A Range Name Manually
How To Define A 3-D Range Using The Menu
How To Manage Names Using The Name Manager
How To Redefine The Cell References For A Range Name
How To Insert A Name In A Formula

Combining Worksheets And Data From Different Workbooks
How To Consolidate Data
How To Move Or Copy Worksheets to Another Workbook
Linking Information From Different Worksheets And Workbooks
How To Link Information Using Copy And Paste Link
How To Update A Link

Using Advanced Functions
Using Financial Functions
How To Use The PMT Function
How To Use The ABS Function

Using Logical Functions
How To Use A Logical Test
How To Use The IF Function To Return A Text
How To Use The IF Function To Return A Value
How To Use A Nested IF Function
How To Use The OR Function
How To Use The AND Function
How To Use the COUNTIF Function

Understanding Macros
How To Record A New Macro
How To Run A Macro
How To Create A Run Macro Button On The Quick Access Toolbar

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

Details

Start:
October 1, 2019 @ 8:30 am
End:
October 2, 2019 @ 4:15 pm
Cost:
$595.00
Courses Category:

Locations

Knowledge Source Inc.
3100 Smoketree Court, Suite 200
Raleigh, NC 27604 United States
+ Google Map
Phone
919-878-7100
View Locations Website

Leave a Comment

Your email address will not be published. Required fields are marked *