- 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‘
Project Management Professional (PMP®) Exam Prep Virtual Course – M/W/F, 12:30 p.m. – 4:30 p.m. (36 hours)
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.
Microsoft® Excel Charts
Virtual LiveMicrosoft® Excel Charts will demonstrate to the Excel user how to create effective charts off of spreadsheet data. A discussion of chart basics will be featured along with the creation of column charts, pie charts, three-dimensional charts, and a variety of chart formatting techniques. The user will also be exposed to more advanced charting such as secondary axis charts, combination charts, the Pie of Pie chart, and adding a trendline. Objective: Upon completion of this course the user will be…
Microsoft® Power BI: Part 1
Virtual LiveObjective: Upon successful completion of this course the user will be able to navigate the Power BI interface, explore data diagrams, model and query data. Description: This 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 will also take spreadsheet data in improper data format…
Microsoft® Excel VBA Level I: Macros
Virtual LiveMicrosoft® Excel VBA: Macros 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 principles outlined. They will also discover various ways to execute macro programs…
Microsoft® Excel VBA Level 2: Variables and Constants
Virtual LiveMicrosoft® Excel VBA: Variables and Constants will delve deeper into the core components of the Visual Basic language. The internal framework of code structure will be discussed, including objects, properties, and methods. The user will also be exposed to variable and constant declaration as well as the scope and lifetime of those variables. This course will also cover blanket methods for trapping program errors. Objective: Upon completion of this course the user will effectively construct code blocks where explicit variables…
Administrative Microsoft® Excel
Virtual LiveAdministrative Microsoft® Excel will demonstrate to the power user how to edit spreadsheets for both individual and group use. Featured topics included validating data, applying various levels of protection, sharing workbooks for collaboration, and working with formula links. The user will also be exposed to various auditing and analysis tools including features such as Goal Seek, Solver, creating Scenarios, and using the FORECAST function. Objective: Upon completion of this course the Excel power user will be able to modify worksheet…
Microsoft® Excel Advanced Formulas: Logical Functions
Virtual LiveMicrosoft® Excel Advanced Formulas: Logical Functions course will demonstrate how to use conditional formulas namely in the Logical category. In addition, aggregate functions with testing conditions will be featured. This course will also expose the user to mixed cell referencing as well as how to create array formulas. Objective: Upon completion of this course the Excel user will be able to work with logical functions, mixed cell referencing, and arrays. Featured functions include IF, OR, AND, as well as Nested…
Microsoft® Excel Tips & Tricks
Virtual LiveMicrosoft® Excel Tips & Tricks will demonstrate to the user how to use effective techniques for viewing large worksheet data, hiding data, using paste special and Go To, and using a variety of fills. This will also include how to effectively navigate through a spreadsheet using named ranges and hyperlinks, using styles, along with a deep exploration of conditional formatting. Objective: Upon completion of this course the Excel user will be able to effectively maximize their productivity by creating spreadsheets…
Microsoft® Power BI: Part 2
Virtual LiveMicrosoft® Power BI: Part 2 is designed to provide proficiency in modifying charts and graphs along with creating advanced formulas and functions. The Power BI program will involve the connection to external data sources, working with data relationships, creating calculations, and developing visualizations for analytical review. LESSON 1: ANALYZING DATA WITH VISUALIZATIONS CREATING VISUALIZATIONS Clustered Column Chart Using Data Labels Pie Charts USING MULTIPLE PAGES Stacked Bar Chart Line and Clustered Column Creating a Gauge Visualization Creating a Matrix Creating…
Microsoft® Excel Data Lists and Tables
Virtual LiveMicrosoft® Excel Data Lists and Tables will expose the user to the use of data lists and tables where both simple and complex sorting is involved. They will also work with a variety of filters and learn how to create subtotals on their data. In addition, the user will create table field formulas and use spreadsheet formulas that feature table fields. There will also be an exploration of the Database Function category where criteria can be used to create aggregate…
Microsoft® Excel PivotTables
Virtual LiveMicrosoft® Excel PivotTables will demonstrate to the Excel user how to create and use list and table data to create analytical Pivot Tables. This will include an exploration of both one and two-dimensional Pivot Tables, feature data filtering and slicers, as well as creating Pivot Charts. The user will also be exposed to using external data for Pivot analysis. Objective: Upon completion of this course the advanced Excel user will be able to create and modify Pivot Tables and Charts…
Microsoft® Excel Advanced Formulas: Lookup Functions
Virtual LiveMicrosoft® Excel Advanced Formulas: Lookup Functions will demonstrate to the user how to use formulas that extend across multiple worksheets as well as exploring the deeper function category Lookup and Reference. These will include such lookup functions as HLOOKUP and VLOOKUP, where mixed-cell referencing is featured in formulas as well as using named ranges. This course will also delve into data mining using the INDEX and MATCH functions in conjunction with each other. Objective: Upon completion of this course the…
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