Excel Uncensored: Building An App From Scratch

Top rated icon TOP RATED

5.0 | 2 reviews

Carousel cc ex un
ABOUT THIS EVENT
Event Category

Business & Technology

Event Overview

FOR THE FIRST TIME! This will be a hands-on course limited to 10-12 people.

This workshop will start a project from scratch. You will access my 15 years of experience and learn Excel by doing Excel.

We will work together to build a form that calculates the cost of a recipe while pulling data from another worksheet. We'll lock everything down to protect the formulas and data inputs.

Click here for a video preview

What will you get?
By taking on a project and being guided through it, you'll touch on a wide range of Excel features.

- Spreadsheet layout
- Dynamic VLOOKUPs
- Dynamic Dropdown Lists
- Tables
- Troubleshooting
- Creating a logical user interface
- A very simple macro
- Prevent cells from accepting nonsensical data
- Prevent users accidents
- After the workshop you will receive the 49-min step-by-step video tutorial

The app itself can be modified for any project that has a lot of pieces and costs. Then load your data and tweak the options to find the right price point.


More important than the app, you'll experience aspects of Excel that would otherwise take years to discover, and tasks that you didn't know were possible.

Get in! Get dirty! Let's rock Excel!

Prerequisites

Laptop with Excel 2007, 2010 or 2013; or Excel for Mac 2011 (No Excel 2003)
Familiarity with building basic Excel formulas.
=(C3*(A3-J3))+E3
If that makes sense to you, all shall be fine.

Before the class, everyone will be emailed a spreadsheet with the source data. Please bring that with you on your laptop.

Cancellation Policy

There are currently no upcoming dates scheduled for this Dabble. Log in to an account message the host or add to your bucket list to be automatically notified when new dates are posted.

No upcoming dates. Add to your bucket list to be notified or message host.

BRING IT BACK

MORE ABOUT YOUR HOST

Oz du Soleil

Top rated icon TOP RATED

This will be the 5th Excel course topic that Oz du Soleil has taught through Dabble.

Professionally, Oz has spent many years working with data and Excel. The result is a thorough knowledge of Excel, data management and data flow processes. Oz is also an active blogger who reminds us that we're all data managers, and data quality is the priority.

Oz lives in Logan square, loves spicy food, plays bass and spent time on a submarine during his 6 years in the Navy.

EXPERIENCE REVIEWS

  • Default user photo
    Tuya B.
    Reviewed on 05/20/13

    Hands on instruction of building an app, which involved many steps, each of which was new to me and could be applied to various aspects of my work. A very comfortable and laid back environment was created and stupid questions were most welcome.

    Hands on instruction of building an app, which involved many steps, each of which was new to me and could be applied to various aspects of my work. A very comfortable and laid back environment was created and stupid questions were most welcome.

  • Default user photo
    Mary T.
    Reviewed on 05/20/13

    The class was exactly as described. We learned the rationale for the steps of the project, how and when to use a number of important functions and, importantly, we got to practice these new skills a few times. I left with a better idea of options and uses in excel that I will use regularly in analyzing data at work. Thanks, Oz!

    The class was exactly as described. We learned the rationale for the steps of the project, how and when to use a number of important functions and, importantly, we got to practice these new skills a few times. I left with a better idea of options and uses in excel that I will use regularly in analyzing data at work. Thanks, Oz!

  • Show more

More Events From Oz du Soleil

SIMILAR EXPERIENCES

BROWSE ALL EVENTS