Excel Intermediate, Private 1-to-1 Course
Details
What is included in this Excel intermediate course:
- Excel intermediate course certificate on completion (assessment based)
- Excel intermediate course notes
- Practical excel intermediate course exercises, excel intermediate course homework / excel intermediate course revision work
- Tea, coffees, but no lunch
- To assist after the course, 1 free session for questions online excel intermediate course via Skype or TeamViewer.
Outline
Working with Functions and Formulas
Creating Formulae in Excel, general calculations
The Function Wizard
Using Functions in Excel: The 5 Popular functions
If- function
Working with Names and Ranges
Copying formulae
Lookups
- Vlookup, Hlookup, Index, Match
Managing Tables
Working with Tables
Working with Records and Fields
Filters and Sorting, Freeze panes, split, protecting and unprotecting
Using Excel as a Database
Advanced filter: copy only specified rows and columns from a large data set, automate this selective copy
Pivot-tables
Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional formulas, Refresh Data.
Pivot Charts
Charts and Sparklines
Brief Overview of Charts and Sparklines
Schedules
| Tue | 11:00 AM — 06:00 PM |
| Tue | 11:00 AM — 06:00 PM |
| Tue | 11:00 AM — 06:00 PM |
| Tue | 11:00 AM — 06:00 PM |
| Tue | 11:00 AM — 06:00 PM |
| Tue | 11:00 AM — 06:00 PM |
PCWorkshops is a specialist provider of training courses in Java programming, databases and MS Project.
Customisation:- We can tailor courses. In addition, we are able to offer in-house training.
- What makes us different: all our Access Database, Excel, Word, Publisher, PowerPoint are offered as a standard on a 1-1 basis.
- The Excel VBA, Database Design, SQL, SSRS, SQL Report Builder and Java Courses are in groups of 4, but could also be 1-1.
- Software companies, testing companies,companies who employ software developers
- Coders and new coders who need Accredited Java qualification
- Data analysts and all others who use large sets of data
- Up-to-date relevant courses for todays’ business world
- Trainers with professional experience
- Award Winning Trainer
- 21 Years In Business
- Excellent Client References
- Classroom training with max class-size 4 people, virtual classrooms, 1-1 mentoring
- Customised training
- Assessment-based certificate, Oracle exam vouchers
- Weekdays, Evenings and Weekends
- At PCWorkshops, we love out job!
- MS Project Training.
- Database design and Data Normalisation.
- SQL Courses. ...
