Microsoft Excel 2016/2019 Online Training – Level 2 (Intermediate level)
Session Dates: Part 1: May 18 and Part 2: May 19
Session start and end times: 10AM EST – 1PM EST (9:00 AM – Noon CST)
Breaks each session: 15 minute “refresh your mind” break.
Training is instructor-led and hands-on. Seating is limited to 15 students for optimal learning.
This course is designed for students who already have foundational knowledge and skills in Excel 2016 (and lower versions), who wish to begin learning higher-level functionality in Excel to analyze, report and present data.
- Working with Excel functions
- Create and work with named ranges
- Specialized Functions
- Date and Time
- Working with Lists
- Custom Sorts and Filters
- Subtotals feature (this is NOT the AutoSum)
- Analyzing Data
- Conditional Formatting
- Visualizing Data with Charts
- Chart Basics
- Chart Types Overview
- Line Chart
- Column Chart
- Bar Chart
- Dual-Axis Charts
- Trendline Charts
- Using PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable data
- Present data with PivotCharts
- Filter data using the timelines and slicers features
About your textbook
The cost of your textbook includes a physical textbook, a digital version, and the practice files for the course. When you place your order, Logical Operations will send an email of confirmation, along with an access code and instructions on how to set up your account, which contains the digital workbook and the practice files. It’s all very easy.
Special Note: if you want to receive the physical book in time for the first session, place your order 8 business days before the first session.
A free two-hour bonus session on Formulas, which will be scheduled in June, 2020. Details coming. This training will be pulled from your textbook.
Instruction Cost: $99.00 (excludes textbook shipping charges)
Textbook Cost: $22.21 the textbook cost. The cost of includes both a digital and a physical version or your book. Textbooks are ordered by the student using the order link below. Books are published by Logical Operations. They are excellent.
Order Physical book (also includes a digital version). Cost is $22.21
Textbook Order Link. Shipping charges do apply.
Digital only (NO shipping charges apply). Your license allows you to print the digital book one time for your physical reference. The cost is $21.10.
Textbook Digital Version only. Digital Book Order Link.
Pay for the class ($99.00) using the Buy Now button below. After payment a class registration/access link will be sent to you.
After payment, you will receive a link to the event.