Get where you want to, quickly and easily. You can work more efficiently in Excel if you can navigate effectively. With regular practice of the methods I explain, you too can become an expert in Excel navigation!
Excel offers a huge variety of charts (also commonly called graphs) so it can be difficult to identify the most suitable type for presenting your data. Here I explain some basic guidelines which should help you pick the best type in several typical cases and some useful tips. I also give some advice on which chart types are not recommended.
You have probably experienced it… you open an Excel file and get a message that the file is linked to one or more external sources. If this was not expected, it could be that the file contains unintentional links which you may wish to review and remove. This is not always an easy task but I’ll show you how.
Large files are time-consuming to work with and prevent efficient working so it’s worth trying to get them smaller. Here I reveal my TOP TIPS which I used to quickly reduced the size of a large file by over 80%.