Details of this Class

MS EXCEL Physical Class, Advanced Excel Training & Certification
Listing ID > 01089 • MS EXCEL • posted 2 years ago

Class Type

Physical Class

Starts

Anytime

Ends

Anytime

Capacity

50

Listing Type

Free


[Advanced Excel Training & Certification] Excel spread sheets are the most powerful tool, extensively used for financial reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market if you want to be successful. This advanced Microsoft Excel training course will teach you how to use the advanced features of Excel to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros. This course is instructor led, and involves lots of examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks. At the end of this training trainees will be confident to: Create and use defined names in a workbook Work with logical function in Excel Use a variety of data validation techniques Use a range of lookup and reference functions Create summaries in your spreadsheets using subtotals Understand and create simple Pivot Tables Construct and operate Pivot Tables using some of the more advanced techniques Use the Data Consolidation feature to combine data from several workbooks into one etc.

N65,000

Instructor: Leadway

Reviews (0)

Coming soon.

Similar Classes


Our trainers are Microsoft Certified Trainers (MCT), Microsoft Certified Profess...

MORE INFORMATION

N100,000


Excel is the most widely used program in office roles and so is most common than...

MORE INFORMATION

N5,000


Pivot tables are one of Excel's most powerful features. A pivot table allows you...

MORE INFORMATION

N10,000