Learn best practice for dealing with your data
Excel spreadsheets are often the unsung heroes of a project, and ensuring that your data can be accurately analysed is central to using these tools effectively.
Many of us use MS Excel to record and track our data, prior to analysis. By improving your Excel Data Management skills, you can learn how to clean, collect and collate this data correctly to help you get more out of your reports and analyses.
About the course
Excel can be a highly valuable tool for storing and recording large amounts of information to help you keep track of your data. The application provides a wide range of options to display, organise and analyse this information. However, these functions and processes can be challenging to master on your own.
Excel Intermediate - Using Excel to Build & Manage your Data Sets is designed for participants with previous experience of using MS Excel, who now wish to focus on the tools within the application that can be used to prepare and structure data before analysis.
The course focuses on helping participants build a solid understanding of the best practices and standard approaches in data collection, cleaning and collation, prior to analysis, and how you can apply this to your business.
Find and Close Your Skills Gap
Get exactly what your team needs with a tailor-made Microsoft Skills course. Co-created with you to help tackle your team's unique goals and challenges.
Request a callback to find out more about our tailor-made service and to discuss co-creating training solutions for your organisation.
Course content
Course content
- Importing and cleaning Data; Using Text to Columns; Working with Text Functions; Using 'Find' and 'Replace' functions
- Data Validation; Setting Validation rules, Building drop-down lists
- Creating and working with Tables; Filters, formatting, Calculations in tables, Sub-totalling
- Security; Protecting sheets
- Sharing; Desktop vs Online (O365)
- 'Get Data'; An introduction to Power Query
Who should attend
Anyone working with lists of records and looking to enhance their ability to collect, clean and collate data prior to analysis should consider this course.
Participants should already be familiar with the basics of Microsoft Excel.
Certification
A Certificate of Attendance can be supplied in soft-copy and/or hard-copy on request
Frequently Asked Questions
Do I need to prepare anything in advance?
Participants should already be familiar with the basics of working with Microsoft Excel.
What does Live, Online training entail?
We use Zoom to run our live, interactive online sessions, and each class is secured with password access so only the registered participants can join. We ask you to keep your camera on if at all possible. You can join through any browser, or download and instal the free Zoom app from www.zoom.us
And if the course is in-person in the classroom?
In-classroom courses are paperless, so printed course notes will not be distributed to learners. Where possible we will share soft copies of notes with you ahead of the course session. However, you are welcome to use your laptop or tablet throughout the course and print notes that are shared with you by the trainer.
Let's Talk!
Contact us to find out more about any of our courses and what we can do for you.