• (+234) 8036652501, (+234) 8187032427
  • info@ipsakng.com

Microsoft Excel Suite

Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.

You will learn how to
  1. Summarise data with Excel by incorporating formulas, formatting, and charts and graphs
  2. Optimize your worksheets using templates, graphs, and formulas
  3. Design simple to complex formulas by nesting Excel functions
  4. Import, fine-tune, and share Excel data
  5. Create, manage, and launch macros

This course is designed for students who already have foundational knowledge, skills and experience working with Excel 2013. The student will now begin taking advantage of some of the higher-level functionality in Excel such as creating macros, working with shared documents, analyzing data, and auditing worksheets.

Duration

1 week


Expand your ability to professionally present your results by applying the skills used in this course. With this training, you gain the knowledge and skills to build more sophisticated spreadsheets, perform “what-if” analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to aid in making and presenting business decisions.

 

You will learn how to
  1. Leverage features of Microsoft Excel to facilitate business decisions
  2. Develop intelligent worksheets to quickly identify KPIs
  3. Perform “what-if” analyses for developing budget and project plans
  4. Summarise and analyse large amounts of data using PivotTables and Excel features
  5. Automate Excel processes
Duration

2 Weeks


Enhance your existing knowledge of Excel with the power of macros. In this training course, you will gain experience creating, modifying, and enhancing macros to automate repetitive Excel-related tasks. You also learn how to troubleshoot code errors in existing macros, log data changes into multiple tables, implement code from the web, and design simple user interfaces to vastly improve your productivity.

 

You will learn how to
  1. Develop macros to automate repetitive workbook processes
  2. Translate statements from Visual Basic for Applications into Excel actions
  3. Debug code in the Visual Basic Editor
  4. Modify code so that it can refer to dynamic ranges
Duration

1 week

Hands-On Experience:
  1. Creating, modifying and enhancing macros
  2. Troubleshooting code errors in existing macros
  3. Logging data changes into multiples tables
  4. Implementing code from the web, and more