|
Provided by: Mullan Training Introduction to MS Excel - 1 DayExcel |
 |
Training
Provided by Mullan Training
Our 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.
For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
028 9032 2228
|
|
||||||||||||||||
Introduction to MS Excel - 1 Day
Course Content
Screen Tour
 Toolbars & Menu Bar
 Sheets
Basic File Operations
 Open, Close
 Save & Save As
 Print & Print Preview
 Set 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
Toolbars
 Customise Existing
 Create New
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 Selection
 Merge Cells
Spreadsheet Operations
 Split & Freeze Window
 Insert/Delete 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
 Insert & Rename
 Rename
 Copy/ Move Within Current File And To External Files
 Group Sheets (Select Adjacent & Non-Adjacent Sheets)
 Link Worksheets Within A Single File
 Link Worksheets to External Files
Security
 Protect Cell Ranges
 Password Protect Files
Screen Tour
 Toolbars & Menu Bar
 Sheets
Basic File Operations
 Open, Close
 Save & Save As
 Print & Print Preview
 Set 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
Toolbars
 Customise Existing
 Create New
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 Selection
 Merge Cells
Spreadsheet Operations
 Split & Freeze Window
 Insert/Delete 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
 Insert & Rename
 Rename
 Copy/ Move Within Current File And To External Files
 Group Sheets (Select Adjacent & Non-Adjacent Sheets)
 Link Worksheets Within A Single File
 Link Worksheets to External Files
Security
 Protect Cell Ranges
 Password Protect Files
About The Training Provider: Mullan Training
Mullan Training - Mullan Training are a computer training company in Belfast city centre.
We deliver high quality computer training in Belfast and throughout Northern Ireland.
We can deliver computer training courses in our training suites OR in your own offices. We are an authorised
Microsoft Office Specialist (MOS) Testing Centre so delegates can prepare for & sit exams with us.
Courses we deliver...
