San Francisco, California
London, United Kingdom
Our Excel introduction course will provide you with the skills and confidence to create and edit spreadsheets. The course will cover all the basic topics from setup to formulae to printing.
After the course, you will be able to:
- Create and Edit Spreadsheets
- Create Functions and Formulae
- Format Worksheets
- Page Setup and Printing
- Basic List Management
Course Prerequisite - No previous experience on Excel is required to attend this course, but you must have basic windows and keyboard skills
Lesson 1: Excel Basics
- Excel Overview - get to grips with the user interface, spreadsheet dimensions, file operations and Excel options
Lesson 2: Data Entry - Creating New Spreadsheets
- Entering different data types, moving / copying data, clearing data, using AutoFill and many more data entry options
Lesson 3: Formulae and Functions Construction
- Basic arithmetic (BODMAS), using constants, copying / moving formulae, change to values
- Functions - Sum, Average, Max, Min, Count, Counta, Countif, Sumif. (More on request)
- Formulae Auditing Basics
Lesson 4: Worksheet Management and Formatting
- Inserting and Deleting Rows / Columns, Worksheets. Also hiding rows, columns and worksheets. Formatting Cells using all data type formats, fonts, colours and backgrounds
Lesson 5: Essential List Management
- Using all Sorting Options
- Grouping data
- Excel Lists
- Data Form
Lesson 6: Page Setup and Printing
- Page Setups, including Orientation, Headers & Footers, Marings and Scalings, Print Areas and Titles, All Printing functionality.
When & Where
Touchstone Training and Consulting
Touchstone Training and Consulting offers an extensive range of affordable application courses (including Microsoft Office 2003, 2007 and 2010) from Beginner to Advanced level.
All our courses can be customised to suit your specific needs and we also offer courses in small groups of up to 10 people or on a one to one basis.
Our course portfolio will help you build the skills, knowledge and techniques you need to advance your career or business.
Why Touchstone Training and Consulting?
• High Impact, Quality Training Delivered By Experts
• Perfectly Crafted Training Tailored to Suit You. All our course contents can be customised and delivered at a location of your choice!
• Small Class Sizes Up to 10 people so we deliver personalized and interactive courses
• Price Match Guarantee - If you find an identical training course at a cheaper price, let us know and we will match the price and offer you 10% off your next course with us!