4, 6, 10 or 12 Month Interest Free Payment Plan Options available.
Speak to one of our course...
- Pitman Training Certificate - Free
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
4, 6, 10 or 12 Month Interest Free Payment Plan Options available.
Speak to one of our course...
ABOUT THE COURSE
The course offers an exciting and innovative approach to Excel training. It is split into 2 parts and consists of 10 modules in each part. It includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and
assess your understanding. The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.
AIMS AND OBJECTIVES
The aim of the course is for you to learn the core features and functions of the Microsoft Excel 2019 spreadsheet application, so that you will be effective in creating and manipulating spreadsheets.
Digital certificate - Included
This course is split into 2 parts;
PART 1 - COURSE CONTENT
Module 1: Introduction to Excel
The Excel 2019 Window; Mouse Basics in Excel; Backstage View
Module 2: Creating Workbooks
Entering Text and Numbers; Creating Basic Formulas; Relative References; Order of Operations; Working with Ranges
Module 3: Saving and Sharing Workbooks
Saving a Workbook; File Extension; Sharing, Exporting, and Publishing Files
Module 4: Navigating Workbooks
Opening Files; Working with Larger Files; Creating Freeze Panes; Split Screen
Module 5: Page Setup and Print Options
Headers and Footers; Print Titles; Working with Comments; Page Setup Options; Printing Workbooks
Module 6: Working with Rows, Columns, and Cells
Adding and Deleting Rows, Columns, and Cells; Changing Column Width and Row Height
Module 7: Moving Data
Cut, Copy, and Paste; Copying Formulas
Module 8: Formulas and Functions
Overview of Formulas; Creating Formulas Using Functions; Using Absolute Values
Module 9: Working with Sheets
Adding, Deleting, Renaming, and Grouping Sheets; Additional Sheet Tab Options; 3-Dimensional Formulas
Module 10: Formatting Worksheets
Formatting Cells; Formatting Numbers; Borders and Shading; Formatting a Range of Cells as a Table; Using
Styles and the Format Painter; Protecting Sheets; Using the Fill Handle and Creating Custom Lists
PART 2 - COURSE CONTENT
Module 1: Using Charts
Creating Charts; Types of Charts; Editing Charts; Using Graphics to Enhance Charts; Linking Chart Titles; Creating Sparklines
Module 2: Working with Names
Creating Range Names; Managing Names; Using Names in Formulas
Module 3: Sorting and Filtering Data
Removing Duplicate Rows; Sorting Data; Filtering Data; Using Advanced Filters
Module 4: Outlining and Subtotaling Data
Creating an Outline; Adding Subtotals
Module 5: Working with Views
Arranging Files; New Window Feature; Custom Views
Module 6: Linking Files
Creating Formulas Between Files; Working with Links; Consolidating Data
Module 7: Advanced Formula Creation
Using IF Statements; Using Functions to Look Up Data; Working with Data Validation; Formula Auditing; Using the Watch Window
Module 8: Overview of PivotTables and PivotCharts
PivotTables; PivotCharts; Slicers
Module 9: Customizing Excel
Excel Options; Customizing the Ribbon; Modifying Workbook Properties
Module 10: Additional Excel Features
Text to Columns; Conditional Formatting; Hyperlinks; the Spell Checker and Translate Features; Quick Analysis Tool; the Document Inspector; Import Data from a Text / CSV File
IS THIS COURSE FOR YOU?
The course is designed for those who wish to learn how to use this powerful spreadsheet program. You will learn the key concepts and techniques necessary to work with Excel’s most commonly used features and functions.
PRE-REQUISITES
Familiarity with the Windows environment and experience using a computer keyboard.
CAREER PATH
Microsoft Excel is used across a wide range of job roles; learning this spreadsheet program will demonstrate your commitment to continuing professional development and help towards your career progression opportunities.
Currently there are no reviews for this course. Be the first to leave a review.
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.