We can trace Microsoft Office to the beginnings of the digital age. And it has grown since then. In the past, being skillful with MS Office programs was considered an advantage and today it is compulsory to know at least how to use Excel and Word. That’s why there are tons of Excel tips and tricks on the Internet, which makes searching for helpful material very time-consuming. But don’t give up before you have started. It is just a matter of patience and time before you learn how to use Excel in everyday and business operations. To do so, you just need to know what to look for and where.
Excel Tips and Tricks – Solutions to Specific Excel Problems
If you already know how to use Excel but you are looking for specific Excel tips and tricks, these are some of the blogs that give you the best insight into what you need.
My Online Training Hub is a treasure trove of free Excel tips and tricks, and tutorials on all topics from Formulas, PivotTables, charting and dashboards.
Contextures explains how to copy numbers only in Excel, how to make an interactive dashboard chart in a drop-down list or how to compare Excel worksheet values and formulas.
The Spreadsheet Guru has a wide range of Excel tips and tricks, from basic things on how to password protect your Excel file to very advanced VBA Excel functions. Here you can learn how to make your own functions or add-ins with VBA and totally extend the Excel functionality.
Clearly and Simply explains difficult things the easy way. It helps you with data visualization and data analysis by showing you how to present data in Excel. For instance, it shows you how to create Excel choropleth maps, motion charts, animated charts like gapminder, or how to make cartograms in Tableau.
Chandoo is a true gem when speaking of advanced Excel tips. If you want to become an Excel pro, this is the right place. You can learn to apply conditional formatting, perform better data analysis by making pivot tables, write and debug advanced formulas etc.
Excel y VBA is a Spanish blog for Excel users of all levels. It provides you with Excel tips and tricks, VBA exercises and different functions examples. It also provides good tips on how to use Excel in data analysis. Continue reading