at Computers Etc Software Training Center - Miramar
Fri, Jun 16, 9:00am - 4:00pm Pacific Time
2 people saved this classGive as a Gift Book as Private Event
This class is intended for:
HLookup & VLookup Functions:
Date /Time Functions:
Goal Seek allows you to calculate an unknown value in a given formula, but is only useful for problems that involve finding a single variable. When the desired result of a calculated cell is known, but not the input value that calculation needs to reach that result, you can use Goal Seek.
Solver is a tool that helps you find solutions to problems involving multiple variables.
Scenarios are part of a group of commands that can be called what-if analysis tools. A scenario is a set of values that a user can create and save and then substitute at any time in the worksheet. The user can then switch to any of these new scenarios to view different results in the worksheet. To compare several scenarios, you can create a report that summarizes them on the same page.
What-If Tables allow you to analyze data and produce a table to show the results. When a single variable like the unit price changes, use a one-input What-If Table. If the unit price AND number of units sold changes, use the two-input What-If Table.
Create Absolute and/or Relative Macros to automate common, repetitive tasks.
Add buttons, sliders, and checkboxes to a worksheet to create a "user-friendly" interface for less experienced users.
Still have questions? Ask the community.
Transfer Policy: You can transfer free-of-charge to another class provided that you give us at least 24 hours advance notice by phone or e-mail. You can also send someone else in your place. Please inform us who will attend the class.
Refund Policy: If you feel a class isn't right for you, just let the instructor know during the first break. We will issue a full-refund, transfer you to another class, or issue a full credit for the class - Your choice. You must inform the instructor during the first break!
Computers Etc Software Training Center
6920 Miramar Road Suite 206
San Diego, California 92121 Miramar
6920 Miramar Road Suite 206
San Diego, California 92121
From 805: Go east on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn left at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces. From 15: Go west on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn right at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces.
Don't see a date that works for you?Save to WishList
Get quick answers from CourseHorse and past students.
Computers Etc. was founded in 1992. We teach popular computer programs such as Access, Excel, Outlook, PowerPoint, Word, and QuickBooks. Over 25,000 students have attended our computer classes over the years. Our mission is to offer the finest computer classes at the lowest possible prices. From the...
Read more about Computers Etc Software Training Center
This school has been carefully vetted by CourseHorse and is a verified San Diego educator.
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.