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...

LIFO Inventory Valuation in Excel using Data Tables

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

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...

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...

Excel for Beginners
1. New to Excel? Start here
2. Learn Excel Interface
3. Excel Shortcuts Mega collection
4. Formatting

Learn Excel by Topic
Charting
Conditional Formatting
Data Validation / Data Tools
Excel Dashboards
Excel Tables
Filter / Slicers / Timeline
Forecast
Form Controls
Formatting
Formulas and Functions
Macros
Pivot Tables
Pivot Charts
Power Pivot
Power Query
Shortcuts
Sparklines
Worksheet Management

Excel Downloads
Ebooks
Templates

Free Excel Guides
VLOOKUP