# Excel

### Actual vs Target Variance Charts in Excel with floating bars

https://www.youtube.com/watch?v=E38sZY2le3g So we are making this awesome Excel variance graph, the easiest actual vs target chart with floating bars, in 5 steps under 1 minute: Excel Actual vs Target chart in 30 seconds or less! Download this...

### Vertical Actual vs Target Charts in Excel – Top to Bottom Variance Analysis using...

Charting and comparing actual with a target/budgeted results in Excel is a widely used visual business analysis technique. Variance analysis techniques range from simple numeric values to advanced charts and reports. Previously, on using Excel...

### Add a vertical line to Gantt Chart or Stacked Bar Chart in Excel –...

In last tutorial on gantt chart in Excel for project managers we learnt the simplest and fastest way to chart project activities/tasks. Today we are learning how to add a vertical line on the...

### Gantt Chart in Excel – How To + Free Template + Online Gantt Chart...

Gantt chart is the simplest-most effective visual for planners and project managers. The most favourite tool to make gantt charts is Excel for two reasons: we curate data in Excel and; Excel stacked bar...

### LIFO Inventory Valuation in Excel using Data Tables – How To

How good is it that we learn to automate cumbersome calculations in Excel like FIFO and LIFO. Last time we discussed FIFO valuation using Excel data tables and today we are doing LIFO valuation...

### Converting Dates to Quarters for Usual or Custom Fiscal Year using Excel Power Query

A while back we learnt how to convert normal to date to yearly quarters using formulas and in that we learnt different presentations. Same can be achieved with even lesser efforts using power query. Power...

### Count + Sum Cells based on Cell Colour in Excel – How To

One of the most sought after feature among heavy Excel users i.e. count or sum cells in Excel based on cell background color. I really wish we had a formula or a feature that...

### All Excel Accounting and Bookkeeping Solution – Template

Its been a while you got any update on Excel but I hope this much awaited template plus complete how to series will follow in next few weeks explaining every bit that how its done from...

### Multiple Column Data Validation Lists in Excel – How To

Today we are learning how to make dynamic multi columnar data validation lists in Excel that helps display much more data in the drop down list and are far superior and flexible than usual...

### Turn off Excel Table Formulas / Structured references

Although I absolutely LOVE Excel tables and the reason is not just 1 or 5 or 10 but more than 20 to make you awesome in Excel. And one of such reason is structured references which in simple...