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

Roger Steven posted an event
Thumbnail

Behavioral Health in the Digital Age Ethical and Risk Management Issues at Online Event

November 12, 2019 from 10am to 11am
Overview:Today's behavioral health practitioners face a wide range of challenging ethical issues related to their use of technology to serve clients.Is it ethical for practitioners to use technology to provide services remotely to clients they never meet in person? How should behavioral health professionals manage boundary issues associated with online communications with current and former clients? How should practitioners respond to "friend" requests they receive from clients on online social…See More
14 hours ago
Oliva Ella posted a blog post

How to Make Your College Life Fun?

Being a student is not that easy, you have to deal with many things and between classes, studying, assignments and daily chores; you might be wondering how you would be able to make your college life more enjoyable and funny. But making it funny completely depends on your personality and capability to manage things. Here are a few ways you can consider to manage your college life and make it happier, funnier and enjoyable.…See More
16 hours ago
fidelis meats posted a blog post

Best Dog Foods Singapore

Being the owner of a pet is not that easy, it comes with lots of responsibilities. You have to take care of your pet in terms of everything whether it is love or training or anything else. However, the most important aspect of caring our pet is to make sure that they are taking the right amount of nutrition or not and here we come into the scenario. Welcome to Fidelis Meats. We are one of the tops and leading Best dog foods Singapore who have got the highly professional industry experts who go…See More
16 hours ago
Mark Nilson posted events
16 hours ago

Forum

How to improve safety culture of factories 5 Replies

How to improve safety culture of factories having mostly contract and casual ever changing workers for whom training and monitoring both are major issues. Such qorkers are mainly meeting accidents in…Continue

Started by Harkant Dave. Last reply by Chukwuebuka Uzodimma Analikwu Sep 2.

Important of Warning sign 2 Replies

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 Chukwuebuka Uzodimma Analikwu Sep 2.

Technology and Safety 2 Replies

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 Chukwuebuka Uzodimma Analikwu Sep 2.

5 Ways to combat complacency in your Safety Program.

Complacency is a state of mind where a worker is out of touch with the hazards and risks around them. It can show up in a number of ways: over-confidence, lack of care, mindlessness, actual physical…Continue

Started by Drew stone Aug 19.

Workplace safety for workers other than your own 3 Replies

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 Paul Lancaster May 28.

Badge

Loading…

© 2019   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service