Welcome to project management certification, PMP, Program Management, Agile, Business Analysis, Professional Scheduling and other related training

Basic Excel Skills Learning (For Microsoft Excel) as a Pre-Requisite Class to EDMP-1, Power BI

Item# MS-Excel-01
2018 to 2019 Training for Basic Excel, current version - this class is pre-requisite for EDMP-1 (Power BI) certification training to learn basic Microsoft Excel prior to training. Lab exercises will be provided in the classroom. This class aligns to Microsoft certification #77-420 but does not prepare you for that exam. This class is only available for EDMP-1 trainees as it's focused on what you need to know for Power BI. A great class for your trainees. We can do at onsite at your place also in WA or MI. this class is available, if needed, prior to taking EDMP-1: 


Basic Excel skills training. This is a necessary requirement for the EDMP-1 certification training or if you wish to learn basic Microsoft Excel. This class aligns to Microsoft certification #77-420 but does not prepare you for that exam. This class is not needed if you have a good usable knowledge of Excel. We will list make it available only if you need it and you are doing EDMP-1. Email neredahaque@smartpathllc.com or call her at 360-584-8614 to discuss your excel skills.

This is a 5 hour class.

$345.00 shown as the total price.

Locations & Methods of Training
1) Onsite in Bellevue, WA - SmartPath LLC - 2018 156th Ave NE, Bellevue, WA 98007. Parking is free at this Bellevue location. Bellevue, WA is in the Great Seattle Metropolitan area in Northern Washington State.
2) Onsite in Washington, DC: SmartPath LLC, 1050 Connecticut Ave NW, Floor 5, Suite 500, Washington, DC 20036. Click here for directions and DC Metro & Parking Information & Instructions. Parking is not free at this location. (3) By Live Video Conference - you will be sent instructions after your purchase has been completed.

What to Bring to Training :
(1) Your laptop with Microsoft Excel for Onsite Training or a Desktop or laptop with Microsoft Excel for Live Video Conference Training. If you don't have it on your computer, you can download it a day or two class - get the free trial period.
(2) Notebook and pen

How to purchase training:
Classes are guaranteed to run at the time of purchase or registration so register or purchase early if you wish to save the class dates. You may pay with debit cards, credit cards or PayPal. If the class is showing it is still available for you to join, although it may be necessary to register at least 3 - 6 weeks before the first day of class to get a seat. Onsite seats at SmartPath LLC in Bellevue WA are limited to 9 people, and in Washington DC, the class is limited to 7 people.

Class Objectives
Learn Basic Excel – the following knowledge is essential to have prior to EDMP-1 Certification Training.

Basic Excel Training

The Foundation
• Creating a New Workbook
• Navigating in Excel
• Moving the Cell Pointer
• Using Excel Menus
• Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
• Entering Values in a Worksheet and Selecting a Cell Range
• Previewing and Printing a Worksheet
• Saving a Workbook & Re-opening a saved workbook

Formatting a Worksheet
• Creating Headers, Footers, and Page Numbers
• Adjusting Page Margins and Orientation
• Adding Print Titles and Gridlines, rows to repeat at top of each page
• Formatting Fonts & Values
• Adjusting Row Height and Column Width
• Changing Cell Alignment
• Adding Borders
• Applying Colors and Patterns
• Using AutoFormat
• Merging Cells, Rotating Text, and using AutoFit
• Using AutoFill

Managing workbooks
• Switching Between Sheets in a Workbook
• Inserting and Deleting Worksheets
• Renaming and Moving Worksheets
• Protecting a Workbook
• Hiding Columns, Rows and Sheets
• Splitting and Freezing a Window
• Inserting Page Breaks

Working with the Forms Menu
• Sorting, Subtotaling & Filtering Data
• Copy & Paste Filtered Records
• Using Data Validation
• Creating & Working with Charts
• Creating a Chart
• Moving and Resizing a Chart
• Formatting and Editing Objects in a Chart
• Changing a Chart's Source Data
• Changing a Chart Type and Working with Pie Charts
• Adding Titles, Gridlines, and a Data Table Formatting a Data Series and Chart Axis
• Annotating a Chart
• Working with 3-D Charts
• Selecting and Saving a Custom Chart
• Using Fill Effects
• Mapping Data
• Modifying a Map
• Data Analysis & Pivot Tables
• Creating a PivotTable
• Specifying the Data a PivotTable Analyzes
• Changing a PivotTable's Calculation
• Selecting What Appears in a PivotTable
• Grouping Dates in a PivotTable
• Updating a PivotTable
• Formatting and Charting a PivotTable

Working with Tables
• Creating a table
• Entering data in a table
• Formatting a table
• Totaling data in a table
• Sorting data in a table
• Sorting data in a table
• Sorting multiple columns
• Filtering data using auto filters

Working with charts
• Creating a chart
• Moving a chart
• Resizing a chart
• Changing layout and style
• Labeling chart elements
• Formatting chart text
• Changing the chart type
• Changing the chart’s source data

What You Will Receive
• 5 hours of training in basic excel skills
• Class materials • 5 PDUs

If you are doing this class, check with us for the PDU triangle breakdown.

* "Provider is a member of PMI's R.E.P. Program and PMI does not specifically endorse, approve, or warrant R.E.Ps products, courses, publications or services."

PMI, the Registered Education Provider logo, PMP, PgMP, PfMP, CAPM, PMI-ACP, PMI-PBA, the PMI logo, and PMBOK are marks of the Project Management Institute, Inc.