-
Package: Technical Applications - Excel
- WST Free Trial - Professional Development
- WST Corporate Valuation Quiz/Exam
- Capital Group - 2021 Assessment - Quizzes
- Analyst Essentials
- Analyst Essentials Pro
- Merger Modeling Basics
- Overview of Financial Markets
- Accounting for Finance
- DBS MODULE 1: FUNDAMENTAL/FOUNDATION
- WST Internal Instructors
- Advanced Excel for Data Analysis (2016 Singapore)
- Fundamentals of Financial Modeling (PKA)
- Fundamentals of Valuation Modeling (PKA)
- JPM-AM 2015 Excel Exam
- JPM-IM 2015 Valuation Exam
- Strategic Alternatives: M&A and Buyout Options
- Excel for Entrepreneurs
- Wall Street Certification Bundle
- Financial Modeling Starter Kit
- WST Professional Development
- Quizzes & Exams - WST Internal
- Keys to Success
- Oppenheimer Pre-Work Package
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Quiz/Exam for Package 1 - Finance 101
- Quizzes/Exams for Package 1
- Package 2: Core Fundamental Concepts
- Quizzes/Exams for Package 2
- USF - Corporate Valuation Methodologies
- Package 3: Advanced Financial Modeling
- Package 4: Valuation Modeling Topics
- Package 5: Merger Modeling Topics
- Package 6: Leveraged Buyout Modeling
- Package: Technical Applications - Excel
- Package: Private Company Valuation
- Package: Super-Complex M&A LBO Modeling
- Package: Distressed Financial Modeling
- Package: Bank Financial Modeling
- Package: Insurance Financial Modeling
- Package: Real Estate Development Modeling
- Package: REIT Financial Modeling
- Package: Buy-Side Series
- Overview of Financial Markets + Exhibits
- Verification
- Certification
- AIB Add-on
Advanced Excel for Data Analysis
- Data Manipulation (6 post(s))
- Switches (0 post(s))
- Regression (0 post(s))
- Data Tables (0 post(s))
- Vlookup and Match (4 post(s))
- Pivot Table (2 post(s))
- SUMIF and SUM + IF (0 post(s))
- Subtotal & Auto Filter (0 post(s))
- Row Shading (0 post(s))
- Transpose (0 post(s))
- Separating Names (0 post(s))
- Drop Boxes (0 post(s))
- Intro to Macros (2 post(s))
Last 10 posts
VLOOK and MATCH
Good afternoon. => I just finished the VLOOK and MATCH self-study module. => I want to make sure that I know how to apply them, VLOOK, MATCH and OFFSET functions, => So, I used the data provided in the course to try to display the Closing Stock Price in a descending order with corresponding Trading... Read More
Good afternoon. => I just finished the VLOOK and MATCH self-study module. => I want to make sure that I know how to apply them, VLOOK, MATCH and OFFSET functions, => So, I used the data provided in the course to try to display the Closing Stock Price in a descending order with corresponding Trading... Read More
Formatting issues when trying to use match/vlookup
hi- I have 2 sets of data and want to see if the securities in the first list are also in the second and then pull certain characteristics (isin, coupon, etc) from one to the other. I was advised to use match first and then vlookup. with the first step i have a formatting issue when using iss... Read More
hi- I have 2 sets of data and want to see if the securities in the first list are also in the second and then pull certain characteristics (isin, coupon, etc) from one to the other. I was advised to use match first and then vlookup. with the first step i have a formatting issue when using iss... Read More
Advanced Excel for Data Analysis--newer version?
Hi--I am currently doing the self study on the course Acvanced Excel for Data Analysis. I can't help but notice the videos were done in Excel 2003. Is there an updated version of the videos for 2007? I'm struggling to find some of the options/menus and follow along. I also worry I will have the same... Read More
Hi--I am currently doing the self study on the course Acvanced Excel for Data Analysis. I can't help but notice the videos were done in Excel 2003. Is there an updated version of the videos for 2007? I'm struggling to find some of the options/menus and follow along. I also worry I will have the same... Read More
Advanced Excel: Pivot Tables Error Message
I'm trying to create the Pivot Table in the Advanced Excel for Data Analysis module and am getting an error message when i'm trying to set up the layout in the PivotChart Wizard. The error is: Cannot open PivotTable source file '[AdvancedExcelDataAnalysisTemplate(1).xls]7) Pivot Table' Know ho... Read More
I'm trying to create the Pivot Table in the Advanced Excel for Data Analysis module and am getting an error message when i'm trying to set up the layout in the PivotChart Wizard. The error is: Cannot open PivotTable source file '[AdvancedExcelDataAnalysisTemplate(1).xls]7) Pivot Table' Know ho... Read More
cant find Tool in Excel 2016