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

ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced 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 "ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced 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...11

Advanced ICDL /ECDL

Spreadsheets

Using Microsoft Excel

Syllabus Version 3.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, 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 advanced features and functions of Microsoft Excel required for Advanced 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 the application.

Objectives

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

• Create, edit and format charts
• Link cells, worksheets and workbooks
• Create, edit and format spreadsheet templates
• Use databases and data tables
• Create and use scenarios
• Use complex functions and formulas
• Create and use macros
• Implement auditing techniques to check for errors

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 Formatting

Apply Conditional Formatting

This applies formatting to cells depending on the value of the cells. This can be used to highlight values that are lower or higher than average e.g. when calculating profit or loss. Users can apply suitable formatting depending on the rules set for a range of cells. This makes viewing values in a spreadsheet easier.

1. Open the workbook Conditional Formatting

1. Highlight cells B3 to G3
2. On the Home tab in the Styles group, select Conditional Formatting
3. Select New Rule

1. Select Format Only Cells that Contain
2. Set the Rule Description as Cell Values less than or equal to 10000
3. Click on the Format button
4. Choose a Red colour
5. Click OK
6. Click OK again
7. Formatting has been applied to any cells with a value less than or equal to 10,000
8. On the Home tab in the Styles group, select Conditional Formatting
9. Select Manage Rules

1. Select the rule and click on the Delete Rule button
2. Click OK
3. The rule has been deleted
4. Save the worksheet as Sales

Custom Number Formats

Users of spreadsheets can determine how numbers will appear according to different formats. Custom number formats allow users to adjust how dates and time appears, whether a digit should appear in a range of cells or whether there should be a thousand or decimal separator. This is useful as if keeps the same formatting for a range of cells in a spreadsheet.

dDay number e.g. 4

mMonth e.g. 6

hhours

#Displays only digits

0Displays leading zeros

?Adds spaces either side of decimal point

,Thousands separator

.Decimal separator

Custom Number Formats

1. Open the Sales workbook
2. On the Home tab, click Format , select Format Cells

1. Within the Number tab click Custom
2. In the Type box enter ##,###
3. Click OK
4. The format of the cells will change
5. In cell B2 press Ctrl+; (Semi-Colon) to enter todays date.
6. Display the Format Cells dialog box and click the Custom category
7. Enter ddd dd mmmm yy in the Type box to create Tue 14 April 2020

Split Text to Columns

When you have text in a cell that is divided by tabs, commas, a semicolon or a space, Excel allows you to split this data into columns. This is a fast way of converting data in a spreadsheet into separate columns.

1. Open a new workbook
2. Type in the following text into cell A2

1. On the Data tab in the Data Tools group select Text to Columns
2. Choose Delimited and click Next

1. Select the Comma checkbox and click Next
2. Click Finish
3. The text is divided into columns
4. Save the workbook as Columns

Copy & Move Worksheets

It is possible to copy worksheets within a spreadsheet. This will make a copy of the worksheet and all of its content within the spreadsheet itself. A new tab will appear to mark the copied worksheet. Users can also move a worksheet to another spreadsheet. The same process can be applied to moving worksheets within a spreadsheet or to another spreadsheet.

Next page

1234567...11

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel»

Look at similar books to ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced 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.

Blake

EXCEL 2022: From Beginner to Expert

Abbey

MY EXCEL GUIDE; Beginners, Intermediate, Advanced : Microsoft Excel

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

Daniel Reyes

Excel 2021: The Step-by-Step Guide To Make You An Excel Master

Sheikh

Microsoft Excel Advanced Functions and Formulas

Jordan

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

Jordan

ECDL/ICDL Advanced PowerPoint: A step-by-step guide to Advanced Presentations using Microsoft PowerPoint

Baddey

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

Jordan

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

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

Discussion, reviews of the book ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced 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.