Advanced Microsoft Excel Functions
1 month of Skillshare
Available with PurchaseFree
All memberships will be billed automatically on a recurring basis until canceled. If eligible for a free trial, cancel before the trial ends to avoid being charged. Offer only valid for new paid subscribers. See full terms of service here.
About this product
Training Station
Online Training Provider
Advanced Microsoft Excel Functions
Contents
Module 1: Advanced Lookup and Reference Functions
INDEX and MATCH functions
VLOOKUP and HLOOKUP functions
OFFSET function
INDIRECT function
Module 2: Advanced Financial Functions
NPV (Net Present Value) function
IRR (Internal Rate of Return) function
XNPV and XIRR functions
PMT and PPMT functions
Module 3: Advanced Statistical Functions
AVERAGEIF and AVERAGEIFS functions
COUNTIF and COUNTIFS functions
STDEV.P and STDEV.S functions
CORREL and COVARIANCE.P functions
Module 4: Advanced Text Functions
CONCATENATE and CONCAT functions
TEXT function for formatting
SUBSTITUTE and REPLACE functions
FIND and SEARCH functions
Module 5: Advanced Date and Time Functions
DATE and TIME functions
EOMONTH and NETWORKDAYS functions
DATEDIF function
TIMEVALUE and DATEVALUE functions
Module 6: Advanced Logical Functions
IFERROR and IFNA functions
AND, OR, and NOT functions
SWITCH function
CHOOSE function
Module 7: Advanced Data Analysis with PivotTables
Creating PivotTables from multiple data sources
Using calculated fields and calculated items
Slicers and Timelines for interactivity
Advanced filtering and sorting options
FAQs
What are digital products?
Digital products at Skillshare are expertly crafted tools, resources, and templates developed by top creatives that are available to you for purchase. With a wide range of resources to suit every creative need, they are actionable, making your learning experience real and unforgettable.
How can I purchase a digital product?
Anyone can purchase a digital product on Skillshare — click Buy now to enter your payment information and complete your purchase. Once payment is complete, all files will be available for download instantly from this page. You'll also receive an email with a link to download your digital product after purchase.
Is there a limit to how many times I can download a digital product?
No, there is no limit to how many times you can download a digital product. Even if a product is removed by the creator, you can still access the download page in most cases by logging in to your Skillshare account.
Can I get a refund or cancel my digital product purchase?
Digital products are non-refundable and cannot be returned or canceled. To learn more, see our refund policy in the Skillshare Help Center.
Can I make and sell my own digital products?
Absolutely! Visit How can I sell a digital product on Skillshare? to learn how you can create, list and sell your own digital products on Skillshare.