MSEX207 - Microsoft Excel 2007 – In Practice
This course is assigned for users, who already work with Microsoft Excel on basic level. We will teach you to fully employ its possibilities and create documents with tables and graphs on a professional level. It is assumed that you already know Microsoft Excel on “Microsoft Excel - basic course” level.
Who the course is forThis course is assigned for users with basic
knowledge in Microsoft Excel.
What we teach youYou learn how to fully employ Microsoft Excel in
practice.
Required skillsMicrosoft Excel – basic course.
Teaching methodsProfessional explanation with practical samples and
examples.
Teaching materialsGopas guide book for this course.
Course syllabus
Formatting cells
- Cell style
- Conditional formatting
Template
Automatic saving
Working with files and sheets
Copying
- Series
- Using clipboard with Paste options
Creating formulas
- Inserting formulas rules
- Absolute addressing
- Naming of regions
Insert function wizard
- Examples of different types of functions
Databases and working with large tables
- Windows, panes, splitting
- Forms
- Validation
- Find, Replace, Go To
- Sorting
- Large tables printing options
Filters and working with lists
- AutoFilter and advanced filter
Managing databases accessories
- Text decomposition to columns
- Outlining, Grouping, Subtotals, Consolidation
- Pivot tables
Formatting charts
Recommended prior courses
MSEX107 - Microsoft Excel 2007 – Basic Course
MSSA - Microsoft Office 2007 – Application Co–operation
PCWI - PC and Windows – For Beginners
Recommended subsequent courses
MSEX307 - Microsoft Excel 2007 – Advanced Methods and Functions
MSEXE07 - Microsoft Excel 2007 for Economists
Catalog price of course and handbook
| Praha |
4200 Kč
|
--
|
0 items
|
| Brno |
3600 Kč
|
--
|
0 items
|
Course dates
|