Class Details Excel Power Calculations 02/4/2020 10:00 AM PT - 2:00:00 PM PT In this course, students move beyond fundamental functions and charts. Topics include understanding how to utilize the function palette, defining advanced functions such as vlookup, payment, net workdays, taking advantage of cell and range names, how to use conditional formatting and Sparklines, how to protect data and save a chart as a template.Takeaways:Upon successful completion of this course, students will be able to:• Understand how to find and use advanced functions• Streamline formulas using cell and range names• Use conditional formatting and Sparklines in addition to charts to create dynamic visual displays of data• Protect formulas and general cell data from editing• Use special tools such as cell comments, custom views, scenartios, goal seek and track changes Instructor: Neal OttoNeal E. Otto, Jumpstart Computer Training Inc., founder and primary trainer, Neal, is a lifelong educator and learner with more than 29 years of instruction experience, with a focus on technology since 1996. Neal is known for his broad knowledge of an extensive array of software and his ability to connect with students of all abilities and styles. Certifications: Microsoft Partner, Microsoft Certified Professional, Microsoft Project Event Sponsor: NACM Commercial Services Course Level: I - Intermediate Credits: CEU: 0.400 CCE: 0.400 Location: Webinar Price: Members: $135.00 Non-Members: $175.00 *Price is for admission only. Some events, especially college credit classes, have additional costs associated with materials, such as text books. See the event comments above for more details. Membership discount eligibility is at the discretion of the event sponsor. Cancellations will be accepted for full refund no later than five working days prior to event — substitute attendees accepted up to day of event.