Excel Intermediate 1-Day Course, Private 1-to-1, Birmingham, Virtual
by PCWorkshops
Date and time
Location
Online event
Refund policy
No Refunds
Excellent Excel Intermediate Course covering intermediate level techniques in one day. Practical. Online. Instructor-led.
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