Spreadsheets (Excel) Levels 1, 2 & 3 Course

Product type
Level

Spreadsheets (Excel) Levels 1, 2 & 3 Course

UK Open College
Logo UK Open College

Need more information? Get more details on the site of the provider.

Description

Level 1 Syllabus Before You Start What is a Spreadsheet Program? Getting Started with Microsoft Excel Workbook Windows and Views Basic Spreadsheet Skills Using the Help System Opening, Saving and Closing Workbooks Workbook File Formats Creating New Workbooks Selecting Cells Cell Referencing Auto Sum and Auto Fill Formatting Numbers Formatting Cells Cell Alignment Cells, Rows and Columns Working with Worksheets Edit, Copy and Move Cells Proofing Workbooks Page Layout Printing and Previewing Worksheets Basic Options E-Mailing Workbooks

Level 2 Syllabus Before You Start Defined Names Sort Data and Remove Duplicates Excel Tables Chart Basics Chart Design Chart Layout Chart Format More About Cha…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Level 1 Syllabus Before You Start What is a Spreadsheet Program? Getting Started with Microsoft Excel Workbook Windows and Views Basic Spreadsheet Skills Using the Help System Opening, Saving and Closing Workbooks Workbook File Formats Creating New Workbooks Selecting Cells Cell Referencing Auto Sum and Auto Fill Formatting Numbers Formatting Cells Cell Alignment Cells, Rows and Columns Working with Worksheets Edit, Copy and Move Cells Proofing Workbooks Page Layout Printing and Previewing Worksheets Basic Options E-Mailing Workbooks

Level 2 Syllabus Before You Start Defined Names Sort Data and Remove Duplicates Excel Tables Chart Basics Chart Design Chart Layout Chart Format More About Charts Introduction to Functions Date Functions Logical Functions Information Functions Financial Functions Find and Replace Headers and Footers Adding Comments Conditional Formatting

Level 3 Syllabus Before You Start Text to Columns Paste Special Data Validation Subtotals and Grouping Consolidate Data What-if Analysis – Data Tables What-if Analysis – Scenarios What-if Analysis – Goal Seek Text Functions Lookup Functions Maths and Trig Functions Statistical Functions Database Functions Formula Auditing and Error Tracing Linking Data Hyperlinks Getting External Data Pivot Tables and Pivot Charts Protecting and Sharing Worksheets and Workbooks Workbook Properties and Inspection Encrypting and Finalising Workbooks An Introduction to Macros Illustrations, Text Boxes and WordArt Custom Number Formats Custom Lists Working with Templates Tracking Changes Compare and Merge Workbooks

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.