Excel Expert Forms and Functions

Join us for this advanced Excel course to learn how to assemble complex operations simply, one step at a time.

Description

If you are experienced in Excel but need to start building more complex calculations and to build sequential operations then join us for this advanced Excel course to learn how to assemble complex operations simply, one step at a time. Also learn to manage multiple sheets or multiple books and to apply protection, navigation and form controls. 

Use advanced functions such as:

  • Information
  • Lookup and reference
  • Conditional logic
  • Conditional summary
  • Create, modify or remove a hyperlink
  • Work with shared workbooks 
  • Add protection to workbooks and worksheets
  • Consolidate data
  • Create and run macros
  • Add form controls

Sharing a single registration between two or more individuals is not permitted. Please register each person who will be in attendance.

 

Prerequisites

The course assumes that students have completed the Excel Core course or have equivalent knowledge. 

Technical Requirements

  1. Computer or laptop

    • This course will involve on-screen interaction with your instructor and classmates, reading/viewing on-screen content (slides or videos), and interacting via typing with questions or responses. For this reason, cellphones may not be adequate. 

    • Windows 10 or Mac iOS. 

  1. Webcam (Mandatory)– in order to engage and collaborate, participants will be expected to have their webcams on for the duration of the class

  2. Microphone (Mandatory)

  3. Internet connection- For best results, you will want to ensure you have an internet connection with an upload/download speed of 3-5 Mbps. You can test your internet speed here. The minimum recommended speed is 1.5 Mbps, but anything below 3 Mbps may result in loss of quality or buffering. Ideally hardwired connection versus wireless for stability - connect your computer directly to your router using an ethernet cable, rather than using your home wi-fi.

  4. A quiet space with minimal distractions –The microphone will be engaged for interactive sessions. Please plan to be fully engaged in the class and clear your work schedule just as you would for the in-class program.

  5. Comfortable chair