Professional Development of Bespoke Business Software and Database Specialists

You are here: Home » MS Office Training » Microsoft Excel » Introduction

MS Office Training

Other pages in MS Office Training:

Latest templates added to the emporium

Introduction

Audience: This course is designed for new users of Excel, or those with little experience.
 
Course Duration: This is a 1 day Excel Introduction Course. Course starts at 09:30 and runs until 16:30
 
Objectives: After the course, delegates will be able to:
 
       Create and maintain spreadsheets
       Create and edit formulae
       Format and print worksheets
       Perform basic list management tasks
 
Requirements: You do not need any previous knowledge of Excel, but should have basic windows, keyboard and mouse skills
 
Course Locations / Schedule : This course can be run at your premises (equipment must be provided) or at one of our training centres throughout the UK. The course is run on a date that suits you! We do not run public scheduled courses.
 
The following content applies broadly to all versions of Excel. Some content may slightly differ, full course content packs are provided on the day. Remember courses can be customised to fit your exact needs.
Excel Overview
       A overview of the screen, navigation and basic spreadsheet concepts
       Understanding workbooks, worksheets, rows, columns, cells
       Various selection techniques
Entering Data
       Entering, Editing and Deleting Text, Numbers, Dates
       Using Auto Lists
       Moving and Copying data
       Inserting, Deleting and Hiding Rows & Columns
       Inserting, Deleting, Moving and Copying Sheets
       Using navigation techniques
Creating and Editing Formulae
       Concept of Formulae
       Creating Formulae, Editing Formulae
       Bodmas : Mathematical Order
       Copying Formulae
       Using Functions - Sum, Average, Max,Min, Count, Counta
       Applying Absolute (Fixed) Referencing
Formatting and Proofing
       Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns
       Basic conditional formatting
       Copying and Clearing Formats
       Working with Styles
       Spell Check, Find & Replace and AutoCorrect
Printing and Page Setup
       Page Orientation
       Adding Headers and Footers
       Printing a selection
       Setting a print area
       Shrink to Fit
       Adjusting page breaks within Page Break Preview
       Repeating columns and rows
       Printing Gridlines
       Setting a print area

Software development company

At Mill House Data we are experts in the design and construction of bespoke software development solutions. With a high level of experience in application development for many industries, from small business to corporate clients, we are capable of designing and developing the perfect business software for your needs.

Our software development company utilizes MS Access which not only allows for multiple user ids but up to 2GB of data storage which is more than adequate for most business needs. Utilising this method of application development is the most economic route as only one Microsoft license is required, so we can provide your custom software development needs with a smaller budget than most other development houses.

Using the services of Mill House has really improved our company's customer services. The database that Mill House have provided is very customer friendly, easy to use and practical. I would highly recommend Mill house and surely use them again.

Read more testimonials >