WHAT WE’LL DO

The Microsoft Excel – Beginner to Pro course covers basic to advanced functions of Microsoft Excel

Covid-19 Update: Please bring your Mask. Courses are up to 2 people.

Part 1 – Excel general use

Creating/Managing Worksheets and Workbooks

Customizing Ribbons and Commands

Copying and Pasting

Formulas & functions

Formatting Labels and Values

Conditional Formatting

Charting

Part 2 - Data analysis in Excel

Sorting

Data forms

Subtotal command

Filtering

Pivot tables

Macros

Duration: 3 1/2 hours

Small Groups: Up to 2 people.

One-on-One Sessions or Consulting services available

I PROVIDE:

Excel files with Data Management Exercises & Answers

Class presentation

Coffee, Tea & Healthy snacks

Certificate:

Participants receive a certificate of completion.

WHAT TO BRING:

Laptop with Excel

Need a laptop with Excel? - Ask for our spare laptops with Microsoft Excel installed. (Excel Windows version)

ABOUT ME

Diego is a data & finance professional with extensive expertise using Excel by creating financial models and big data analysis. He earned this expertise working in tech, investment banking, financial planning and analysis, micro-lending, and more.

Diego is based in Toronto and provides Data Management Consulting, Live Online, and On-site Courses in Toronto

Feel free to contact me with questions at auvertdiego@gmail.com / www.proyon.ca

REVIEWS:

Banking & Finance Analyst - We covered all the basics, an overview of everything but had the opportunity to dig into the elements I might use, such as simple functions and pivot tables/charts.

Ad tech - data analyst - Diego was able to set up the data in such a way, that I can use it for many things without creating new workbooks. Pivot tables, Vlookup, Hlookup, Excel keyboard shortcuts, and ideas on how Excel is used on the business world.

Executive Assistant - Adapt to your level and speed of learning

Estimator in Interior Design - Diego was a great instructor — he gave a great overview of all excel functions but seemed to really be out to make sure we would go over those functions that would be of use to me and my work. He was patient and clear with his instructions and I was quite surprised how much we were able to cover in a short time. Would highly recommend for individual training, some groups or corporate settings.