News and Resources

Excel Dasboard Course

 

[ezcol_2third]What’s New In Excel This Month- November 2015

12 November 2015 John Franco has an AMAZING offer on his Excel Interactive Dashboards Course, the offer ends real soon. Click Here! To Read More.


 

20 June 2015 New Blog Post Formula Friday Prevent The Divide By Zero In Excel#DIV/0!

12 June 2015 New Blog Post Formula Friday Formula Friday Time For A TRIM?

10 June 2015 Excel Article Published: By How To Excel At Excel How To Insert Blanks Into Every Other Row In Your Excel Data

05 June 2015 New Blog Post Formula Friday Using DATEDIF To Count The Number Of Months Between Two Dates

03 June 2015 Excel Article Published: By How To Excel At Excel – Calculating A Rolling Or Moving Average With Excel

02 June 2015- FREE Excel Tutorial On Analysing Large Data Sets. This is a FREE full length tutorial for you if you are already familiar with Excel. It is based on Excel 2013 and will introduce you to dealing with large data sets, using VLOOKUPS, Filters and Pivot Tables. It’s a great way to begin to develop some critical ways of thinking and dealing with flaws in data. It’s great fun as well and well worth working through and you will see some interesting trends in Baby Names in California, with a strange and huge rise in boys names ending in the letter ‘n’ in the 20th Century. You can see below…….

 

01 June 2015- How To Excel At Excel-New Excel Video4 Ways To Add Data To An Existing Excel Chart

01 June 2015- How To Excel At Excel-New Excel VideoExcel Formulas- COUNTIFS with Multiple Criteria

[/ezcol_2third] [ezcol_1third_end][/ezcol_1third_end]

 

[ezcol_1quarter]Tutorials

I have a tonne of great tutorials both on video for you to follow and also full articles to help you Excel at Excel. Feel free to browse them, or send a request for a video tutorial. You can also subscribe to my YOUTUBE channel and get updated when a new video is ready.

See all Tutorials

Recent Tutorials
-A FUN FAST way to learn formulas
-Use a wildcard with VLOOKUP
-Add comments to your Excel formulas
[/ezcol_1quarter]

[ezcol_1quarter]Formulas

Excel formulas can be daunting, even if you have been been using Excel for years, formulas can be scary. Text books and courses really do get complicated and take up too much time. At How To Excel at Excel I’m about working Smarter and Faster as you know. Formulas are FAB, and save so much time

See all Formula Articles

Recent Formula Articles
-Add your own macros to the Excel Ribbon
-Find and replace all line breaks in Excel
-Why you NEED to know Pivot Tables
[/ezcol_1quarter]

[ezcol_1quarter]Charting

Excel is all about the numbers, but often the best way to communicate the numbers is in a chart. If you want to learn about Excel Charting you have come to the right place. Browse our tutorials, read our articles and if you want to work along with us download example files to help you Excel at charting.

See all Charting Articles

Recent Charting Articles
-Quick paste extra data into your Excel chart
-Change your default chart type in Excel
-Create dynamic chart titles in Excel

[/ezcol_1quarter]

Excel Expert Course

Excel Dasboard Course

Popular Pages

More Info