-
Package: Technical Applications - Excel
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Package 2: Core Fundamental Concepts
- 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
Package: Technical Applications - Excel
A financial analyst won't be spending all their time on Excel building financial models, but will be crunching a fair amount of data and creating charts, tables & presentations. From due diligence of analyzing salary rosters and client lists to industry analysis and reports to creating charts and graphs, you will live and breathe Excel, Word & PowerPoint and we will teach you all the best practices of the most important tools.
Courses
- Excel 2003 => 2007/2010 Transition (0 post(s))
- Excel Fundamentals for Finance Professional (18 post(s))
- Advanced Excel for Data Analysis (14 post(s))
- Excel Charting & Graphing Techniques (3 post(s))
Last 10 posts
Feedback
Captions feature does not work currently. Also, there is no way to increase/decrease playback speed. These features are common for online classes and would greatly improve quality of life.
Captions feature does not work currently. Also, there is no way to increase/decrease playback speed. These features are common for online classes and would greatly improve quality of life.
shortcuts
for some reason when i try and use the shortcuts (control alt D/m/c/x) it changes my numbers into whole numbers only. for example 1508.4 becomes $1,508 and omits the .4... why is this?
for some reason when i try and use the shortcuts (control alt D/m/c/x) it changes my numbers into whole numbers only. for example 1508.4 becomes $1,508 and omits the .4... why is this?
Formatting Using the ctrl + shift + D
For some reason every time I use the dollar formatting through the WST add in the default is no decimal places, not one decimal place. How do I change this?
For some reason every time I use the dollar formatting through the WST add in the default is no decimal places, not one decimal place. How do I change this?
Formatting Cells D26 through I26
Hi, So in comparing my unformatted workbook to the already completed formatted workboook, I noticed that cells D26 through I26 multiplied profit by the mutiple in C12 rather than C26. Should I use C12 instead when creating the scenario analysis?
Hi, So in comparing my unformatted workbook to the already completed formatted workboook, I noticed that cells D26 through I26 multiplied profit by the mutiple in C12 rather than C26. Should I use C12 instead when creating the scenario analysis?
WST Add-in
Hi, I'm using the 2015 version of excel. I installed the WST macros, but when I try and use the CtrlShiftD functions, etc. an error message pops up saying that it is an invalid procedure call or argument. Do you have idea what I am doing wrong so I can properly use these macros? Thank you!
Hi, I'm using the 2015 version of excel. I installed the WST macros, but when I try and use the CtrlShiftD functions, etc. an error message pops up saying that it is an invalid procedure call or argument. Do you have idea what I am doing wrong so I can properly use these macros? Thank you!
Format
Hi, when I do the Ctrl+shift+x formula the 0 shows up as a dash rather than as 0.0x, so I was wondering how I can change that?
Hi, when I do the Ctrl+shift+x formula the 0 shows up as a dash rather than as 0.0x, so I was wondering how I can change that?
Formating 0.0% and 0.0x in Data Manipulation
When I use macros to convert cells to dollar, money, or percent form in the data manipulation spreadsheet, I get the correct results for all cells except for the cells containing 0 for percent and multiples. For these two cells, when I apply control+shift+c or control+shift+x, I get the same dashed ... Read More
When I use macros to convert cells to dollar, money, or percent form in the data manipulation spreadsheet, I get the correct results for all cells except for the cells containing 0 for percent and multiples. For these two cells, when I apply control+shift+c or control+shift+x, I get the same dashed ... Read More
WST Add-in
Hi! I have a newer Microsoft Excel and I was wondering how to download the WST add-in? I cannot seem to find where to download it onto my computer.
Hi! I have a newer Microsoft Excel and I was wondering how to download the WST add-in? I cannot seem to find where to download it onto my computer.
Cell Format
After using the macro shortcuts, I don't get the extra decimal point with a zero. I tried formatting the cells to change it, but that doesn't work. How can I fix this?
After using the macro shortcuts, I don't get the extra decimal point with a zero. I tried formatting the cells to change it, but that doesn't work. How can I fix this?
cant find Tool in Excel 2016