Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

If you are looking to improve your Microsoft Excel spreadsheet and data analysis skills you may be interested in this Advanced Excel Tips & Tricks tutorial from the team over at SSIT. Mastering ...

When your spreadsheet has formulas piled on top of formulas, tracking and repairing errors would be agony if it weren’t for Excel’s Precedents and Dependents: cells that are referred to by a formula ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of functions like LEFT, RIGHT, MID, and FIND, leading to some confusing ...

If you work with data much, you don’t need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of ...

Discover 87 Excel tips and tricks that will take you from a beginner to a pro. Improve your efficiency, productivity and skills with these helpful Excel techniques. Microsoft Excel was first released ...

From students to businessmen – Microsoft Excel can be a very useful tool for all who want to create reports, charts, tables and so on. When someone needs to create a chart using a free tool, Microsoft ...