Zurich, Switzerland: +41 - 43 434 80 33   |   US: (510) 962-8903   |   support@traininng.com
Training Options
Offer Price: $916.00   Regular Price: $1,145.00

You Save: $229.00 (20%)*


Offer Price: $1,836.00   Regular Price: $2,295.00

You Save: $459.00 (20%)*

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

Instructor : Andy Lanning
Product Id : 400018

Overview: This 6 hour seminar will take you from beginner to expert in Excel, with tips and tricks and Excel expert advice along the way.

This 6 hour seminar will take you from beginner to expert in Excel, with tips and tricks and Excel expert advice along the way.

Hour 1: Productivity Tips and Tricks: Excel comes with “Some Assembly Required". You will setup and learn numerous features, buttons and tools.

Hour 2: Tools of the Trade and Every Day Excel Hacks: These are the old-school tips and tricks that have been forgotten by so many Excel users.

Hour 3: Useful Formulas: learn a handful of the most useful and often used formulas in Excel. These will include: VLookup, HLookup, IF Error, Text to Columns, Concatenate, and the power of the Name Box when creating formulas.

Hour 4: Power Query Intro: When the redundant task of 'cleaning up this week's data' comes across your desk, Power Query is the answer.  It handles the repetitious steps specifically tied to data prep.

Hour 5: Pivot Tables Crash Course: This is all about data summaries and data analysis. You will meet the Pivot Table window, learn the design process, the advanced level features (dashboard slicers), and have access to a downloadable PDF guide with step-by-step instructions on each feature covered.

Hour 6: Data Visualization Crash Course: "Data Viz" is the visual transformation of a block of data and a simple chart, to an actual message, delivered in a “publish worth” format. The focus is on the message of the chart, and the presentation of the data.
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 : 400018

Overview: No matter what Excel user-level you are now, if you are self-taught, Attend This Webinar! You'll learn that Excel comes with “Some Assembly Required” and how to get it working properly. No matter what Excel user-level you are now, if you are self-taught, Attend This Webinar! You'll learn that Excel comes with “Some Assembly Required” and how to get it working properly. You will be amazed at the numerous features that you just never knew about.  When you are busy, who has time to look around for cool tricks in Excel?  Andy Lanning brings those little nuggets to your attention in this very informative topic. 
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 : 400018

Overview: In this practical webinar, you will learn a handful of the most useful and often used formulas in Excel. In this practical webinar, you will learn a handful of the most useful and often used formulas in Excel. These will include: VLookup, HLookup, Text to Columns, Concatenate, and remove Duplicates and more!
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 : 400018

Overview: How data is presented can affect decision making, and “Yes” it is your responsibility to present data in the best manner possible. Q: Are you serious about your data… or are you decorating? A: Find out in this webinar.

How data is presented can affect decision making, and “Yes” it is your responsibility to present data in the best manner possible. Q: Are you serious about your data… or are you decorating?  A: Find out in this webinar.

This course will introduce the theory of looking at data with fresh eyes and mindset. It challenges the old-fashioned styles and rules. Data presentation will no longer look drab or ordinary, but instead, professional and interesting.

You will also Learn some technical tips and tricks, for instance, one of the best kept secrets about chart creation: How to do the work once, and use it over and over again.

Attend this webinar and you will see the difference and be proud to present your data message at the next board meeting!

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 : 400018

Overview: Pivot Tables have been a mainstay of the Excel program for two decades, and yet they remain a daunting and little understood tool.

Pivot Tables have been a mainstay of the Excel program for two decades, and yet they remain a daunting and little understood tool. If you are a daily user of Excel, then at some point you will be faced with the challenge of data summaries and analysis.

The 1st level of that process is sorting and filtering. And the 2nd level is Pivot Tables. Without them, you will be spinning your wheels trying to make sense of data.

In this crash course, Andy Lanning will take you from intro to advanced; with many tips and tricks along the way!

This course will demonstrate the Pivot Table window, the design process, the advanced level features, and also provided is a downloadable PDF guide with step-by-step instructions on each feature covered.

You will see various Pivot Table and dashboard examples in order to provide ideas on handling different projects and data sets.
Take this course and benefit from Andy Lanning’s 20+ years of experience. At the finish, you will realize how hard you have worked without Pivot Tables helping you through your projects, and soon rejoice at your new-found expertise!

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.