Excel Bootcamp
4

Saturday, 4 February

10 am – 3 pm AEDT

GA Melbourne

12A, 45 William Street
Melbourne , Australia 3000
$120 AUD
Regular Ticket
$120 AUD
Total

Questions? Read our FAQs

Excel Bootcamp

Remco Marcelis Photo


Managing Partner Standard Ledger; CoFounder Virtuosity CFO Services; General Partner Future Capital

4

Saturday, 4 February

10 am – 3 pm AEDT

GA Melbourne

12A, 45 William Street
Melbourne , Australia 3000
$120 AUD
Regular Ticket
$120 AUD
Total

Questions? Read our FAQs

About This Workshop

For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to next level and become an Excel pro.

lunch is included in the ticket price

We’ll start with the absolute basics, and move on to lesser known shortcuts, functions, features that you will be able to immediately put to use on the job. The day will be split in two:

Part One: A Practical Introduction

After a basic introduction to Excel itself, we’ll be using a dataset to take you through a process of turning raw data into useful information, and introducing you to some tools and functions along the way. Specifically, we’ll walk you through:

  • Getting to know your data: Filters, Freeze Panes, Pivot Tables
  • Cleaning your data: Text Functions (LEFT, RIGHT, SEARCH)
  • Presenting your data: Formatting, Absolute/Relative References, SUMIF, Simple Charting


Part Two: Beyond the Basics

In this part we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting and advanced functions to summarize and analyze data having multiple attributes.

  • Using some more advanced functions with your datasets
  • How to use / combine multiple spreadsheets
  • How to build charts to effectively visually present information

Prereqs & Preparation

Students should have a general familiarity with Excel, including knowing how to navigate a spreadsheet, and how to copy & paste.

Please bring a laptop with Microsoft Office installed either on PC or Mac. Note that while there may be differences in how Microsoft show certain functions in their menus across the different versions, all functions referred to in the course should be available no matter which version you are using.

The instructor will be using a Mac, running Office for Mac 2011. Students will be emailed case study files on the day of the class that they should download to their laptop. This is an interactive class, and your participation and questions are encouraged.

About the Instructor

Remco Marcelis Photo

Managing Partner Standard Ledger; CoFounder Virtuosity CFO Services; General Partner Future Capital

Remco is a Startup Accountant, virtual CFO, VC and entrepreneurial educator.

As a CPA and seasoned CFO/COO he has worked with entrepreneurial technology/cleantech businesses for the last 10 years, preceded by 4 years in venture capital and by 10 years working with multinational management consulting/IT services companies.

Passionate about growing successful sustainable businesses, Remco is interested in startups that disrupt the status quo, digital health and bitcoin’s potential in facilitating international payments.

Remco has founded Standard Ledger, along with law firm General Standards to provide the only accounting+legal firm/s dedicated to startups. He is currently the virtual CFO for a number of startup and grownup businesses, and General Partner with the Future Capital Bitcoin Fund.

As well as teaching at GA, Remco is an Adjunct Lecturer at Adelaide University Entrepreneurship Centre, Swinburne University and mentors for the global startup accelerator Founders Institute, and the School for Social Entrepreneurs.

Refund Policy

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.