Excel Courses

Advanced Excel Courses For Data Analysis

Miricle Solutions presents Advanced Excel courses throughout the year. We offer custom in-house courses in addition to the structured Advanced Excel courses. The schedule for the dates is available at our site and can also be obtained directly from us. The registration forms can also be downloaded directly from our site.

The Advanced Excel courses are presented by experienced and well qualified presenters who work with the application on a daily basis in financial modelling and accounting. The courses are presented over three days and focus on aspects of data analysis. The hands-on approach ensures that delegates can strengthen their skills while help is available. The facilitator assists the delegates throughout. Anyone who works with Excel spreadsheets, large data sets, and financial reporting will benefit from attending the courses.

Since the courses are advanced, attendees must already be familiar with the basics of Excel including the opening and closing of files, moving around worksheets, inserting text and formulas, deleting cells, copying formulas, and printing.

Delegates will be able upon completion of the Advanced Excel courses to reconcile accounts, compare data lists, join databases together, locate spreadsheet errors, and identify duplicate entries and missing data.

Topics such as the following are addressed in the courses:

• Spreadsheet errors
• Spreadsheet design
• Using the auditing toolbar
• Importing data
• Using the import wizard
• Using the function wizard
• Applying the text to column tool
• Correcting date formats
• Working with dates including for instance, EDATA, YEAR and EOMONTH
• Working with imported text data
• Sorting date with RANK and DATA SORT
• Transposing
• Joining tables
• Analysing data
• Working with Speech to Text
• Reporting
• Using the Data Filter
• Doing cell formatting

Many more topics are addressed in the Advanced Excel courses. Contact us today for registration and enrolment information.