Basic Excel Skills Learning, Power BI Ready

Basic Excel Skills Learning, Power BI Ready

Item# MS-Excel-01
Basic Microsoft Excel skills training to prepare you for Power BI training, for Enterprise Data Professional Managers. This is a necessary requirement for the EDMP-1 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. Email or call her at 360-584-8614 to discuss your excel skills.

Class Objective: To prepare you to take the EDMP-1, Power BI training. If you are already familiar with the information outlined in the training, then please go directly to EDMP-1 and register for that training.

This is a 5 hour class.

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: 1101 Connecticut Ave NW, Suite 410, Washington, DC 20036. Click here for directions and DC Metro & Parking Information & Instructions. Parking is not free at this location. It is a Central Parking location on 18th Street (a one way street). This is not a mailing address. Please to not send mail to this address
(4) Onsite in Troy MI at: SmartPath LLC: 100 W. Big Beaver Rd., Suite 200, Troy, MI 48084 (3) By Live Video Conference - from anywhere.

What to Bring to Training or Use for 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.

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 Microsoft Excel skills needed before taking EDMP-1, Power BI
• Class materials • 5 PDUs

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