Online Safety Community

Webinar Training on 3 Hour Excel Automation Boot Camp: Pivot Tables, Top 10 Functions & Formulas, Basics of Macros and VBA

Event Details

Webinar Training on 3 Hour Excel Automation Boot Camp: Pivot Tables, Top 10 Functions & Formulas, Basics of Macros and VBA

Time: January 31, 2019 from 1pm to 4pm
Location: Training Doyens 26468 E Walker Dr,Aurora, Colorado
Street: Training Doyens 26468 E Walker Dr,Aurora, Colorado
City/Town: Aurora
Phone: +1-720-996-1616
Event Type: online
Organized By: Training Doyens
Latest Activity: Jan 22

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

Excel functions can greatly enhance your ability to perform tasks in day to day activities, and produce meaningful, impactful and insightful reports in the shortest time possible. Our upcoming boot camp discusses advance tips and techniques for Pivot Tables, Excel formulas and Macros.
The boot camp covers the following key areas:
• Creating and formatting Pivot Tables
• Using IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
• Difference between workbook macros and personal macros

LEARNING OBJECTIVES

This Microsoft Excel training session covers THREE advanced features of Excel that provide automation within the application.
Microsoft Excel Pivot Tables make building reports a breeze. You will be introduced to the basic task of building, formatting and refreshing PivotTables.
Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what are considered the top 10 functions.
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.

WHO WILL BENEFIT

This session is aimed at Excel users who have intermediate level knowledge and who wish to take their knowledge and understanding of the application to the next level.
Business Owners
CEO's / CFO's / CTO's
Managers
Accountants
CPA's
Financial Consultants
IT Professionals
Auditors
Human Resource Personnel
Bookkeepers
Marketers
Anybody with large amounts of Data
Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

SPEAKER

Cathy Horwitz is an independent consultant specializing in Microsoft Office instruction. She has over 30 years of experience as a Microsoft Office instructor.


To Register (or) for more details please click on this below link:
http://bit.ly/2RTyEyL
Email: support@trainingdoyens.com
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882

Comment Wall

Comment

RSVP for Webinar Training on 3 Hour Excel Automation Boot Camp: Pivot Tables, Top 10 Functions & Formulas, Basics of Macros and VBA to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

Mark Nilson posted events
yesterday
Roger Steven posted events
yesterday
Training Doyens posted events
yesterday
Adam Fleming posted a blog post

INFRARED SPECTROSCOPY Is Crucial to Your Business. Learn Why!

Near-Infrared Spectroscopy, NIR or NIRS, is considered a superior method assay to traditional ones, which are destructive and also reduce the number of doses for sale. It overcomes these drawbacks by being both rapid and nondestructive, which helps it respond to the pressures in the pharma industry for generating more and more data, which leads to more assays that bring these inevitable downsides.In being responsive to the physical and chemical environment of…See More
Thursday

Forum

Workplace safety for workers other than your own 1 Reply

Do your workplace/traffic safety plans include safety measures for workers who are not your own employees? Do they take into account the safety of those who will be - or could be - at your workplace,…Continue

Tags: emt, paramedics, emergency, occupational, health

Started by John Petropoulos Memorial Fund. Last reply by Jen McDade on Thursday.

What % of Dollars should be bugeted for All Safety Training for a "Heavy Equipment Road Construction" company with 100 employees? 1 Reply

I have been at a Highway and Road Construction company for six months. I am developing a (first) complete training program. I am the 1st full time safety hire for this company. I need to develop a…Continue

Started by JTurpening. Last reply by Jen McDade on Tuesday.

Technology and Safety 1 Reply

What are the most useful tools to have at your fingertips? -Toolbox Talks-JSA-JHA-Daily Reports, etc. What is falling through the cracks that could be an easy fix? Safety Managers, Coordinators and…Continue

Tags: safety

Started by Drew stone. Last reply by Jen McDade Feb 15.

Important of Warning sign 1 Reply

Warning sign is a type of traffic sign that guide a hazard ahead on the road. Having proper warning sign on the road provide a healthy environment.Continue

Tags: Signs, Workplace, Safety, Sign, Warning

Started by healthandsafetysigns. Last reply by Jen McDade Jan 14.

Workers paticipation in safety management 2 Replies

Workers paticipation in safety management is the aspect which is required to be implemented in the OHSAS 18001 2007 version. , I invite our experience community members to share their views on the…Continue

Tags: management, safety, in, paticipation, Workers

Started by SafetyRaja. Last reply by Tara safe Dec 27, 2018.

Badge

Loading…

© 2019   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service