Data Courses
Join the educational programs or training that are trending on AIDERA and align with current job market demands. These courses focus on in-demand skills and knowledge areas that are growing rapidly.
DATA ANALYSIS - CHART
Skills Hub
DATA ANALYSIS - CHART
There are many different chart types to visualise data in Excel. An area chart is similar to a line chart, but the area below the lines is filled with colours. This session covers how to create an area chart in Excel. After completing this session, you will be able to select data, create and manipulate an area chart. Learning objectives Create an area chart Compare the area chart to the line chart Change the chartÕs subtype to stacked area
- By completing this course, participants will be able to:
- Create and Customize Excel Charts
- Select appropriate chart types for various datasets.
- Build different charts such as column, bar, pie, line, area, scatter, and combination charts.
- Adjust chart elements, including colors, labels, legends, and axes.
- Manage and Analyze Data within Charts
- Add, remove, and manipulate data series.
- Switch rows and columns to restructure visual presentations.
- Utilize trendlines and error bars to enhance data analysis.
- Enhance Data Representation with Advanced Techniques
- Create chart sheets for dedicated chart views.
- Integrate sparklines to track trends in a compact format.
- Build gauge charts to track key performance indicators (KPIs).
- Optimize Charts for Clear Communication
- Modify chart settings such as axis scale, type, and labels for better readability.
- Apply formatting techniques to highlight key trends and insights.
- Use trendlines to forecast future values based on existing data.
DATA ANALYSIS - CONDITIONAL FORMATTING
Skills Hub
DATA ANALYSIS - CONDITIONAL FORMATTING
There are many quick and handy tools to visualise data in Excel. Some tools can be applied in just a few clicks. This session covers how to use colour scales to visualise data. After completing this session, you will be able to set up colour scales to automatically fill different cells with different colours depending on their values. Learning objectives Set up colour scales for a range of numeric values Adjust the number of colours used in the colour scale Remove the colour scale using the Conditional Formatting Rule Manager
- By completing this course, participants will be able to:
- Use Conditional Formatting for Data Insights
- Apply conditional formatting rules to highlight key data points automatically.
- Identify missing values between two lists.
- Detect and highlight duplicate values in large datasets.
- Manage and Customize Formatting Rules
- Apply multiple conditional formatting rules without conflicts.
- Understand how rules interact and prioritize formatting.
- View and edit existing conditional formatting rules in a worksheet.
- Enhance Data Readability and Visualization
- Create heat maps to visually represent data intensity.
- Format tables with alternating row colors for easier readability.
- Use built-in Excel tools to highlight trends and patterns quickly.
DATA ANALYSIS - FILTER
Skills Hub
DATA ANALYSIS - FILTER
Sometimes we may need to apply a complex set of criteria to filter our data. This set may consist of two or more different criteria. This session looks at how to apply an advanced filter in Excel. After completing this session, you will be able to set up and use the advanced filter to only display records satisfying complex criteria. Learning objectives Set up a criteria range and apply the advanced filter Extend the criteria range to incorporate alternative criteria Include a formula in the criteria range
- By completing this course, participants will be able to:
- Apply Advanced Filtering Techniques
- Use custom filters to display records based on multiple criteria.
- Apply text and number filters to refine datasets.
- Filter data based on specific date ranges.
- Enhance Data Management Efficiency
- Use the Data Form tool to navigate wide datasets easily.
- Outline datasets to calculate and display subtotal values.
- Identify and highlight unique values in a dataset.
- Ensure Data Accuracy and Integrity
- Detect and remove duplicate entries automatically.
- Perform calculations only on visible rows, ignoring hidden data.
- Maintain data clarity by filtering records that meet specific conditions.
DATA ANALYSIS - PIVOT FILTERS
Skills Hub
DATA ANALYSIS - PIVOT FILTERS
When working with pivot tables, it might be useful to insert a calculated field or calculated item to the pivot table. This session looks at how to add calculated fields and items to pivot tables. After completing this session, you will be able to add, modify and delete calculated fields and calculated items. Learning objectives Insert a calculated field into a pivot table Add a calculated item to a pivot table Delete calculated fields and items from a pivot table
- By completing this course, participants will be able to:
- Create and Manage Pivot Tables
- Insert and modify pivot tables for efficient data analysis.
- Update pivot tables dynamically when source data changes.
- Add multiple rows, values, and filters to customize pivot tables.
- Enhance Pivot Table Functionality
- Insert calculated fields and items to perform advanced calculations.
- Group data and dates to summarize information more effectively.
- Apply slicers to filter pivot tables with a user-friendly interface.
- Visualize Data with Pivot Charts
- Create pivot charts to represent data visually.
- Generate frequency distributions (histograms) using pivot tables.
- Customize pivot charts for better insights and presentation.
- Work with Excel Tables
- Convert data ranges into tables for better organization and analysis.
- Apply table formatting and basic data manipulations.
DATA ANALYSIS - SORT
Skills Hub
DATA ANALYSIS - SORT
Sometimes the default sort order offered in Excel does not match our requirements. In such cases, we may need to create a custom order to sort our data. This session looks at how to create a custom sort order. After completing this session, you will be able to sort data based on a custom sort order. Learning objectives Sort data using a default order Set up a custom sort order Sort data based on a custom sort order
- By completing this course, participants will be able to:
- Sort Data Efficiently
- Apply basic and advanced sorting methods.
- Sort large datasets by specific columns such as names, IDs, prices, or scores.
- Use color-based sorting to organize data visually.
- Customize Sorting Options
- Create custom sort orders when default sorting does not meet requirements.
- Sort using formulas instead of built-in Excel sort features.
- Manipulate Data Order
- Randomize (shuffle) lists in Excel without a built-in function.
- Reverse the order of a list using creative Excel techniques.
EXCEL ESSENTIALS
Skills Hub
EXCEL ESSENTIALS
"It might be critical to be able to find and replace text across the entire worksheet quickly. Excel allows us to do so in a few clicks, saving us a lot of time and effort we would spend on manual changes. This session looks at how to find and replace text in a worksheet. After completing this session, you will be able to find and replace particular text and select cells satisfying particular criteria. Learning objectives; Find individual occurrence and all occurrences of a particular text in a worksheet Replace text in a worksheet Select all cells satisfying a particular criterion "
- By completing this course, participants will be able to:
- Sort Data Efficiently
- Apply basic and advanced sorting methods.
- Sort large datasets by specific columns such as names, IDs, prices, or scores.
- Use color-based sorting to organize data visually.
- Customize Sorting Options
- Create custom sort orders when default sorting does not meet requirements.
- Sort using formulas instead of built-in Excel sort features.
- Manipulate Data Order
- Randomize (shuffle) lists in Excel without a built-in function.
- Reverse the order of a list using creative Excel techniques.
FUNCTIONS & FORMULAS IN EXCEL
Skills Hub
FUNCTIONS & FORMULAS IN EXCEL
This advanced Excel course focuses on the powerful use of array formulas to simplify complex calculations and data analysis tasks, particularly when dealing with large datasets. You will learn how to use array formulas to handle intricate calculations, such as counting unique values, handling errors, summing values with complex criteria, and finding specific patterns in data. You will also gain insights into solving real-world problems, such as identifying the most frequent word in a dataset, calculating sums for every nth row, or solving systems of linear equations. By mastering these techniques, youÕll be able to perform more efficient and sophisticated data analysis tasks in Excel.
- By the end of this course, you will be able to:
- Use array formulas to simplify complex calculations in Excel and work with large datasets more efficiently.
- Identify and count unique values in large datasets with ease.
- Count errors in a dataset and pinpoint the type of errors present.
- Apply "or" criteria in calculations, such as counting or summing data when multiple conditions are met.
- Analyze text data by finding the most frequently occurring words or phrases.
- Sum every nth row in a dataset, such as summing weekly or monthly data based on row intervals.
- Sum the largest values in a dataset using advanced array formulas to find key insights.
- Handle errors in data effectively, such as using array formulas to sum values in the presence of errors.
- Solve systems of linear equations using Excel to model and find solutions to planning and design problems.
