Advanced Microsoft Excel

Course description

Microsoft Excel is enormously powerful and flexible and has a reputation as the most widely used spreadsheet application. Very few users venture beyond the basics and therefore do not exploit the benefits of this formidable application. Advanced Level: •Use the Group feature •Protect workbooks, worksheets, cell ranges, add/remove a password •Understand, apply, modify, create styles •Use linking formulas •Understand and use data consolidation •Use advanced functions •Understand, manage and create a scenario manager