Spreadsheets … workbooks … worksheets

Microsoft Excel 2010, 2013 and 2016
Basic Training Courses

DMW's Basic Introduction Excel courses are for you if you are new to spreadsheets or are self-taught and want to make certain you are not missing out on any of the basic skills. DMW includes a brief maths refresher if you are anxious about applying arithmetic rules to formulae in Excel.

Wherever possible, worksheets similar to those you meet in the office day-to-day are used for hands-on exercises. You can benefit from tapping into DMW's years of experience in developing spreadsheets.

Course Content

Fruits of BODMAS

Each course is presented according to the sorts of work for which you will be using Excel and according to your existing knowledge of Excel and its workings. Basic introductory courses dip into most of these topics:

Excel screen The components of the Excel display and how to arrange them.

User interface ribbon Understanding how Excel's ribbon works and where to find things on it.

The spreadsheet Columns; rows; cells.

Terminology Understanding Excel terms and jargon.

Navigating Moving around spreadsheets with mouse and keyboard.

Inputting Text, numbers, dates and so on.

Editing Changing and extending spreadsheet content.

Formulae Creating simple formulae; revision of rules of arithmetic as they apply in Excel.

The maths If you are anxious about composing formulae, a refresher on the rules of arithmetic.

Formatting Determining the appearance of cells, columns and rows.

Insertion Inserting new cells, columns and rows.

Deletion Deleting cell content and actual cells, columns and rows.

Headings Making and removing headings.

Copying and moving Mouse and keyboard techniques.

Page layout Margins and other settings that determine how your spreadsheet fits on paper.

Headers and footers How to place text at the top and bottom of each page.

Printing Printing all or part of a spreadsheet.

Filing Saving and retrieving spreadsheets.

On occasions, with groups in which people already have a smattering of Excel, we stray into “intermediate” topics. This is another advantage of on-site training: you are not tied to a syllabus as you might be when attending a public course.

Course Duration

This course takes one day on-site, normally between 9:30 AM and 4:30 PM. Starts and finishes can be changed to suit your diary.

Not having to travel to a training centre and not being far from your desk are advantages to you of on-site courses.

Course Prerequisites

Competence in the use of the mouse, keyboard and windows, and of the “ribbon” common to Access, Excel and Word, and across rest of Microsoft Office. Awareness of basic computer principles like files, folders and filing.

DMW would welcome you giving some prior thought to why you might want to use spreadsheets and for what business activities they are to support.