MS Excel

At the end of this workshop, you will be able to: Create advanced charts Add trendlines to charts Create dual-axis charts Save a chart as… Read More »Create advanced charts and tables

At the end of this workshop, you will be able to” Apply functions in formulas Perform logical operations by using AND, OR and NOT functions… Read More »Create advanced formulas

After completing this workshop, you will be able to: Apply custom data formats and validation Create custom number formats Populate cells by using advanced Fill… Read More »Apply custom data formats and layouts

After completing this workshop, you will be able to: Manage workbooks Save a workbook as a template Copy macros between workbooks Reference data in another… Read More »Manage workbook options and settings

After completing this workshop, you will be able to: Create charts Create a new chart Add additional data series Switch between rows and columns in… Read More »Create charts and objects

After this workshop, you will be able to: Summarise data by using functions Insert references Perform calculations by using the SUM function Perform calculations by… Read More »Perform operations with formulas and functions

After completing this workshop, you will be able to: Create and manage tables Create an Excel table from a cell range Convert a table to… Read More »Create tables

At the end of this workshop, you will be able to: Insert data in cells and ranges Replace data Cut, copy or paste data Paste… Read More »Manage data cells and ranges

At the end of this workshop, you will be able to: Create a worksheets and workbooks Create a workbook Import data from a delimited text… Read More »Create worksheets and workbooks