- This event has passed.
Excel – Tips, Tricks and Traps
September 22, 2016 @ 5:30 pm - 8:00 pm$30.00
Microsoft Excel makes it easy for anyone to do number crunching once reserved for accountants and statisticians. But the world’s best-selling spreadsheet software has also contributed to the proliferation of bad math. Close to 90% of spreadsheet documents contain errors, a recent report found and suggests “Spreadsheets, even after careful development, contain errors in 1% or more of all formula cells.”
This presentation will highlight some of the exercises in Dan’s Financial Analysis Practicum course, to be offered in October-November at UCSD. It draws heavily from his manufacturing work, and will demonstrate advanced Excel functions and techniques for manipulating large amounts of data. Excel files containing more than 100,000 rows of data will be used to produce inventory and production analyses for monthly closes, operational reviews and production progress reporting. This is an opportunity for audience members to pose their own pesky challenges to see how Dan would sketch an approach to solving them.
Fasten your seat belts, it’s going to be quite a ride!.
About Our Speaker
Dinner is at 6:00 PM
Speaker starts at 7:00 PM
Entree: (Select one of the following choice the night of the event)Vegetarian Plate of sauteed wild mushrooms, squash, fennel & roasted peppers, grilled & marinated Portobello mushrooms, goat cheese spinach wonton, and pinot grigio tomato sauce
Shrimp Tacos with 6 sauteed shrimp on two soft corn tortillas, chipotle aioli, guacamole & salsa
Free Range Chicken & Spinach Pasta with fresh pascucci fettuccine tossed with parmesan pesto sauce, grilled chicken, spinach & fresh basil, topped with feta cheese & diced tomatoes
Humphreys Gourmet Burger is a Kobe beef char grilled, bacon onion compote, aged 1 yr white cheddar cheese on a soft artisan bun served with sweet potato fries
Grilled Skirt Steak Chimichurri is skirt steak, sauteed broccolini and oven roasted fingerling potatoes
Members & Students $30.00 & All Guests $40.00