Offer Type
Offered
Event Type
Consumer Goods
This Excel course is offered one-to-one or in small group of up to 4, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but habe many questions daily and want to be more proficients. Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours
COURSE OUTLINEWorking 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 folmulas, 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
- Certificate on completion (assessment based)
- Course notes
- Practical Class exercises, Homework / Revision work
- Tea, coffees, but no lunch
- To assist after the course, 1 free session for questions online via Skype or Teamviewer.
Venue:
One Victoria Square
Birmingham, B1 1BD
Dates