$90 – $150

Excel in Accounting 2018 Discounted 4 Class Package (1 Free Class)

Event Information

Share this event

Date and Time

Location

Location

Robert Half International

1999 Harrison St #1000

Oakland, CA 94612

View Map

Event description

Description

PICK FOUR CLASSES FROM THE LIST BELOW

Detailed descriptions for each class are below.


Sat Apr 28, 2018 Process Documentation

When it comes to Excel, repeatability is important! As accounting and finance professionals, you want to be able to re-create reports and models that you are expected to deliver on a regular basis. It is all about process documentation – documentation – documentation! You will thank yourself later.

If you have ever started a new position and were at a loss as to what your predecessor was thinking when creating reports that you are now responsible for – this session is for you!

The purpose of this class is to show you how to create clear concise instructions for creating reports.


Sat May 19, 2018 Advanced Filtering and Sorting

As accountants and finance professionals, we are often called to extract insights from a data set to inform business decisions.

Filtering is one of the most powerful Excel tools used to analyze data, enabling you to summarize and focus in only the information needed and disregard what isn’t. As with most tasks in Excel, there is more than one way to filter. This class will cover how to use various filtering tools in Excel effectively to achieve your business objective.


Sat Jun 23, 2018 Pivot Tables/Pivot Charts

As finance and accounting professionals we are often asked to pull insights from a set of business data that will inform management decision making. Pivot Tables and Charts are perfect for extracting the information you need most and presenting it in a summarized way that allows for easy interpretation and reporting.

In this class you will learn how to create and customize Pivot Tables and Pivot Charts, helping you to become the go-to person for your company’s business data analytics.


Sat Jul 28, 2018 Dashboards, Charts & Graphs

It’s been said that a picture is worth a thousand words. Charts & graphs in Excel provide a way to visually summarize numerical data. Dashboards are typically a collection of charts that allow managers to get a high-level overview of the business to help them make quick decisions. In this 2 hours tutorial, we will show you how to make professional looking charts and tips to make powerful and dynamic dashboard elements in Excel.


Sat Aug 25, 2018 Tools Tips Tricks & Traps

Experienced Excel users will share examples of common traps accountants or finance professionals may encounter and illustrate tools, tips and tricks to get around them. Quoting one of the founders of Excel in Accounting, "there are five ways to get a task done in Excel." This session, among other things, will teach you how to accomplish a task in multiple ways.


Sat Sep 29, 2018 Functions and Formulas

Excel functions are some of the most useful features of Excel. Formulas can be as simple as adding two numbers or as complex as performing high end business projections. This class will help you learn the basic skills of creating formula and using the functions in Excel to streamline the routines and to solve problems.



Sat Oct 27, 2018 Power Query

With Power Query, you can mash up large volumes of data from various sources, perform data transformations rapidly, and prepare data for further analysis. This session will cover Power Query/Get and Transform, Combining Tables, and Transforming data.



Share with friends

Date and Time

Location

Robert Half International

1999 Harrison St #1000

Oakland, CA 94612

View Map

Save This Event

Event Saved