Excel Courses – LearnOnline

About the Course

In this interactive course you will learn cell selection techniques, how to move and copy data, add and remove cells. You will also search and sort data, format cells and work with multiple worksheets.

There are 6 modules in this course:

Worksheet Cells Cell Selection Techniques

• Select a Cell;

• Select Ranges of Cells;

• Select Ranges of Cells;

• Select Rows;

• De-select Cells;

• Select Data Ranges;

• Select the Entire Worksheet.

Moving and Copying Data

• Understand Cut and Copy;

• Move Data in Worksheets;

• Move Data Between Worksheets;

• Move Data Between Workbooks;

• Use the Paste Options Smart Tag;

• Copy Data in Worksheets;

• Copy Data Between Worksheets;

• Copy Data Between Workbooks;

• Use the Office Clipboard

Adding and Removing Cells

• Insert Columns and Rows;

• Delete Columns and Rows;

• Insert Cells;

• Delete Cells;

• Adjust Column Widths;

• Change Row Heights;

• Use Undo;

• Use Redo;

• Delete Cell Content

Searching and Sorting Data

• Use Find and Replace;

• Search for Words;

• Identify Search Options;

• Use Find Next;

• Replace Single Occurrences;

• Use Replace All;

• Sort Data in Columns

Formatting and Multiple Worksheets

• Change Numeric Formatting;

• Modify Fonts and Sizes;

• Centre Text Across Columns;

• Align Data in Cells;

• Wrap Cell Text;

• Add Borders;

• Apply Text Attributes;

• Change Background Colours;

• Use Format Painter;

• Change Date Formatting;

• Clear Data and Formatting

Using Multiple Worksheets

• Use Multiple Worksheets:

• Delete Worksheets;

• Insert Worksheets;

• Move Worksheets;

• Copy Worksheets;

• Rename Worksheet Tabs;

• Apply Colours to Tabs

About the Course

In this interactive course you will learn how to use Excel views, and import and export files. You will also insert hyperlinks, add workbook properties, add headers, use Page Setup and the Print Place.

There are 7 modules in this course:

Excel Views

• Hide the Ribbon
• Use Full Screen View
• Open Page Layout View
• Set Margins
• Add Headers and Footers
• Scale Worksheets
• Open Print Preview
• Use Page Break Preview
• Insert, Move, and Remove Page Breaks

Custom Views

• Define Custom Views
• Add Custom Views
• Hide Rows for Custom View
• Set a Print Area
• Apply Custom Views

Importing, Forms and Exporting

• Import Files into Excel
• Use the Text Import Wizard
• Save Imported Files in Excel Format
• Import Files Using Drag and Drop
• Use and Navigate Forms
• Delete Form Records
• Add New Records
• Search Form Records
• Export Files in Other Formats

Working with Hyperlinks

• Identify the Function of Hyperlinks
• Create Hyperlinks
• Activate Hyperlinks
• Edit Hyperlinks
• Create Web Hyperlinks
• Select Hyperlinked Cells
• Modify Hyperlink Text
• Modify Hyperlink Styles
• Remove Hyperlinks

Workbook Properties

• Understand Workbook Properties
• View Workbook Properties
• View Advanced Properties
• Edit Workbook Properties
• Add Custom Properties
• Search Using Properties

Headers, Preview and Page Setup

• Use Built-in Headers and Footers
• Create Custom Headers and Footers
• Print Column and Row Titles
• Change Page Orientation
• Scale Worksheets for Printing
• Use Print Place
• Print Gridlines on Worksheets
• Adjust Page Margins
• Centre Worksheets on the Page

Print Place

• Open the Print Place
• Print Worksheets
• Set Print Areas in Worksheets
• Print Charts
• Apply Print Options
• Select Printers
• Change Printer Properties

About the Course

With this interactive course you will use AutoFill and Paste options, modify and group worksheets, apply styles and format worksheets. You will also use proofing tools, Flash Fill and record macros.

There are 7 modules in this course:

Creating Cell Data AutoFill and Paste Option

• Use AutoFill
• Use Paste Options
• Perform Operations with Paste Special
• Copy Formatting with Paste Special

Formatting Cells and Worksheets Modifying Worksheets

• Hide and Unhide Columns and Rows
• Hide and Unhide Worksheets
• Group Worksheets
• Ungroup Worksheets
• Insert Multiple Rows and Columns
• Move Rows and Columns
• Open New Windows
• Arrange Multiple Windows
• Hide and Unhide Windows

Cell and Table Styles

• Apply Cell Styles
• Remove Cell Styles
• Create Custom Cell Styles
• Apply Custom Cell Styles
• Modify Cell Styles
• Apply Table Styles
• Use the Total Row Option
• Name Tables
• Use Quick Analysis Tools

Formatting Worksheet

• Apply and Remove Backgrounds
• Add Header and Footers
• Add Washout Images
• Resize Images
• Change Column Widths
• Change Row Heights
• Transpose Data

Applying Themes

• Apply Themes
• Modify Themes
• Create and Save Custom Themes
• Change the Default Theme

Proofing and Macros Proofing Tools

• Modify Error Checking Settings
• Use the Error Checking Tool
• Spell Check Worksheets
• Use AutoComplete to Enter Data
• Use AutoCorrect
• Work with AutoCalculate

Flash Fill and Macros

• Use Flash Fill
• Understand Macros
• Record Macros
• Assign Shortcut Keys to Macros
• Run Macros
• Add QAT buttons
• Display Shortcut Keys
• Change Button Icons
• Modify Macro Security Settings

About the Course

With this interactive course you will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges.

There are 7 modules in this course:

Formulas and Functions Formulas and Referencing

• Identify Formula Operators;

• Understand Operator Precedence;

• Over-ride Operator Precedence;

• Enter Formulas;

• Copy Formulas;

• Use AutoFill;

• Update Formula Results;

• Use Absolute References;

• Apply Percentage Values.

Working with Functions

• Identify Function Components;

• Enter Functions;

• AutoSum Numbers;

• Use the AutoSum List;

• Use the ROUND Function;

• Apply the IF Function.

Logical and Informational Functions

• Use the IF Function;

• Use the OR Function;

• Use the AND Function;

• Use Help for Error Messages;

• Use Nested IF Functions;

• Understand IS Functions;

• Use the ISERROR Function.

More Logical Functions

• Use the SUMIF Function;

• Use the COUNTIF Function;

• Use the AVERAGEIF Function.

Named Ranges

• Name Cells;

• Name Cell Ranges;

• Add to and Edit Named Ranges;

• Change Range Names;

• Use Go To;

• Navigate using Cell Names;

• Use Names in Formulas;

• Display Cell Formulas;

• Delete Named Ranges.

Financial Functions and Data Tables

• Understand Financial Arguments;

• Use the FV Function;

• Use the PMT Function;

• Use the NPV Function;

• Use the Pv Argument;

• Use the RATE Function;

• Use NPV Function;

• Use the Guess Argument;

• Use Data Tables.

Text Functions

• Understand Text Functions;

• Use the CONCATENATE Function;

• Use the LOWER Function;

• Use the LEFT Function;

• Add Function Arguments;

• Use the PROPER Function;

• Use the UPPER Function;

• Understand TRIM Function.

About the Course

With this interactive course you will create charts and add illustrations using Pictures, WordArt, SmartArt, and ClipArt. You will also learn how to add Shapes and Sparklines and use Outlining tools.

There are 4 modules in this course:

Presenting Data Visually Creating and Modifying Charts

• Identify the Functions of a Chart;

• Create and Resize Charts;

• Add Chart Elements;

• Change Chart Layout and Styles;

• Move and Copy Charts;

• Change Chart Types;

• Edit Charts;

• Modify Chart Parameters;

• Create Pie Charts.

Adding Illustrations

• Add WordArt;

• Create SmartArt Graphics;

• Create Multiple Text Levels;

• Promote and Demote Text;

• Apply SmartArt Styles and Colours;

• Format SmartArt;

• Insert and Format Pictures;

• Use Artistic Effects;

• Modify Picture Borders.

Shapes, ClipArt and Sparklines

• Add Shapes;

• Add Clip Art;

• Use Screenshots;

• Create Text Boxes;

• Convert Text to WordArt;

• Delete Text Boxes;

• Add Sparklines;

• Clear Sparklines.

Outlining Worksheets

• Understand Outlining;

• Outline a Worksheet;

• Hide Outline Details;

• Show Outline Details;

• Select Outline Data;

• Remove Outline Levels;

• Manually Group Data;

• Remove a Group Outline.

About the Course

The Excel 2016 – Sharing and Validating Data course will show you how to add comments and share workbooks. You will also sort data and apply filters, use custom and conditional formats as well as validate data.

There are 5 modules in this course:

Sharing Workbook Data Using Comments

• Insert New Comments;

• Read Comments;

• Edit Comments;

• Display Comments;

• Hide Comments;

• Navigate Comments;

• Delete Comments

Sharing Workbooks

• Understand Share Options;

• Send E-mail Attachments;

• Send in PDF or XPS Formats;

• Understand Internet Fax;

• Share Files on OneDrive

Organising Data Sorting and Filtering Data

• Filter Data;

• Apply Multiple Search Criteria;

• Customise Filters;

• Sort with AutoFilters;

• Remove Filters;

• Sort on Multiple Columns;

• Add and Remove Subtotals;

• Display Unique Values;

• Remove Duplicate Entries.

Numeric and Conditional Formatting Custom and Conditional Formats

• Apply Numeric Formats;

• Apply Currency Formats;

• Apply Accounting Formats;

• Create Custom Formats;

• Use Conditional Formatting;

• Create Formatting Rules;

• Display Icon Sets;

• Clear Rules;

• Use Data Bars

Data Validation Validating Data

• Use the Data Validation feature;

• Set Validation Criteria;

• Create Input Messages;

• Create Error Alert Messages;

• Create Named Ranges;

• Create Data Entry Lists;

• Enter Data Using Lists.

There are no entry requirements for this online course.

Computer

Pentium-class PC or equivalent

Operating System

Windows 7, 8 or 10

Internet Browser

• Internet Explorer 10, 11 or Microsoft Edge
• Firefox
• Chrome

Course fees are £20.00 per level

Enrolment duration is 6 months.