Learn Excel IF and Then Formula - 5 Tricks you didnt know
Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. But, most of us(well, just me then..) use just about 5-6 formulas to do our jobs. And IF formulas are a majority of these, so it doesn't harm to learn a few interesting things you can do with just the excel IF functions.
Excel Webinars • My Online Training Hub
Excel webinars on-demand at no cost. Topics like Excel Dashboards, Power BI and Pivot Tables. Sample files available to download. Watch any time you like.
Making an Excel Dashboard - Tutorial #1 Copying Widgets
A quick tutorial describing the first steps of making a Excel Dashboard using the template from http://www.ExcelDashboardWidgets.com The video covers copying...
PPC Excel Tips For Every Level: Part 3, Advanced Level Keyword Research And Data Visualization
We close out our three-part series of Excel tips from Bing Ads Evangelist John Gagnon today with some advanced level tools that, in fact, even beginners
Free Payroll Template for Excel
Free Payroll Template - Download a free Excel Payroll Register template to help you track your employee payroll information, payments, and hours.
Pro tip: Accommodate changing conditions in Excel's conditional format feature
Conditional formatting adjusts formats automatically as data changes. Learn how to build in a bit of flexibility by referencing those conditions in the sheet instead of in the rule's formula.
Free Microsoft Excel Dashboard Widgets to Download
Free customizable dashboard widgets including dials, speedometers, traffic lights and thermometers for Microsoft Excel.