Excel Foundation

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course introduces delegates to the fundamental skills required to use Microsoft Excel productively. Delegates will be introduced to the fundamental skills required to build a worksheet including the principals of formulae & functions, the manipulation of data, printing and graphically representing data through charts.

Delegates will gain an appreciation of how Excel can be used in typical business scenarios through the creation of several worksheets and may include budgeting, sales analysis, entry-level bookkeeping & staff scheduling.

Emphasis will be placed on keyboard and mouse shortcuts to ensure all delegates work as efficiently as possible.

Basic Excel formulae will be used to summarise data in a worksheet. Various number & layout formatting techniques will be applied to ensure the worksheets have a professional feel about them. Several different chart types will be used to explore ways of analysing data through graphical representation.

Course Objectives
By the end of the course the delegate will be able to:

Create their own spreadsheets from scratch
Use copy/paste and drag/drop to alter the spreadsheet
Format data in an attractive layout
Create basic calculations
Create basic charts
Print spreadsheets and charts
Sort and search a simple list
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

Screen Familiarity
Workbook principles
Screen layout
Working with Cells
Use Undo and Redo
Selecting cells
Go to a specific cell
Find & Replace
Cut, copy, paste, and move cells
Autofill
Copying cells
Work with series (AutoFill)
Working with Data
Enter text, formulae, and numbers
Edit cell content
Clear cell content
Foundation Formulas and Functions
Mathematical Operators (+. -, *, /)
BODMAS
Enter & Revise formulas
Use AutoSum
Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
Use the Paste Function to insert a function
Relative and Absolute cell referencing
Formatting Worksheets
Apply font styles (typeface, size, color, and styles)
Modify row and column size
Modify alignment of cell content
Use the Format Painter
Apply cell borders and shading
Merge cells
Wrap text
Clear cell formats
Number Formats
Apply predefined number formats
Inserting & Deleting
Insert and delete rows and columns
Insert and delete selected cells
Charting
Keyboard Shortcut (F11)
Types of chart
Column, Line & Pie Charts
Use the Chart Wizard to create a chart
Preview and print charts
Simple Formatting
Chart Options
Printing
Preview and print a selection, worksheets, workbooks
Change page orientation and scaling
Set page margins and centering
Insert and remove a page break
Set print, and clear a print area
Set up headers and footers
Set print titles and options
Working with Lists (Time Permitting - Overview)
Setting up a list in Excel
Field headings
Sorting
Searching with Autofilter ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Excel Foundation training resources.

InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Crystal Reports
Excel - Formulae and Functions
Excel Advanced
Excel Intermediate
Excel VBA
FrontPage Advanced
FrontPage
MapPoint
Outlook
Powerpoint - Advanced
Powerpoint
Project
Publisher

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.