Excel Fundamentals - Spreadsheet Format & Design

Microsoft Excel Fundamentals

Who is this course for?

Suited for users of Excel 2010, 2013 and 2016

Our Microsoft Excel Fundamentals course is suitable for beginners and basic users who are self-taught. It would also suit individuals who would like a refresher course to fill the skills gap. Focusing on a ‘hands-on approach’ with real-world experience to keep training interesting and engaging.

Prerequisites

This course assumes the user understands the basics of using a Windows-based computer and students should be comfortable using the keyboard, mouse and Start Menu.

Benefits

At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create and format a spreadsheet and build basic formula using time saving tools learnt on the course. You will gain a good understanding of the Excel environment and basic functions and features. You will use some of the built in calculation and formula functionality that will allow you to explore Excel and become more productive in your work .

The course is held in a fully equipped computer training suite. Courses include Instructor led training by a friendly and qualified trainer with over 30 years' experience. The course is limited to 6 delegates who will each receive a printed workbook, cheat sheets, reference course manual (pdf by email or memory stick), a certificate on completion of the course and after course support. Courses include refreshments throughout the day.

Getting Started; A closer look at the Excel interface; Spreadsheet terminology; Exploring the Excel window; Getting help; Opening and navigating workbooks; Closing workbooks; Understanding Worksheets & Workbooks; Entering and Editing Data; Creating workbooks; Entering and editing labels and values; Entering and editing formulas; Using the wrap command; Adding rows and columns; Building Basic Formula; The maths basics of Excel; Building a formula; Editing a formula; Copying a formula; Relative & Absolute Referencing; Formatting Your Data; Formatting text and numbers; Setting alignment options; Using merge; Adding borders and shading; Time Saving Tools; Using AutoFill; Using AutoComplete; Apply conditional formatting; Using Excel Functions; Formulas vs Functions; Using the SUM, MIN, MAX, AVERAGE and COUNT functions; Printing Excel Data; Overview of Page Layout Tab; Setting Up Your Page; Using Print Preview; Printing Data

Fully equipped training suite. Refreshments and course materials included.