ICDL Workforce modules - Office Applications - Spreadsheets

The Spreadsheet is intelligent software that typically has many sheets with thousands of rows and columns. The main purpose of a spreadsheet is to allow a user to record and analyze data in a tabular format. These spreadsheets have made accounting and other calculations easier with their built-in formulae. All you have to do is enter data, choose a row for your answer and select the formula that you want to apply. Advanced spreadsheets allow users to enter their own formulae to scale its functions. We can also compare the data entered and produce an analysis report with a variety of graphs and charts. A spreadsheet is capable of much more functionalities that make it one of the best tools for an organization. This software is especially useful for data analysts and accountants.

Skill Set

Edit, Sort

Category

Prepare Outputs

Skill Set

Task Item

Change worksheet margins: top, bottom, left, right

Change worksheet orientation: portrait, landscape. Change paper size

Adjust page setup to fit worksheet contents on a specified number of pages

Add, edit, delete text in headers, footers in a worksheet

Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers

To have all lessons sent directly to your email click here: Training Courses For All