Sorting, Checking & Importing Data in MS Excel

Overview:

This is a comprehensive CPD course designed to build confidence in managing data integrity and efficiency within Excel. The course walks participants through practical tools such as formula auditing, error checking, spell check, find and replace, and filtering. Learners also explore sorting and subtotaling data, linking and embedding content, and transferring data across different file formats. By the end of the course, users will be proficient in identifying and correcting spreadsheet issues, importing/exporting data accurately, and preparing Excel workbooks for professional use across multiple platforms.

Course Content:

In this course, you will gain knowledge about the following topics:

• Formula Checking and Auditing
• Spell Check and Find & Replace
• Sorting and Filtering Data
• Using Subtotals
• Linking and Embedding Content
• Importing and Exporting Data

Learning Objectives:

Upon completing this course, you should be able to:

• Check and correct formulas using Excel’s error checking tools, trace precedents/dependents, and circular reference detection
• Sort data using basic and custom sort levels, and apply multiple filters based on values, text, and dates
• Use tools such as find and replace, spell check, and subtotals to prepare cleaner, error-free data sets
• Link, embed, and paste data between Excel and other software such as MS Word using paste special and screenshots
• Import and export Excel data in different file formats including CSV and TXT, and understand file extensions and compatibility
• Use What-If Analysis tools such as scenario manager, goal seek, and data tables to support planning and forecasting

Who Will Benefit:

• Accountants and Finance Professionals
• Administrative Staff and Data Entry Professionals
• Auditors and Analysts
• Business Users and Office Managers