• +44 01379 671280
  • training@computertrainingsuffolk.co.uk
Microsoft Certified profesional

Microsoft Excel Inroduction Training Courses.

Excel Introduction

Excel Intermediate

Excel Advanced

Excel VBA

Microsoft Excel introduction course outline.

COURSE OBJECTIVES

  • Use the Excel ribbon
  • Create and modify existing worksheets
  • Edit a worksheet
  • Format a worksheet
  • Work with Excel formulas
  • Print your worksheet
  • Create a chart
  • Control the worksheet display
Audience

This course is designed for new users of Microsoft Excel, or self-taught users. The course covers all aspects of creating and maintaining spreadsheets; including basic formulae and functions.

Pre-requisite

No Prior experience or knowledge of Spreadsheets is required to attend this course. You must have good basic windows, keyboard and mouse skills.

Duration

This is a 1 day Excel Introduction course. The course Lasts 6 hours and can start between 9am and  1pm Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Locations

Our Microsoft Excel Introduction course can be run at your offices  or any preferred location in the UK or Via video link online.

online training

Course Content
  • Setting up a Microsoft account
  • Connect to OneDrive or Business Drive
  • Connect to your Office 365 account
  • Tell me what you want to do 
  • Starting and exiting from Excel
  • Using the Excel ribbon
  • Customise the ribbon
  • Displaying Help information
  • Changing the file type and converting to PDF
  • Using and creating Custom Lists
  • Using Excel sample templates
  • Creating and opening workbooks
  • Adding data to a worksheet
  • Selecting ranges of cells
  • Entering worksheet data
  • Saving a workbook
  • Using the Excel Date Picker
  • Using the Spell Checker
  • Adjusting column widths
  • Inserting and deleting a range of cells
  • Copy, move and delete cell entries
  • Find and Replace specific entries in a worksheet
  • Inserting and renaming sheet tabs
  • Changing the font style, size and colour
  • Adding alignment options, wrap text, orientation and merge cells
  • Applying borders and patterns
  • Adjusting row height and column widths
  • Changing the number format of cell entries
  • Using Styles for consistent formatting
  • Conditional formatting
  • Creating basic formulas
  • Brackets and the order of calculation
  • Excel functions
  • Using the SUM, AVERAGE, MAX, MIN, COUNT and COUNTA functions
  • Using AutoSum
  • Using Insert Function
  • Using AutoFill
  • Using absolute and relative references
  • Previewing a worksheet
  • Changing the Page setup of a worksheet
  • Setting the print area
  • Printing certain rows or columns on each page
  • Printing selected worksheet entries
  • Plotting a chart
  • Use Recommended Charts 
  • Previewing and printing a chart
  • Adding new data to an existing chart
  • Including multiple data ranges in a chart
  • Uses of the different chart types
  • Creating Sparklines
  • Create Funnel Charts and 2D maps
  • Splitting the workbook window into panes by freezing panes
  • Hiding rows and columns
  • Changing the zoom level for a worksheet
  • Sorting and filtering worksheet data

 

 

 

TRAINING SERVICES

Microsoft Office Specialist Courses ( MOS ) courses – Office 2010, 2013, 2016, 365 and 2019 As well as accredited courses we deliver over 200 standard courses covering Microsoft, Apple and Adobe Delivery Styles – Group bookings, 1-2-1, Public courses, Tailored and Office Migrations. Complimentary Training Materials for delegates – We have a dedicated site with a wide range of Microsoft manuals available, new titles are released regularly.

Microsoft Computer training

Accredited and Experienced Trainers

– All our trainers are Microsoft accredited and experienced. You will have peace of mind knowing that our trainers have been personally interviewed and assessed by us for their product knowledge, communication and delivery skill

 

 

On-site Courses – our courses can be delivered on-site at your business premises. we adhere to strict covid guidance Live

Online Courses – our training courses can be delivered on-line with a live tutor via Zoom, Microsoft Teams or Web-ex virtual classroom software. COVID-19: Whilst the

Need to up-skill, re-skill or simply develop your digital skills for the workplace or personal use? We have a huge range of courses to support you in your learning covering all Microsoft Office packages including Word, Outlook, Excel, PowerPoint and MS Project and also offering courses in social media, Apple Macs, computer maintenance and much more.

we are an independent team of training providers in suffolk that are dedicated to helping you to build successful and profitable businesses. Our professionals have a wealth of expertise and knowledge in this field and can be sure to cater to all of your specific needs, no matter how big or small your business may be. So you can have peace of mind knowing that you are in the most capable of hands. We are confident that you won’t find a service quite like ours, anywhere else. Our training providers in suffolk will be on hand to help with all of your requirements whether you are a small establishment or large commercial company.