Discover powerful Excel techniques in an interactive, instructor-led, live Virtual Classroom.
This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc.
In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues.
During the course you will excellent spreadsheets so that you have examples to take away.
Location: Instructor-led, Online.
Our Style: Hands-on, Practical Course.
Group Size: Max 4 people per group.
Qualification: PCWorkshops Excel Intermediate Certification
Hours: 1 Day, 10am-5pm
Outline:
Working with Functions and Formulas
The Function Wizard
Using Functions in Excel: The 5 Popular functions
If-else function
Working with Names and Ranges
Copying formulae
Creating Formulae in Excel, general calculations.
Lookups:
Vlookup,
Hlookup,
Index,
Match.
Formatting a Range as a Table:
Properties and behaviour of a table.
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: copy only specified rows and columns from a large data set, auto mate this selective copy.
Pivot-tables:
Create Pivot Table, Refresh Data.
Amend, Filter, Sort,
Format Pivot Tables,
Add additional Pivot formulae.
Pivot Charts:
Excel Pivot Charts and Sparklines.
Examples and exercises with Pivot Charts and Sparklines.
Other Excel Courses
Included with the Excel Intermediate Courses
PCWorkshops Excel Intermediate Certificate on completion
Excel Intermediate Notes
Excel Code Examples
Practical Excel Intermediate exercises
Personal attention in a small group of up to 4 delegates
PCWorkshops deliver's computer programming, database and data visualization courses to companies of all industries and sizes in city centers near our locations.
Our head-quarters are in London.
We customize programming courses and query development courses on request per company.
Whether you are a new user or have been using Word for years, this course will vastly increase your understanding of Word.
Anyone attending our Intermediate Word 2016 training class should already be able to create, edit, and print Word 2016 documents on Windows. In this Word 2016 session, delegates will learn advanced formatting, use Word 2016 drawing tools, create and manage tables, and work with column layouts.
Microsoft Word combines a powerful word processing application with the user-friendly atmosphere of Windows. Training participants will learn the basics of creating, editing, and saving documents in our Fundamentals level class.
Microsoft Visio course is offered by Eident. Eident deliver scheduled and on-demand IT skills training courses
Now that more presentation are being delivered online, it's even more important to use PowerPoint effectively, to engage your audience. Learn how to prepare professional presentations with our PowerPoint course modules.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy