Excel Intermediate 1-Day Course, Private 1-to-1, Birmingham
Event Information
About this event
EXCEL INTERMEDIATE COURSE, PRIVATE 1-TO-1
ONLINE in our Virtual Classroom. Connection Details provided upon bookingRead More
COURSE SUMMARY
This Excel course is offered one-to-one, because we understand that professionals have varying skill levels and varying applications.
You already have the basic Excel skills and would like to sharpen your skills.
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
- Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional formulas, Refresh Data.
- Pivot Charts
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
WHAT IS INCLUDED:
- PCWorkshops Certificate
- Course notes
- Practical Class exercises, Homework / Revision work
- To assist after the course, 1 free session for questions online via gotomeeting.com
Organiser PCWorkshops
Organiser of Excel Intermediate 1-Day Course, Private 1-to-1, Birmingham
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 szie 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 tecnologies.
- Excellent trainers with professional experience.
- We offer stress free training: we start at 11am, giving you time to attend toto the necessary emails etc. before starting.
- 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
- Tableau, MS Power BI, SSRS, and MS Excel Dashboards
- 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 presitigeous, international Oracle Certified Associate qualification.
Our clients are:
Data analysts and all others who use large sets of data
Software companies, testing companies,companies who employ software developers
Coders and new coders who need Accredited Java qualification
Customisation:
We can tailor all our courses. Email to customise location, times, content.
