Excel - Intro
Enquire About This CourseOur 1 day Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel.
Prerequisites
A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required.
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 a spreadsheet from scratch.
Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Spreadsheets that you create will be easier to use and look more presentable.
After completing this course you will be prepared to attend our Advanced MS Excel training course.
Course Content
Screen Tour
- Toolbars & Menu Bar
- Sheets
- Set/ Clear Print Area
Formulae & Functions
- Operators & Precedence
- Standard Functions (Sum, Average, Max, Min, Etc)
- Replicate Command (Use With Formula/ Functions, Fill
- Formats/ Series/ Trends, Days, Etc)
Cell References
- Absolute
- Relative
Range Names
- Create New, Modify Existing
- Use With Formula
Sorting Data
- Header Row
- Ascending/ Descending Order
- Use First Key Sort Order (For Custom Lists)
Format Cells
- Text & Numerical (Data)
- Patterns & Borders, Alignment
- Wrap Text, Centre Across ion
- Merge Cells
Spreadsheet Operations
- Split & Freeze Window
- / Rows & Columns
- Adjust Row & Column Height/ Width
Charts
- Embedded Chart
- Sheet Chart
- Options (Titles, Legends, Data Labels, Data Table, Etc)
Customising Page Setup
- Orientation & Margins
- Headers & Footers
- Gridlines, Titles & Page Order
- Scale Print
- Set Row & Column Headings
- Split Screen
Sheet Operations
- & Rename
- Rename
- Copy/ Move Within Current File And To External Files
- Group Sheets ( Adjacent & Non-Adjacent Sheets)
- Link Worksheets Within A Single File
- Link Worksheets to External Files
Security
- Protect Cell Ranges
- Password Protect Files
Click here to download:
Enquire About This Course
-
29/6/2012
Sage Act Training in Belfast Northern Ireland - Closed or Public Courses -
29/6/2012
HOT COURSE - Intro to Microsoft Visio Training in Belfast Northern Ireland OR On Your Own Premises 18th May - CALL NOW to secure a place on this course -
27/6/2012
Introduction to Microsoft PowerPoint Training in Belfast Northern Ireland OR On your Own Premises -
26/6/2012
Introduction to Microsoft Project Training in Belfast Northern Ireland OR On Your Own Premises - 26th & 27th June - Per Person -
26/6/2012
Introduction to Crystal Reports Training in Belfast Northern Ireland 26th & 27 June OR On your Own Premises - Learn how to create powerful and dynamic reports, presenting your data in an attractive format -
25/6/2012
SAGE 50 ACCOUNTS TRAINING in Belfast Northern Ireland OR On your Own Premises - Advanced SAGE Line Accounts course - CALL NOW TO BOOK -
19/6/2012
Advanced Microsoft Access CourseTraining in Belfast Northern Ireland OR On your Own Premises - Call NOW to Book -
19/6/2012
Sage Payroll Level 1 Training in Belfast Northern Ireland OR On your Own Premises - 19th June CALL NOW TO BOOK -
19/6/2012
Intro to Adobe DreamWeaver CS3 CS4 CS5 CS6 Training in Belfast Northern Ireland OR On your Own Premises - 19th & 20th June - Call NOW to BOOK -
15/6/2012
Microsoft Sharepoint Introduction Training Course in Belfast NI -
15/6/2012
Introduction to Microsoft Publisher Training in Belfast Northern Ireland OR On your Own Premises -
14/6/2012
Hot Course - 2 Day Advanced Microsoft Excel Course Training in Belfast Northern Ireland OR On your Own Premises - 14th and 15th June - CALL NOW TO BOOK -
13/6/2012
Adobe InDesign CS3 CS4 CS5 CS6 - Introduction Training in Belfast Northern Ireland 13th and 14th June at Mullan Training OR On your Own Premises - Need to Publish Professional Newsletters -
12/6/2012
Upgrading to Microsoft Office 2007/10 Training in Belfast Omagh Coleraine Newry Northern Ireland OR On your Own Premises - CALL TO GET THE DATES -
12/6/2012
Microsoft Access Introduction Training in Belfast Northern Ireland 12th and 13th June OR On your Own Premises - 2 Day Course -
11/6/2012
Adobe Premiere Course Training in Belfast Northern Ireland OR On your Own Premises - 11th & 12th June Digital Video Editing Intro to Adobe Premiere - CALL NOW TO BOOK -
10/6/2012
Introduction to Microsoft Outlook 2003 Training in Belfast Northern Ireland OR On your Own Premises - 10th June - Call Now to Book -
8/6/2012
Popular Course - Intro to Microsoft Word Training in Belfast Northern Ireland OR On your Own Premises - Places Still Available -
8/6/2012
1 day Adv Microsoft Excel CourseTraining in Belfast Northern Ireland OR On your Own Premises - Places Available - Call Now to Book -
7/6/2012
Introduction to Adobe Acrobat Training in Belfast Northern Ireland OR On your Own Premises - 7th June - CALL TO BOOK
