Excel Spreadsheet Training

Excel Spreadsheet Training For Beginners

One of the most sought after skills for any office worker is that of spreadsheet knowledge. Unfortunately most people don’t have the time to attend a long course on Excel and as such learn through trial and error. The solution is Excel spreadsheet training through short one to four day courses.

Miricle Solutions offers beginner Excel spreadsheet training as a two day course from where delegates upon completion of the course, will immediately be able to apply the knowledge in their day to day usage of the program. Once they understand the basics and essential principles of Excel they will be able to save time by completing tasks in the spreadsheet environment quicker and more accurately.

Many office workers do repetitive tasks which take time simply because they have not yet mastered some of the essential tools and applications of Excel. Once they know how to use such they will for instance, be able to create custom lists, use the fill tool to complete entries instead of typing lists of column headings and will be able to use the paste special function to past values or complete formulas.

The beginner’s course on Excel spreadsheet training starts from the very basic ensuring correct building blocks of knowledge. The lay-out, saving and opening of Excel files, renaming and copying or moving of spreadsheets in a workbook, navigation and data entries as well as usage of the format painter are taught.

Other essential outcomes taught as part of the basic Excel spreadsheet training include that of:

• Working with borders.
• Alignment of cells.
• Inserting, deleting, hiding, and un-hiding as well as setting of column/row widths and heights.
• Using the function wizard
• Basic math formulas such as minimum, maximum, count, plus, minus, multiply, and divide.
• Cell referencing including absolute and relative referencing.
• Linking cells in sheets and workbooks
• Creating graphs
• Working with filters
• Understanding the auditing toolbar
• Usage of the IF function
• Sorting data
• Printing spreadsheets, selections and entire workbooks.