Product Overview
This course is intended for anyone who has a foundational understanding of Microsoft Excel, and wants to dive deeper into some of its more advanced features and functions.
Prerequisites:
A basic knowledge of and experience with Excel and Windows, including being able to start programs, switch between programs, locate saved files, and close programs. Basic Excel skills are also required.
Note: Access to the Microsoft Excel desktop app is required for this course. It is also beneficial to have two monitors/screens, so students can follow along and test out their new skills as we go. o
Course Outline:
- Part 1: Cleaning and Formatting Data
- Data Cleanup
- Text To Columns
- Flash Fill
- Removing Duplicates
- Conditional Formatting
- Tables
- Part 2: Summarizing and Analyzing Data
- PivotTables
- Slicers
- Charts
- PivotCharts
- Part 3: Smart Functions for Work Tracking
- The IF Function
- IFS
- SUMIF and SUMIFS
- SUMIF
- SUMIFS
- IFERROR
- TODAY
- Part 4: Lookups & Automation
- Dropdown Lists
- XLOOKUP
Industry Credits
- This course is worth 1 gold seal credit.
Course Format
- Live, Online, Instructor-led training. This is a highly interactive course facilitated by the instructor on a video platform.
- You will be expected to have your webcam on during the whole class and participate in break-out rooms, small-group discussions, and other activities with your instructor and classmates during the course.
- Course access information will be provided to you in advance of the training by your instructor
- Full attendance and participation in all sessions is mandatory for course completion. If a student misses a class session, we are unable to transfer registration or provide a partial refund of the registration fees.
Course Requirements (Technology & Participation)
This course requires full face-to-face interaction and participation from both the instructor and students. In order to attend, you’ll must make sure you have the following:
- Computer or laptop with webcam (webcams are mandatory): This course will involve 100% on-screen interaction with your instructor and classmates, reading/viewing on-screen content like slides or videos, and interacting via typing with questions or responses. For this reason, you must have a webcam and use a full computer/laptop, and we do not permit students to attend using a tablet or cell phone.
- A quiet space with minimal distractions: Please plan to be fully engaged in the class, and clear your work schedule just as you would for attendance in an in-class program.
Refunds or Transfers:
- Five (5) or more business days before the course start date: Full refund of registration fees or can be transfers to a different course date.
- Less than five (5) business days before the course start date and course no-shows: No refunds or transfers to future course dates.
- For a complete document on the NRCA Education Policies, click here.
Other Policies
- Substitution of another member of your company/team is permitted up to the course start date for no additional fee.
- Unless otherwise stated, every person able to see, hear, and observe the virtual course sessions must be a paid participant. Non-compliance of this requirement will result in removal from the course. Refunds will not be issued to students who are removed from the course for non-compliance of this requirement.
- If the NRCA has to postpone or cancel courses due to insufficient enrolment, NRCA will refund the registration fee or, if possible, the attendee may choose to move to an identical session in the future.
