Dreamweaver course in north London

Microsoft Excel: Introduction (Level 1)

Microsoft Excel is the popular spreadsheet from Microsoft and part of the Microsoft Office suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get lots of practice in creating and modifying actual spreadsheets.

New or intending users of Microsoft Excel who wish to gain a good understanding of the software.

Because of the amount of material we cover in class, we do require students to be comfortable using a mouse, opening and saving files, and the general operations of computers.

Course outline

  • Opening Excel
  • Exiting Excel
Beginning Excel
  • The Standard Toolbar 
  • The Formatting Toolbar 
  • Working with Excel Menus 
  • Exploring Task Panes 
  • Excel Short-cut Keys 
The Basics of File Managemnt
  • New Workbooks 
  • How to Open Existing Workbooks 
  • How to Save Workbooks 
  • How to Close Workbooks
Explore your workbook
  • Switching Worksheets 
  • The Active Cell 
  • Selecting Cells 
  • Exploring a Worksheet 
  • The Zoom Feature 
Working with Excel
  • Columns, Rows, Cells, and Ranges 
  • Creating Worksheet Labels 
  • Entering and Deleting Data 
  • Printing your Worksheet 
Basic Excel features
  • What is AutoFill? 
  • What is AutoSum? 
  • What is AutoComplete? 
  • Working with Basic Formulas 
Editing Tools
  • AutoCorrect 
  • Spell Check 
  • Find and Replace 
  • Documenting a Worksheet with Comments
Moving Your Data
  • Dragging and Dropping Cells 
  • How to Cut, Copy, and Paste Cells 
  • How to Cut, Copy, and Paste Multiple Cells and Items 
  • How to Use Paste Special 
  • How to Insert and Delete Cells, Rows, and Columns 
  • Undo, Redo, and Repeat 
Modifying Cells and Data
  • Changing the Size of Rows or Columns 
  • Working with the Formatting Toolbar 
  • Adjusting Cell Alignment 
  • Rotating Text 
  • Creating Custom Number and Date Formats
Cell Formatting
  • Conditional Formatting 
  • Cell Merging and AutoFit 
  • Find and Replace Formatting 
Enhancing a Worksheet's Appearance
  • Adding Patterns and Colours 
  • Adding Borders 
  • Adding Fill Effects 
  • Working with Styles
Modifying Excel's Toolbar
  • Hiding Toolbars 
  • Showing Toolbars 
  • Moving Toolbars 
  • Customizing Toolbars
Working with Charts
  • Creating a Chart 
  • Formatting a Chart 
  • Manipulating a Chart 
  • Changing the Type of Chart 
  • Changing the Source Data
Organising your Workbook
  • Inserting and Removing Worksheets 
  • Renaming, Moving, and Colour-Coding Worksheets 
  • How to Split and Freeze a Window 
  • Using Multiple Workbooks
Formatting your Workbook
  • Headers and Footers 
  • Inserting Page Numbers 
  • Changing Margins and Orientation 
  • Hiding Rows, Columns and Worksheets 
Printing a Workbook
  • Choosing a Print Area 
  • Setting up Page Breaks 
  • Choosing Paper Size and Changing Print Scale 
More Workbook Features
  • Linking Workbooks 
  • Combining Worksheets 
  • Protecting Worksheets 
  • Templates 

Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

We recommend the following courses that relate to this class: Microsoft Excel Intermediate and Microsoft Access Introduction

Course Duration 1 Day
Private Course Price and dates This course is only available as individual 1:1 on a bespoke
Please call centre on 0208 443 2888 for a quote and to arrange dates
Course Times 10:00 till 16:00