Call Now+234 803 304 5484, +234 906 000 2299

Send Message[email protected]

Start Date: 27 Jan, 2025

End Date: 31 Jan, 2025

WiFiFree WiFi available

$3,000

Event Details

Participants of the Data Analysis and Visualizing using 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 analyze data, creating models for business insights within the Excel environment using scripting and automation tools and techniques.

CONTENT:

Manage workbook options and settings

  • Manage workbooks
  • Use and configure language options
  • Prepare workbooks for collaboration

Manage and format data

  • Fill cells based on existing data
  • Format and validate data
  • Apply advanced conditional formatting and filtering

Create advanced formulas and macros

  • Perform logical operations in formulas
  • Look up data by using functions
  • Use advanced date and time functions
  • Perform data analysis
  • Troubleshoot formulas
  • Create and modify simple macros

Consume and Transform Data by Using Microsoft Excel

  • Import from data sources
  • Perform data transformations
  • Cleanse data

Model Data

  • Create and optimize data models
  • Create calculated columns, measures, and tables
  • Create performance KPIs
  • Create hierarchies

Visualize Data

  • Create and modify advanced charts
  • Create and manage PivotTables
  • Create and manage PivotCharts
  • Interact with Power BI

 

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.

 

This course is available in the following locations:
Nigeria - $5500
Rwanda - $7500
UK - $8500
USA - $8500

Venue

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

Other Dates

Start Date End Date
28 Jul, 2025 01 Aug, 2025
Start Date End Date
27 Jan, 2025 31 Jan, 2025