- This event 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‘
Project Management Professional (PMP®) Exam Prep Virtual Course – M/W/F, 12:00 p.m. – 4:30 p.m.
Virtual LivePMI’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.
Duke Energy PMP Boot Camp – Lake Mary, FL
Duke Energy - Lake Mary, FL 3300 Exchange Plaza, Room 155, Lake Mary, FL, United StatesThe 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 Management Salary Survey–Eighth Edition, certification indeed positively influences project manager salaries. PMP Requirements The Project Management Institute requires that you meet some initial requirements before you…
The Path to PMP® Certification Free Webinar
Virtual LiveTake 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…
The Path to PMI-RMP® Certification Free Webinar
The Risk Management Professional (PMI-RMP) certification, offered by the Project Management Institute (PMI), is highly desirable for several reasons. It demonstrates expertise in identifying, assessing, and mitigating risks, which is critical for project success. Join us for this free webinar to review the journey to obtaining the PMI-RMP credential. Learn the requirements to sit for the exam, how the exam is administered, how to study for the exam, how to know you are ready to take the exam, and lots…
Duke Energy PMP Boot Camp – Plainfield, IN
Duke Energy - Plainfield, IN TBA, Plainfield, INThe 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 Management Salary Survey–Eighth Edition, certification indeed positively influences project manager salaries. PMP Requirements The Project Management Institute requires that you meet some initial requirements before you…
Microsoft® Excel Crash Course: Learn Excel in Two Days!
Virtual LiveThis 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.…
The Path to PMP® Certification Free Webinar
Virtual LiveTake 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…
Microsoft® Power BI® Data Analytics Introduction
Virtual LiveCourse Description: This course involves the creation of exploration, analysis, and reporting of data insights and trends using the Microsoft Power BI® software. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain such insights, trends, and reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards,…
Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot
Virtual LiveCourse Description: This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level. In the first half, participants will reinforce foundational skills in working with Excel data lists and tables, including sorting, filtering, and subtotaling. Building on these essentials, the course introduces PivotTables—starting with basic, one-dimensional designs and progressing to multi-dimensional PivotTables enhanced by filters, slicers, and Pivot Charts. The second half focuses on PowerPivot,…
Duke Energy PMP Boot Camp – Raleigh, NC
Duke Energy - Raleigh, NCThe 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 Management Salary Survey–Eighth Edition, certification indeed positively influences project manager salaries. PMP Requirements The Project Management Institute requires that you meet some initial requirements before you…
Extreme Microsoft® Excel: Functions and Features for the Power User
Virtual LiveCourse Description: This advanced-level course is designed for Excel power users who want to maximize their command of functions, formulas, and data analysis tools to drive high-level business insights. Participants will dive deep into a broad spectrum of Excel’s most powerful function categories—including Math & Trig, Date & Time, Text, Lookup & Reference, Statistical, Financial, Logical, and Information. Through hands-on exercises and real-world examples, attendees will construct complex profitability formulas and apply advanced tools that support strategic decision-making and financial…
Microsoft Excel® Power Query
Virtual LiveDescription This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will be proficient in importing, reshaping, merging, and automating your data workflows, allowing you to work more efficiently and effectively with large datasets. You will also be able to create repeatable data processes that can be refreshed with ease, saving you time and effort. Learning Objectives: By the end of this…
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