(MBI LIVE) Microsoft Excel Intermediate - Session 3: Conditional & Lookup Formulas
When:
- Apr 23, 2025 09:00 AM – 10:00 AM
Where:
- Online Learning - Zoom
| Fee | Type of Fee |
|---|---|
| NO CHARGE | MBI Members |
| $160.00 | Per Person - Non Members |
Presenter: David Mills, ZenTek Consultants – Hackensack, NJ
Most of us can work through Microsoft Excel basics – add a few cells together, create basic formulas, and even handle a bit of formatting and display control. When it comes to getting a smarter worksheet though, one that will handle recurring data entry with reliable results, we either push it off to our IT folks or default back to pen/paper and calculators. Wouldn’t it be nice to be able to create your own worksheets that will easily handle the work you regularly do, with just a few lines of data entry, instead of spending hours figuring out the same things again and again, by hand? Microsoft Excel is the most powerful tool in the Microsoft Office suite of products, but it’s developed a reputation for being difficult to use and understand once you move past the basics – and nothing could be farther from the truth! This intermediate-level course will show you exactly how simple Microsoft Excel can be, when you get proper training that is focused on how to use the program in the real world.
Learning Objectives:
- Linking Workbooks and Worksheets via Formulas
- Conditional Formulas & Functions
- Lookup Formulas & Functions
- Nesting Formulas
- Other Useful Formulas and Functions
Master Builder Designation: Project Management - 2 credits