You are here

BECOME A DATA ANALYST WITH MICROSOFT EXCEL MASTER CLASS (WEEKDAY & WEEKEND)

Location:
Office and Spaces, Omole Phase 1, Lagos, Nigeria
Start Date:
September 15, 2018
End Date:
September 29, 2018
Time:
9:45am

Description

ECOME A DATA ANALYST WITH MICROSOFT EXCEL MASTER CLASS (WEEKDAY & WEEKEND)

Data is the crude oil for the new digital economy, learn how to analyze from scratch and get the Job you’ve always dreamt of.
Join this 4 days intensive Data Analysis master class with Excel and learn everything you need to start the journey of a data analyst or business intelligence expert.
The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.
CLICK HERE TO REGISTER NOW
MODULE 1:
Introduction to Spreadsheets In this module, you will be introduced to the use of Excel spreadsheets and various basic data functions of Excel.
Topics covered include:

Who is a data analyst
What is business intelligence.
The world of data analysis and the future.
Reading data into Excel using various formats
Basic functions in Excel, arithmetic as well as various logical functions
Formatting rows and columns
Using formulas in Excel and their copy and paste using absolute and relative referencing

MODULE 2:
Spreadsheet Functions to Organize Data This module introduces various Excel functions to organize and query data. Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel.
Topics covered include:

IF and the nested IF functions
VLOOKUP and HLOOKUP
The RANDBETWEEN function

CLICK HERE TO REGISTER NOW
MODULE 3:
Introduction to Filtering, Pivot Tables, and Charts This module introduces various data filtering capabilities of Excel.
You’ll learn how to set filters in data to selectively access data. A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel.
Topics covered include:

VLOOKUP across worksheets
Data filtering in Excel
Use of Pivot tables with categorical as well as numerical data
Introduction to the charting capability of Excel

MODULE 4:
Advanced Graphing and Charting This module explores various advanced graphing and charting techniques available in Excel. Starting with various line, bar and pie charts we introduce pivot charts, scatter plots and histograms. You will get to understand these various charts and get to build them on your own.
Topics covered include

Line, Bar and Pie charts
Pivot charts
Scatter plots
Histograms

COURSE REQUIREMENT

Laptop
Microsoft Excel Installed (If you don't have, we will install for you)
Basic surfing ability and ability to operate a PC
Absolute concentration.

FEE:     N30,000 Early Birds (Reduced from 50,000 to N30,000)
DURATION:
Weekend Session: Starts From 15/09 to 6/10 2018
Week Day Session: Starts From 24 Sept to 27 September
WHO CAN ATTEND

Fresh Graduates
Professionals
Employees
Aspiring Freelancers (You want to start working as a data analyst on Upwork, Fiverr, Freelancer etc)
Those planning to travel out of the country
Marketers
Accountants
Business Executives

OTHERS

Certificates will be awarded
Templates will be given
Tea and Lunch will be served
You will be taught how to signup on Upwork and other Freelance websites.
Join the Data Analyst professional networks

CLICK HERE TO REGISTER NOW

Organizer

Eventbrite