background preloader

Over 100 Free Excel Spreadsheets

Over 100 Free Excel Spreadsheets
Customized Templates | Financial Templates | High Quality Templates | Project Management | Able Bits | Addin Directory | Analyze It | Brush Tools | Business Rules | Custom Add Ins | Database Manager | Dashboards | Decision Analysis | Derivative Analysis | EZ Analyze | EZ Forecaster | FinCad-Derivatives | Free Economic Add On's | Free Navigation Tool Bar | Model Builder | Monte Carlo Simulation | Monte Carlo - Easy | Monte Carlo-Tukhi | NumXL | Portfolio Optimization | Risk Modeling | Sensitivity Toolkit | Simul-Stats | Spreadsheet ML | Statistical Analysis | Recover Corrupted Files | Tree Plan | Utilities | Value at Risk | XL Modeler | XL Sim | XL Stats | ASQ Tools | Baran-Systems | John Zorich | SPC for Excel | SPC XL | Robert Dallman | Six Sigma Project Files Analyzing Business Data | Balanced Scorecards in Excel | Best Practices | Business Analysis | Data Analysis | Excel Hacks | Financial Analysis | Financial Modeling | Finance with Excel | Managing Money | Spreadsheet Modeling |

Related:  Excel Stuff

Free File Renaming Utility Client Success Stories A consultant worked with the business to design a range of strategic initiatives that would help the business trade out of difficulty and communicate this effectively to the bank. ... Read more » A consultant worked with the business to design a range of strategic initiatives that would help the business trade out of difficulty and communicate this effectively to the bank. Internet Memes Timeline Trololololololololololo man Feb 28, 2010 6:00 PM Added to Youtube in November of 2009 the Video "Я очень рад, ведь я, наконец, возвращаюсь домой" had only few views until it was posted into several music blogs in march of 2010.

Using Cell Styles for Financial Modelling When developing a financial model, standards will often communicate the importance of developing a style guide to enhance the presentation and readability of a financial model for those who are external to its initial development. The use of a distinct style should help to enhance the presentation, simplify ongoing model audit, and add a level of consistency and professionalism to the overall build of the model. Standardising styles will always be a difficult, as each model developer will have his/her own preferences with regards to the various style components. However, to engage in best practice, the most important thing is to be consistent within your model stakeholders, that is ensuring consistency in approach between those who are commonly affected, or can be affected by your financial modelling. Figure 1: The Cell Style Sets that are pre-existing within Excel.

10 Websites To Get Your Drink On Most Americans are too busy with all the last minute Christmas planning (Here’s hoping you got everything from The Guy Gift Guide that you wanted!) to figure out what they would be doing as the ball dropped. This means there are really only two choices left: throw the party yourself or get on Facebook and actually read the twenty-five events you RSVP’d “maybe” to. Regardless of what you ultimately decide, don’t be the guy that shows up without something to drink because that’s serious party foul territory.

Excel Waterfall Charts (Bridge Charts) Waterfall charts are commonly used in business to show how a value changes from one state to another through a series of intermediate changes. For example, you can project next year’s profit or cash flow starting with this year’s value, and showing the up and down effects of changing costs, revenues, and other inputs. Waterfall charts are often called bridge charts, because a waterfall chart shows a bridge connecting its endpoints.

Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what I learn or discover, I write it down … here. I hope you too will discover something new you can use. Tips & Tricks for Writing CUBEVALUE Formulas - Excel Campus Imagine it’s a hot summer day and you are enjoying a nice cold drink at your favorite spot. What’s one thing that will make that drink extra refreshing? Ice cubes! Ten Useless VBA Coding Errors That Must Be Terminated - Bernard Vukas Coders have long banned Hungarian notation from their VBA modules. It’s meaningless when the code editor is slick enough to show information about a variable. But now a new crop of equally meaningless, over-used coding errors have begun to litter code modules… and these need to go, too. In my work, I frequently encounter code from other people.

New feature updates for Power Pivot in Excel 2016 We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience. Save relationship diagram view as picture How to Audit Excel Formulas Like a Pro: Tracing Precedents When I was in finance, I spent a lot of time auditing Excel workbooks. When a client would send me their budget, I would go through and make sure all the formulas were written correctly and none were missing. When my Analyst would send me a valuation model, I would do the same thing. When the balance sheet didn’t balance, it took even more time. If you’ve ever used the built-in trace precedent feature within Excel, you know it doesn’t really help that much. The reason it doesn’t help is that zooming to a precedent cell is limited only to the first cell reference in the formula.

Excel auditing tools Have more faith in the integrity of your spreadsheet models by using the Excel auditing tools available in the Spreadsheet Professional add in. Save time by using Spreadsheet Professional to audit your spreadsheets. Reviews using this tool will be 100% more efficient and effective. Variance Analysis Bibliography Albery, M. 1953. Analysis versus interpretation of cost. The Accounting Review (July): 425-430. (JSTOR link). Creating a year-over-year report using an Excel pivot table An Excel pivot table is a great tool for summarizing data, and a little-known feature lets you roll daily dates... By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.