Excel Basics

OfCourse

Course

Online

Save 51%
£ 24 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

This course will provide a comprehensive foundation of basic Excel skills. Learn how to master the Excel Basics that will impress your colleagues and help you hit the career heights that you deserve.David Millard will guide you through the Excel Basics that will enable you to manipulate data on the world's most popular spreadsheet software with ease. David is a Microsoft Master Instructor who was granted Microsoft Certified Trainer status in 2009, and he has designed this course to help students of all abilities to master the foundations of Excel. With detailed sections on worksheets, charts, formulas and much more by the end of this course you will feel totally in control using Excel.It is time to turn your Excel weakness into a strength. Take this course today to unlock your career potential through Excel.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

42 lectures with 3.5 hours of video content Detailed supporting Excel workbooks and section specific quizzes to give you a thorough base in Excel Learn how to master Worksheets, Formatting, Formulas, Charts, Sorting & Filtering Data, Charts and Printing Lean the basic skills that provide a foundation to build advanced Excel skills as you develop throughout your career 

Anyone

None

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Using excel
  • MS Excel

Course programme

Welcome to Excel Basics
Intro
Say hi to your fellow students!
Share your new course with your friends!
Welcome to Excel Basics

Excel Basics
The Excel Interface
Creating a New Workbook 
Pointer Shapes
Opening and Closing Workbooks
Excel Download - Workbooks Lesson 1
Excel Download - Workbooks Lesson 2
Moving around with Keyboard and Mouse
Excel Download - Moving around with Keyboard and Mouse
Opening Multiple Workbooks
Excel Download - Opening Multiple Workbooks: January 1
Excel Download - Opening Multiple Workbooks: January 2
Renaming Sheets
Excel Download - Renaming Sheets
Copying and Moving Sheets
Excel Download - Copying and Moving Sheets
Inserting and Deleting Sheets
Excel Download - Inserting and Deleting Sheets
Changing Sheet Tab Colours
Excel Download - Changing Sheet Tab Colours
Copying and Moving Cells
Excel Download - Copying and Moving Cells
Copying and Moving by Dragging
Excel Download - Copying and Moving by Dragging
Using the Fill Handle

Worksheets
Inserting Rows and Columns
Excel Download - Inserting Rows and Columns
Deleting Rows and Columns
Excel Download - Deleting Rows and Columns
Hiding Rows and Columns
Excel Download - Hiding Rows and Columns
Adjusting Column Widths
Excel Download - Adjusting Column Widths
Adjusting Row Height
Excel Download - Adjusting Row Height
Copying by Using the Fill Handle
Excel Download - Copying by Using the Fill Handle
Copying Using the Shortcut Menus
Excel Download - Copying Using the Shortcut Menus

Formatting
Selection Methods 
Cell Alignment
Excel Download - Cell Alignment
The Format Painter
Excel Download - the Format Painter
Simple Formatting
Excel Download - Simple Formatting
Fonts, Font Size and Font Colour
Excel Download - Fonts, Font Size and Font Colour
Cell Borders
Cell Patterns
Excel Download - Cell Patterns

Formulas
Introduction to Formulas and Functions
Excel Download - Introduction to Formulas and Functions: Using Excel to Calculate
Invoice Walkthrough
Absolute Cell References
Functions
Named Ranges
Outlining

Sorting and Filtering Data
Sorting
Filtering
Excel Download - Sorting and Filtering
Tables
Excel Download - Tables

Charts
Inserting Charts in Excel 2010
Adding Charts in Excel 2013
Excel Download - Inserting Charts in Excel 2010 and 2013
Sparklines
Excel Download - Sparklines

Printing
Setting and Clearing a Print Area 
Excel Download - Setting and Clearing a Print Area
Page Breaks and Column Headers
Excel Download - Page Breaks and Column Headers

Quiz
Part 1
Part 2
Part 3
Part 4
Part 5
Part 6
Part 7

See related categories

Excel Basics

£ 24 VAT inc.

The best Excel courses

See all

See all