Calculating Cell Values with Formulas
Microsoft Excel Data Manipulation, Presentation, and Analysis,
The power and capabilities of Microsoft Excel stem primarily from the things it can do with functions and formulas. As such, learning how to implement, debug, and monitor them becomes an invaluable skill. This course, Calculating Cell Values with Formulas, aims to help you through that maze. The first three modules deal with the implementation of functions and formulas to deal with things like performing calculations with aggregate functions, performing logical and statistical operations, referencing and serializing dates and times, and looking up data in Excel. In the fourth and fifth modules, you’ll focus on troubleshooting and auditing these formulas. You'll explore techniques like tracing precedents and dependents, monitoring cells and formulas with Watch Window, etc. When you're finished with this course, you'll know how to implement and troubleshoot functions and formulas in Excel.
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 1.4 hours |
| Starts | On Demand (Start anytime) |
| Cost | $35/month (Access to entire library- free trial available) |
| From | Pluralsight |
| Instructor | Pratheerth Padman |
| Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
| Language | English |
| Subjects | IT & Networking |
| Tags | Data Professional |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Microsoft instructor $62k
Excel Reporting Developer $68k
Excel/Access DTS Developers $78k
Microsoft CSR $81k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Microsoft Access Programmer $96k
SDE in Microsoft $106k
SDE @ Microsoft 5 $110k
Microsoft Active Directory/Microsoft Exchange Administrator. $114k
Microsoft Active Directory/Microsoft Exchange Administrator. $114k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 1.4 hours |
| Starts | On Demand (Start anytime) |
| Cost | $35/month (Access to entire library- free trial available) |
| From | Pluralsight |
| Instructor | Pratheerth Padman |
| Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
| Language | English |
| Subjects | IT & Networking |
| Tags | Data Professional |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
