Online Safety Community

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

Event Details

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

Time: November 28, 2018 from 1pm to 4pm
Location: 26468 E Walker Dr, Aurora, Colorado 80016
Street: 26468 E Walker Dr, Aurora, Colorado 80016
City/Town: Aurora
Website or Map: http://bit.ly/2AVgWkU
Phone: 18883008494
Event Type: online
Organized By: Training Doyens
Latest Activity: Nov 9

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs. In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of Microsoft Excel PivotTables, you’ll be saving time and making your job easier.

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets!

You’ll learn how to create a macro the easy way by using the built-in macro recorder. You’ll then progress on to learn how to make simple changes to a macro using the built-in programming language called VBA.

WHY SHOULD YOU ATTEND

As an intermediate-level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that.

AREAS COVERED

  • Create a simple Pivot Table
  • Change the way data is calculated in a PivotTable
  • Group date data by month, year or quarter
  • Learn about slicers – the new visual way to filter PivotTables
  • Format a PivotTable report for greater appeal
  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
  • Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
  • Understand VLOOKUP
  • Calculate dates using TODAY, NOW and NETWORKDAYS
  • Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCANTENATE
  • Use IFERROR when errors can’t be avoided
  • Learn the difference between workbook macros and personal macros
  • Making your macros available to all your workbooks 
  • Use the macro recorder to create a macro
  • Save a file as a macro enabled excel workbook
  • Run a macro
  • View the recorded macro in VBA
  • Edit the macro

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

 

To Register (or) for more details please click on this below link:

http://bit.ly/2AUSYqc

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 3 Hour Excel Automation Boot Camp: Pivot Tables, Top 10 Functions & Formulas, Basics of Macros and VBA Webinar to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

HrishikeshRam posted a blog post

Hand Safety Tips

The number of workers doesn’t use their gloves when it fails to offer enough ability for the important task. Dexterity is quite crucial while performing many tasks, such as working with little parts, or when working in cramped conditions. The real issue is simply the glove – it doesn't give the required dexterity to perform these tasks, so laborers remove their gloves, making themselves vulnerable. Read more…See More
6 hours ago
Adam Fleming posted a blog post

How to Turn Your Cyber Incident Response (Plans from Blah) into Fantastic?

Let us face it. A cyber incident could happen to any organization that has a computer system that is connected to the Net. Well, the next question is, does such an organization exist? Almost no organization in today’s world, no matter of what size and which part of the world it could be in, can function without a cyber system. So, this means that simply any organization is vulnerable to a cyberattack and every organization should have a cyber incident response plan in place.The simplest way to…See More
yesterday
Traininngdotcom-LLC posted a blog post

What is Service Level Agreement and what needs to be included in a SLA?

Today's world is different from the one our previous generations grew up in. Business activities have shot up in multifold ways. As business grows, activities required to make them run grow, too. The growth of the provision of services has added a new dimension to business. When business is merely about purchasing goods from a manufacturer or distributor and selling them at the retail level; there is no implicit or explicit, written agreement per se about the transactions made between the buyer…See More
yesterday
kate smith posted a blog post

Unravelling the FMLA

The FMLA was enacted with the purpose of helping qualifying employees keep their jobs while being able to attend family exigencies. There is some misunderstanding as to its provisions, though.The Family and Medical Leave Act (FMLA), which is governed by the Wage and Hour Division (WHD) agency, is an attempt by the federal government to augment the policy of leaves for certain kinds of employees. It offers select employees of covered employers to take unpaid leave for certain purposes for…See More
yesterday

Forum

Road Safety

What can be the best measures for Road Safety?Continue

Started by Jen McDade Sep 27.

safety equipments in breweries 4 Replies

safety equipments in breweries -- kindly provide detailsContinue

Started by ajit. Last reply by Jen McDade Sep 24.

Unusual Safety Tips 10 Replies

Please share some unusual but genuine safety precautions.My unusual safety tips - Don't drink sweet fruity juice while driving in the night as it contains sugar and sugar slows down your blood…Continue

Started by Arnold Brame. Last reply by Jen McDade Sep 24.

Safety products 9 Replies

While working or at some work stations, employees are exposed to threats or at times suffer severe injuries. The safety of the employee should be the foremost priority. Safety equipment aids help in…Continue

Tags: equipments, and, products

Started by Enna Henry. Last reply by Jen McDade Sep 24.

Talend Application Integration

APPLICATION INTEGRATION:Talend ESB and Application Integration delivers agile real-time integration of applications and data.Heterogeneous Application and Data IntegrationTalend’s open source ESB…Continue

Tags: york, new, certification, training, talend

Started by nicolewells Sep 21.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service