Excel for self-taught users
Short course
In Gateshead
Benefit from this course and gain experience!
-
Type
Short course
-
Level
Beginner
-
Methodology
Inhouse
-
Location
Gateshead
-
Duration
1 Day
-
Start date
Different dates available
Do you want to learn how to use Microsoft Excel the right way? Do you want to give yourself firm foundation that will enable you to progress to more advanced levels?
Whether you are a complete beginner or have taught your self some of the basics, this course will help you learn all the basic skills you need. Lots of hands-on practice and a course manual included.
Follow the link you have on emagister.co.uk and you will find all the information you need about this course without any obligation.
Facilities
Location
Start date
Start date
About this course
Learn all the Excel basic skills including: navigation, data entry, editing, saving your work, formulas and functions (like SUM, AVERAGE and IF), formatting, simple charts and printing.
This course is aimed at people who need to use Excel at work, but have had no formal training, or need to revisit the basics. It is suitable for those who are experienced in data entry but have not used formulas.
No prior experience of Excel is necessary, but you should have basic IT skills, and know how to find and open files in Windows, and use the mouse and keyboard.
We will contact you to arrange a date and explain payment options.
Reviews
Subjects
- Excel
- MS Excel
- Spreadsheets
- Using excel
- Microsoft Excel
- Microsoft Office
- Excel Formula
- Introduction to Excel
- Microsoft Excel for Beginners
- Beginners Excel
Teachers and trainers (1)
Kathy Evans
Senior trainer
Kathy is a knowledgeable and enthusiastic IT trainer with over twenty years' experience of training in computer applications and operating systems. Although she is an MCSE and an MCITP Enterprise Administrator, she still enjoys training beginners, as well as experienced computer users and technical staff. Delegates on her courses regularly comment on how easy and interesting she makes it to learn new skills.
Course programme
- Navigation
- Selecting cells
- Entering, editing and deleting data
- Using AutoFill and AutoComplete to quickly enter data
- Autofill Formats
- Using AutoSum
- Creating simple formulae
- Using functions such as SUM, AVERAGE, MAX and MIN
- Using the formula palette to construct and amend formulae and functions
- Extending formulae using the fill handle
- Using control and enter for copying formulae
- Using the range finder
- Absolute References
- Formatting text and numbers
- Applying borders and shading
- Using the format painter tool
- Changing the size of columns and rows
- Merging cells
- Inserting rows and columns
- Deleting rows and columns
- Simple conditional formatting
- Creating charts for graphical representation of data
- Using the chart wizard
- Using different styles of chart
- Customising the appearance of charts
- Customising headers and footers
- Changing margins and page orientation
- Specifying print options
- Spell check
- Sorting information in a database
- Find and replace
- Filtering records using AutoFilter
- Zooming
- Splitting worksheets and freezing panes
- Simple Ifs
- Vlookup
Excel for self-taught users