Excel Tips and Tricks eBook

Our useful e-books provides tips and tricks in multiple volumes to improve your Excel report writing and help you use Microsoft Excel to its full potential.

It’s a handy reference guide to all our Excel on Steroids Tips and Tricks!

40 Excel Tips and Tricks Vol. 8 (9431 downloads )

Previous volumes are also available for download: Vol. 1, Vol. 2, Vol. 3, Vol. 4, Vol. 5, Vol. 6, Vol. 7.

Excel Shortcut Cheatsheet

This Free Excel Shortcut cheat sheet will allow you to:

• Learn over 60 time saving shortcuts
• Increase your efficiency in Excel
• Save you both time and money
• Work like an Excel Power user
• …and a lot more!

Once you download and start working with these Excel Shortcuts you won’t be able to imagine using Excel without it.

Excel Shortcut Cheatsheet (10261 downloads )

25 Tips & Tricks on Excel Functions and Formulas e-Book

Excel functions and formulas can save you time and make you look like an expert. However, most of us do not take full advantage of Excel functions and formulas.

Excel functions are pre-set formulas which make it easier to perform financial, logical, mathematical and many other calculations. The name of the function is what tells Excel what calculation to perform – simple!

Excel formulas are used to perform calculations. Formulas can range from basic mathematical operations – such as addition and subtraction – to complex financial reporting calculations.

25 Free Financial Functions Tips and Tricks eBook! (9538 downloads )

Excel Financial Functions Reference Guide

This Quick Reference Guide will allow you to:

• Learn 15 time saving Financial Functions
• Increase your efficiency in Excel
• Work like an Excel Power user

Excel Financial Functions Quick Reference Guide (16797 downloads )

6 Excel Tips & Tricks on Links and Data Protection eBook

Microsoft Excel offers various linking options to allow you to reference documents, locations or actions in Excel worksheets and vice versa; to link back to the worksheets. Hyperlinks in Excel can be used to open any type of file, navigate to web pages and other cells or sheets in one workbook and to send emails. Formulas, text, shapes, charts, and pictures can be hyperlinked.

Microsoft Excel also allows you to protect workbooks so that other people can open and read them without making any changes, and also protect certain parts of worksheets like formulas so that they cannot be modified.

Excel Hyperlinks & Passwords Tips & Tricks eBooks (5987 downloads )

10 Excel Shortcuts Tips & Tricks eBook

Do you spend a lot of time manually populating Excel spread sheets? There’s a shortcut for that, and for numerous other Excel functions. We’ve created an e-book of 10 useful Excel shortcuts that can save you time!

10 Excel Shortcuts Tips & Tricks eBook (6433 downloads )

15 Excel PivotTables and PivotCharts Tips & Tricks eBook

A PivotTable can help you extract more meaningful information from your data. It’s an interactive table that quickly summarizes large amounts of numeric data, which you can then analyse in detail using a PivotChart.

This useful e-book provides you with 15 tips and tricks to help you make the most of PivotTables and PivotCharts.

15 PivotTable and PivotCharts Tips and Tricks Vol. 1 (30447 downloads )

10 Excel Tips and Tricks on Page Setup and Navigation eBook

Microsoft Excel allows you to view your worksheets in different ways and provides you with various page setup options for printing.

This ebook will show you how to use the same print settings for a number of worksheets, display two worksheets at the same time, view two different versions of one worksheet, quickly navigate between many worksheets in a workbook, and use Freeze Panes to analyse a large worksheet of data amongst other tips and tricks.

10 Excel Tips and Tricks on Page Setup and Navigation eBook (6643 downloads )