Improve you Microsoft Excel skills by visiting our free training pages where tips are shared and where you can watch step by step videos on using the various functions. You can further improve your Microsoft Excel skills within two or three days by attending one of our advanced courses where you will receive hands-on training.
The advanced spreadsheet techniques course runs over two days and starts with useful tips to help you work more efficiently in spreadsheets. As part of the advanced Microsoft Excel skills enhancement you will also learn to identify and protect important data in spreadsheets. In addition you will learn more about the naming of cells and working with ranges as well as formulas.
Learn how to create specific formats and get practical experience in conditional formatting. Also master data validation and become skilled in creating drop-down lists. Apart from the above attendees get the chance to work with multiple sheets. Other skills taught include that of using hyperlinks, working with the IF, AND as well as OR operators.
SUMIF and COUNTIF need not get the better of you as you will quickly grasp the basics of using them through the practical course. Other areas where people often struggle such as the databases and pivot table reports are also dealt with on the first day of the course.
The second day will be just as exciting with new knowledge gained about Lookups which will be drilled in through practical exercises. You will learn how to create a data table, to use masks, outline and how to work with string functions, to name but a few of the important Microsoft Excel skills which will be taught on day two. Book your seat now and avoid disappointment.