Course description
Excel: Large Data
During SquareOne Training's Excel Large Data course, you will learn how to harness the power of Pivot Tables in Microsoft Excel to efficiently analyse, summarise, and visualise vast amounts of data, up to one million rows or more. Perfect for anyone looking to streamline data analysis and reporting workflows in Excel.
On this course, you'll explore how Pivot Tables can help you quickly generate actionable insights, highlight key trends, and create impactful reports with just a few clicks. You'll also learn how to present your findings through easy-to-read tables and dynamic graphs, making it simple to share crucial data with management during monthly presentations.
Upcoming start dates
Suitability - Who should attend?
This course has been designed for the Manufacturing, Oil and Gas Industry or any company that would like to work with large data that has been imported from SAP or similar programs.
Training Course Content
Course Overview
- Shortcuts for Navigating Large Data
- Range Names
- Views
- Useful Formulae and Features for tidying up data
- IF Statements with Advanced Conditional Formatting
- VLookups and HLookups and ISERROR
- Text to Columns
- Concatenate Formulae
- Removing Duplicates
Advanced Sort, Filters and Advanced Filters
- Create Custom Filters
- Filter by Criteria
Excel Tables
- Create and Format Tables
- Add Formula
Pivot Tables
- Create a Pivot Table with or without Tables
- Overview of Rows, Columns, Report and Sum
- Summarise the data into different formats
- Grouping
- Slicers
- Calculated Fields and Items
- GETPIVOTDATA formulae
- Pivot Charts
Recording Simple Macros
- Overview of Recording Macros
- Playback Macros and assigning buttons
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Request info
Welcome to SquareOne Training – Where Your Learning Journey Takes Centre Stage! For over 30 transformative years, SquareOne Training has been the beacon of excellence in IT and personal skills training. We started our journey when computers were just making...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.