Excel Course for Data Analysis, 1-Day

Description

Excel Data Course, 1-Day.

This course covers the essential Excel Data Skills. Our course is interactive, instructor led Live Virtual Classroom.
This Excel Data course is on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel.
These concepts are daily used by data analysts and is a basic essential skill for data professionals.
By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics.
You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

Location: Instructor-led, Online.
Our Style: Hands-on, Practical Course.
Group Size: Max 4 people per group.
Qualification: PCWorkshops Excel Data Certification
Hours: 1 Day, 10am-5pm

Excel Data Course, Course Outline.

Excel Data Course Description

Working with Files and Sheets within a workbook
Working with Excel sheets and files, calculating using multiple sheets or files, getting trends over sheets of files, linking files for auto-updating of values
Working with Names and Ranges, to simplify cell-referencing and copying of form
Working with Array Formulas getting a range of results (for each value in a range)

Working with Excel Tables/Database:
Working with Records and Fields
Working with Filters
Sorting Data

Conditional Formatting

Data Validation to maximise accurate user input
Finding errors and formulae to clean data (Trim, Left, Right, Iferror, Ifblank, etc), remove duplicates
Custom lists and using drop lists in cells

Excel Subtotals, Group, Outline

Cross Referencing data:
Hlookup
Vlookup
Match, Index

Excel Function wizard for statistical functions:
If,
Sumif(s), Averageif(s), Countif(s)
Dsum, Daverage, Dcount

For large dataset, organising columns, remove or add columns, filter relevant records:

Advanced Filter
Setting up criteria
Using Wildcards

Summarising and categorising data and finding trends:
Excel Pivot Tables
Create Pivot Tables
Amend Pivot Tables
Create Pivot Tables Custom Calculations
Amending calculations
Working with dates, sorting pivots,
Create Pivot Charts

Overview of Excel Charts

and Sparklines

Alternative Excel Courses

Inlcuded with the Excel Data Course

Book the Excel Data Course

About us

Our experienced trainers are award winners.