• Complain

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

Here you can read online Jordan - ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2020, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

No cover
  • Book:
    ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel
  • Author:
  • Genre:
  • Year:
    2020
  • Rating:
    5 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 100
    • 1
    • 2
    • 3
    • 4
    • 5

ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Jordan: author's other books


Who wrote ECDL/ICDL Advanced Excel: A step-by-step guide to Advanced Spreadsheets using Microsoft Excel? Find out the surname, the name of the author of the book and a list of all author's works by series.

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:

Reset

Interval:

Bookmark:

Make
Advanced ICDL ECDL Sprea - photo 1
Advanced ICDL ECDL Spreadsheets Using Microsoft Excel Syllabus Version 30 - photo 2Advanced ICDL ECDL Spreadsheets Using Microsoft Excel Syllabus Version 30 - photo 3Advanced ICDL ECDL Spreadsheets Using Microsoft Excel Syllabus Version 30 - photo 4Advanced ICDL ECDL Spreadsheets Using Microsoft Excel Syllabus Version 30 - photo 5
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
Highlight cells B3 to G3 On the Home tab in the Styles group select - photo 6
  1. Highlight cells B3 to G3
  2. On the Home tab in the Styles group, select Conditional Formatting
  3. Select New Rule
Select Format Only Cells that Contain Set the Rule Description as Cell Values - photo 7
  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
Select the rule and click on the Delete Rule button Click OK The rule has been - photo 8
  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
Within the Number tab click Custom In the Type box enter Click OK The - photo 9
  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
On the Data tab in the Data Tools group select Text to Columns Choose - photo 10
  1. On the Data tab in the Data Tools group select Text to Columns
  2. Choose Delimited and click Next
Select the Comma checkbox and click Next Click Finish The text is divided - photo 11
  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
Light

Font size:

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.


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

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.