Excel Intermediate Course, Private 1-1
-
I truly enjoyed the class and the format it was present in, full of practical exercises, tips and ideas. Thank you, Sarah, for being such a great teacher.
← | →
-
Mary from PC workshops ran a very comprehensive and interesting 1-1 workshop for Excel skills. The modules were organised well and could be adapted to my needs in work. All the staff I talked to were incredibly helpful and communications were always fast and friendly
← | →
-
I had a fantastic day, lots of great information were provided. Would recommend.
← | →
Vocational qualification
Online
Description
-
Type
Vocational qualification Level 3
-
Methodology
Online
-
Duration
1 Day
Course summary
This Excel course is offered one-to-one, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but have many questions daily and want to be more proficient.
Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours
Facilities
Location
Start date
Start date
About this course
This course is lead by experienced professionals who concentrate on delivering quality training. The course content is organized into clear, well-structured and well-paced lessons with practical examples and exercises.
Reviews
-
I truly enjoyed the class and the format it was present in, full of practical exercises, tips and ideas. Thank you, Sarah, for being such a great teacher.
← | →
-
Mary from PC workshops ran a very comprehensive and interesting 1-1 workshop for Excel skills. The modules were organised well and could be adapted to my needs in work. All the staff I talked to were incredibly helpful and communications were always fast and friendly
← | →
-
I had a fantastic day, lots of great information were provided. Would recommend.
← | →
Course rating
Recommended
Centre rating
Karen Keller
Benjamin Jewel
Lisa Northeast
Steven Beddow
Maria Bosch
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Bookkeeping
- Excel2
2 students say they acquired this skill
- Accounting
- Microsoft excel training
22 students say they acquired this skill
- MS Excel
11 students say they acquired this skill
- Pivot tables
22 students say they acquired this skill
- Excel Tables
22 students say they acquired this skill
- Excel Functions and Formulas
22 students say they acquired this skill
- Excel Charts and Sparklines
22 students say they acquired this skill
- Excel Graphics
- Excel for Data Management
22 students say they acquired this skill
Teachers and trainers (1)
Mary Smith
Tutor
How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.
Course programme
Excel Intermediate Course 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
- Pivot-tables
Adding the Finishing Touches
- Adding Comments
- Using Themes
- Adding Text Boxes
Charts and Sparklines
- Adding and Editing Charts
- Adding and Editing Sparklines
Adding Graphics
- Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes
Excel Intermediate Course, Private 1-1
£ 260 VAT exemptAdd similar courses
and compare them to help you choose.{title}{centerName}{price}{price} {priceBeforeDiscount} {taxCaption}Training by subject
Colleges of Business Colleges of Design and Media Colleges of Finance Colleges of Health Colleges of Humanities, Social Science, Education Colleges of Industry and Science Colleges of IT, Computing, Telecommunications Colleges of Languages Colleges of Law and Defence Colleges of Personal Development Colleges of Sales and Marketing Colleges of Sports and Leisure Colleges of Tourism and Hospitality