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
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:
Excel Function wizard for statistical functions:
Sumif(s), Averageif(s), Countif(s)
Dsum, Daverage, Dcount
For large dataset, organising columns, remove or add columns, filter relevant records:
Setting up criteria
Summarising and categorising data and finding trends:
Excel Pivot Tables
Create Pivot Tables
Amend Pivot Tables
Create Pivot Tables Custom Calculations
Working with dates, sorting pivots,
Create Pivot Charts
Overview of Excel Charts