Creating Spreadsheets with Microsoft Excel

  • Start Date

    31 May, 2022

  • End Date

    03 Jun, 2022

  • Price

    ₦250,000

  • WiFi

    Free wifi

Event Details

Participants of the Creating Spreadsheets with Microsoft Excel workshop gain hands-on skills to manipulate their business data using the leading spreadsheet tool in industry Microsoft Excel. Participants will also learn to customize the Excel environment, populate, sort, secure and share data within workbooks and documents while using scripting and automation tools and techniques.

CONTENT

Manage worksheets and workbooks

  • Create worksheets and workbooks
  • Import data into workbooks
  • Navigate within workbooks
  • Format worksheets and workbooks
  • Customize options and views
  • Configure content for collaboration

Manage data cells and ranges

  • Manipulate data in worksheets
  • Format cells and ranges
  • Define and reference named ranges
  • Summarize data visually

Manage tables and table data

  • Create and format tables
  • Modify tables
  • Filter and sort table data

Perform operations by using formulas and functions

  • Insert references
  • Calculate and transform data
  • Format and modify text

Manage charts

  • Create charts
  • Modify charts
  • Format charts

 

FOR WHOM: Auditors, Computer Executives, Internal Control Officers, CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals, and Security department managers who form part of the contingency planning or review team.

 

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

 

DATE:

1ST BATCH: 31st May – 3rd June, 2022    

2ND BATCH: 15th – 18th Nov, 2022  

Other Dates

Start Date End Date
15 Nov, 2022 18 Nov, 2022
Start Date End Date
31 May, 2022 03 Jun, 2022
  • Venue

    Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Share this course