Excel Advanced Course, 1-to-1, London, Live Online
Event Information
About this event
MICROSOFT EXCEL ADVANCED COURSE, PRIVATE 1-TO-1
Excel Advanced is for Excel Experts - you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications. Read more
EXCEL COURSE OUTLINE
General
- Editing Standard Formatting Rules
- Input Validate rules
- Using Formulas in Conditional Formatting
- Group and Outline
- Filter and Sorting
Data Insights with Pivot Tables
File and sheet Linking
- Referring to multiple sheets and external files within formulae and functions
- Working with multiple sheets
- Linking external files
Excel Tables and Advanced Filter
- Working with Excel tables
- Selectively Copy specific datasets, selective rows and columns from sheets, workbooks or external data
- Automate this process and integrate with data importing
Consolidate Goal seek, consolidate and scenarios Using Form Templates
- Creating Templates
Advanced Excel Lookup Functions
- VLookup Function
- Hlookup Function
- Using the Index Function,
- Using the Match Function,
- Index and Match Together
- Using the Indirect Function
Excel Advanced Functions
- Using Error, Logical, Array, Rounding Functions
Excel Macros
- Creating, amending and deleting macros
- Relative and Absolute recording of cell references
- Running macros
- Creating Macro menus, toolbars and shortcuts to execute macros by the click of a button
WHAT IS INCLUDED:
- Excel Course Certificate on completion
- Excel Course notes
- Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work
- To assist after the course, 1 free session for questions online
Organiser PCWorkshops
Organiser of Excel Advanced Course, 1-to-1, London, Live Online
At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.
More about us:
training@pcworkshopslondon.co.uk
- Our classes are instructor led, in our Live Virtual Classroom
- Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
- The maximum groups size that can access our Virtual Classroom, is 4.
- Every one gets personalised attention.
Why learn with us at PCWorkshops:
- Excellent, up-to-date courses, following latest trends and technologies.
- Excellent trainers with professional experience.
- 21 Years In Business
- Excellent Client References
- PCWorkshops Certificate
- Weekdays, Evenings and Weekends
- At PCWorkshops, we love out job!
We offer Training Courses in Software Packages:
- Java Programming
- Python Programming, Python data analytics, Python Machine Learning
- Database design and Data Normalisation
- SQL Courses
- Data Analysis and
- MS Excel, data analyses with Excel. Excel VBA
- Access Database Courses.
- MS Project Training
- MS Office Training
Our Style:
- Relaxed, Practical, Useful
Methods of instruction:
- Classroom training with max class-size 4 people
- Virtual classrooms via online video links
- 1-1 mentoring
- Customised training
Certification:
Our PCWorkshops certificates are assessment based.
Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.
Our clients are:
Data analysts and all others who use large sets of data
Software companies, testing companies, companies employing software developers
Coders and new coders who need Accredited Java qualification
Customisation:
We can tailor all our courses. Email to customise location, times, content.
