Basic Excel Skills Learning, Power BI Ready
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 neredahaque@smartpathllc.com 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 charts 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.
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 charts 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.
