Jordan - ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel

ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

1234567...8

ICDL /ECDL

Spreadsheets

Using Microsoft Excel

Syllabus Version 6.0

Published by: Digidiscover

Arthurstown

New Ross

Co. Wexford

E-mail: conorjordan@gmail.com

Web: www.digidiscover.com

All material contained withhin this manual is copyright Digidiscover 2020. All rights reserved. Reproduction of this manuals content is forbidden without permission from Digidiscover.

International Computer Driving Licence, ICDL, European Computer Driving Licence, ECDL are all registered Trade Marks of The International Computer Driving Licence Foundation Limited.

Microsoft, Windows, Office, Word, Excel, PowerPoint, Access and Outlook are trademarks of the Microsoft Corporation. Screenshots and names were used with permission from Microsoft.

Digidiscover is an independent company unaffiliated with Microsoft or The International Computer Driving Licence Foundation Limited.

The intent of this manual is to provide a guide to students and teachers to help them understand the current ICDL syllabus and the features associated with using the application as part of the curiculum.

Digidiscover does not guarantee students will pass their respective exams as a result of reading this manual. Its purpose is to enable students to gain a greater understanding of the application which may or may not help them achieve their desired results in exams.

Revision sections are for practice purposes only and are not official ICDL tests. Sample tests for each module can be downloaded from the ICDL website to prepare students for their exams.

Aims

The aim of this manual is to give students and teachers a clear understanding of the features and functions of Microsoft Excel required for ICDL certification. It aims to achieve this by providing a step-by-step tutorial designed to provide learners with the skills required to use the basic elements of this application.

Objectives

On completion of this manual, learners should be able to:

• Use the basic functions of Microsoft Excel
• Save spreadsheets in different formats
• Use help facilitiies, shortcuts and the go to tool
• Enter and format data in spreadsheets
• Edit columns and rows
• Use worksheets effectively
• Perform a range of calculations and functions
• Apply formatting to tables
• Create appropriate charts to represent data
• Prepare spreadsheets for printing

Downloading the Work Files

Work files associated with this manual provides the opportunity to practice the techniques outlined without having to type and format many documents saving the learner time to focus on the practical exercises. An internet connection is required to download the files. Visit www.digidiscover.com/downloads and click on the manual you are using.

Files should be saved in an ECDL folder in your Documents folder on your computer.

Contents

Section 1 - Introducing Excel

Excel is a spreadsheet application used to calculate figures and represent data visually. Information is displayed in horizontal rows and vertical columns in a worksheet. Workbooks contain several worksheets. Excel is often used for budgets, cash flows and accounting. This spreadsheet app can update figures without the user having to make repeated calculations and convey information visually in the form of charts and tables.

Opening Excel

1. Click on the Windows button
2. Scroll down through the list of applications
3. Select the Excel application

1. Select the Blank Workbook option
2. The Excel screen will appear

The Title Bar is the top line of the screen containing the spreadsheet name

On the top left of the screen is the File tab. This contains functions such as New , Open , Save , and Close

Quick Access Toolbar

The Quick Access Toolbar is located on the top left of the screen and contains functions including Save , Undo and Redo

It also has the Customise Quick Access Toolbar menu on the right that allows you to add buttons to the toolbar

Beneath the Quick Access Toolbar is the Ribbon which contains a selection of tabs which contain groups. Within each group is a number of buttons that have various functions.

Hover over a button and the name and function of it will appear which is called a ToolTip

Some buttons have a direct effect

Others are drop-down menus which provide further options:

Some buttons show a Dialog Box that requires information to be entered

Many groups have Dialog Box Launchers to the right of the group name

Locate these three buttons on the top-right hand corner of the screen:

The left button is Minimise which hides the Excel screen while still keeping it active

The middle button is Restore Down/Maximise which makes the screen smaller/larger respectively

The right button is Close which closes Excel or you can use a keyboard shortcut Ctrl+W

1. You will be prompted to Save the workbook when you try to close it
2. You have the option of Dont Save or Cancel
3. Under File Name enter Workbook
4. Select Choose a Location to save your workbook
5. Click on the Save button
6. Or use the keyboard shortcut Ctrl+S
7. To close the Excel application, click on the Close button

Default Template

There are a range of templates to choose from in Excel to create a wide variety of pre-installed spreadsheets.

Next page

1234567...8

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel»

Look at similar books to ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

24 Excel MVPs

Excel Insights: A Microsoft MVP guide to the best parts of Excel

Curtis D. Frye

Microsoft® Excel® 2010 Step by Step

Peter Bradley

EXCEL VBA: A Comprehensive, Step-By-Step Guide On Excel VBA Finance For Data Reporting And Business Analysis

Wahlberg

Excel 2022: From Basic to Advanced. The Most Exhaustive Guide to Become a Pro in Less Than 7 Days and Master All the Functions & Formulas. Includes Practical Examples and Step-by-Step Instructions

Cindy Lewis

Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Jordan

ECDL/ICDL Advanced Access: A step-by-step guide to Advanced Databases using Microsoft Access

Jordan

ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel

Baddey

EXCEL 2020 EXPLAINED: A Well-Explained Guide to Master Microsoft Excel Functions and Formulas from Beginner to Expert Level

Jordan

ICDL Word: A step-by-step guide to Word Processing using Microsoft Word

Melnyk

Excel VBA: Step by Step Guide to Learn Excel VBA Programming with Screenshots and Example Code

Suman

Excel Formulas and Functions: The Step by Step Excel Guide on how to Create Powerful Formulas

Gerard Strong

How to Use Microsoft Excel 2010

Discussion, reviews of the book ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.