Zurich, Switzerland: +41 - 43 434 80 33   |   US: (510) 954-3145   |   support@traininng.com
Training Options
Offer Price: US$815.00   Regular Price: US$1,020.00

You Save: US$205.00 (20%)*


Offer Price: US$1,480.00   Regular Price: US$1,850.00

You Save: US$370.00 (20%)*

Webinar Packs Access recorded version unlimited viewing for 6 months.
(For Customize Webinar Packs Please Call Customer Care)

Instructor : Cathy Horwitz
Product Id : 400026

Overview: Attendees will create and edit basic mathematical formulas. Attendees will create and edit basic mathematical formulas.  You will build formulas in Excel with function autocomplete or by typing them manually, while learning essential functions like SUM, MIN, MAX, AVERAGE and COUNT.  You will also learn the difference between relative and absolute cell references as well as learning how to copy and paste formulas in Excel and apply autofill options.
Cathy Horwitz believes that when you know the capabilities of the software you use, you will demonstrate improved productivity, will be more efficient and will be able to problem solve more easily.

Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access and Outlook. Cathy has over 30 years of experience in classroom and virtual training and has been an instructor of Microsoft Office since its inception.

Her strengths include customizing classes based on the needs of individual students and providing realistic business examples to compliment training. She is a high energy trainer with a flair for training the adult student.

She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches.

When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing mid-century furniture.
Instructor : Andy Lanning
Product Id : 400026

Overview: Are you a self-taught Excel user, and you like to mix it up and venture into advanced features and formulas, occasionally getting stuck along the way? Are you a self-taught Excel user, and you like to mix it up and venture into advanced features and formulas, occasionally getting stuck along the way?

This seminar is perfect for you!  We will show you the latest innovations in data clean-up, data analysis, and data presentation.

You'll be learning from a 25+ year Excel Certified Expert, who shares amazing tips and tricks from beginner to advanced.
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC. Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S. Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered hundreds of courses and webinars on a variety of Microsoft topics.
Instructor : Andy Lanning
Product Id : 400026

Overview: Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendee by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed. Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendee by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed. And in this seminar, we have time to move into more advanced formula features.

Plus, have you ever wished someone would just tell you what you didn't know about Excel? It is amazing what has been around the program since the beginning, and we will reintroduce some of those features in this seminar.
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC. Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S. Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered hundreds of courses and webinars on a variety of Microsoft topics.
Instructor : Cathy Horwitz
Product Id : 400026

Overview: This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application.

LEARNING OBJECTIVES

This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application.

Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what is considered the top 10 functions.

Lookup functions in Excel are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX, and MATCH are some of the most well-known (and most useful) functions in Excel.

Being able to create and edit macros is one of the must-have skills for Excel Power Users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. If you’ve never created macros or used VBA before, this advanced Excel training is for you.

Cathy Horwitz believes that when you know the capabilities of the software you use, you will demonstrate improved productivity, will be more efficient and will be able to problem solve more easily.

Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access and Outlook. Cathy has over 30 years of experience in classroom and virtual training and has been an instructor of Microsoft Office since its inception.

Her strengths include customizing classes based on the needs of individual students and providing realistic business examples to compliment training. She is a high energy trainer with a flair for training the adult student.

She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches.

When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing mid-century furniture.