Excel Beginners Course, 1-Day

Description

Excel Beginners Course, 1-Day.

Learn the essential Excel Introduction, in our interactive, instructor led Live Virtual Classroom.
This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language.
These concepts are daily used by professionals and is essential in mosts jobs.
By the end, you'll be comfortable with Excel concepts, ribbons, formulae and the Functions Wizard.
You will gain hands-on practical experience creating a Spreadsheet from scratch on your won.

Location: Instructor-led, Online.
Our Style: Hands-on, Practical Course.
Group Size: Max 4 people per group.
Qualification: PCWorkshops Beginners Certification
Hours: 1 Day, 10am-5pm

Excel Beginners Course, Course Outline.

General Excel Environment: About Workbooks, Exploring your Workbook, Getting Help with Excel The Excel Ribbons and Menus, Introducing the ribbons
Excel Spreadsheets Basics:
The Home Ribbon: Font, Alignment, Number Formats, Format as a Table, Cell Styles

Editing your Workbook: Entering data , Modifying Cells and Data, Autofill

Cell Formatting: Enhancing a Worksheet's Appearance, Copy Formats

Conditional Formatting

Entering basic Formulae: Creating basic formulae, Reading and understanding existing formulae

Functions: Popular functions, If-Function

Copy: Copying Data, Copying Formulae, Absolute Copies, Moving Data, Format Painter

Working with data sets: Sort, Filter, Find, Replace

Sheets: Inserting, Moving, Copying, Deleting Sheets, Colouring Sheet Tabs.

Printing and Viewing your Workbook: Using the View Tab, Managing a Single Window, Managing Multiple Windows, Printing your Workbook

Inlcuded with the Excel Beginners Course

Book the Excel Beginners Course Powered by Eventbrite

About us

Our experienced trainers are award winners.