Excel Skills
This course covers the official Microsoft Specialist Syllabus and you
will learn how to deal with the following tasks:
Creating Data and Content
- Enter and edit cell content
- Locate specific cell content
- Locate, select, and insert supporting information
- Insert, position, and size graphics
Analyzing Data
- Filter lists using the AutoFilter feature
- Sort lists
- Insert and modify formulas
- Use statistical, date and time, financial, and logical functions
- Create, modify, and position diagrams and charts based on worksheet
data
Formatting Data and Content
- Apply and modify cell formats
- Apply and modify cell styles
- Modify row and column formats
- Format worksheets
Collaborating
- Insert, view, and edit comments
Managing Workbooks
- Create new workbooks from templates
- Insert, delete, and move cells
- Create and modify hyperlinks
- Organize worksheets
- Preview data in other views
- Customize window layout
- Setup pages for printing
- Print data
- Organize workbooks using file folders
- Save data in appropriate formats for different uses
Seminar Training
We also offer one-day Instructor-Led seminar training - but the full
content for Excel Core and Expert needs to be split into three days:
- MS Excel Introduction - Create a spreadsheet, input data and carry
out simple calculations. Edit, delete, move and copy data. Using the
chart wizard. Format a spreadsheet and print it.
- MS Excel Intermediate - Create formulas across multiple worksheets
and workbooks, sort and filter data, use advanced formatting techniques,
create advanced charts, protect data, use standard templates and create
your own.
- MS Excel Advanced - Create advanced formulas to make decisions,
import and export data, create and use lookups and queries. Work with
Pivot Tables and other analytical tools, record and use a macro to
automate your work.
In addition, for advanced programming of macros, we have a two-day
seminar:
- MS Excel VBA - On our 2 day Excel VBA course you'll learn how to
customise and manipulate Excel within the Microsoft Visual Basic environment.
You'll be using macros, custom functions and user forms. The skills
gained from this Excel tVBA course can be applied to all versions
of Excel.
Call 0845 370 7577 for details
|
