Microsoft Excel Workshops | Rugby
Microsoft Excel Workshop Rugby
 
Course Price: £145.00 Exc VAT
Support: Focus4 Training | Lumonics House, Valley Drive, Swift Valley Industrial Estate, Rugby, CV21 1TQ
Course Length: 1 Day
Contact Call us on (01455) 550622 or email info@focus4training.com


Choose a Date:


Level:


Select Version:


 
The standard Excel course outlines are below. If you wish to book one of the dates above today you can either choose one of these levels or choose the option for us to send you a link to our Training Needs Assessment. You have the opportunity to choose any topics you particularly wish to study or practice. The online assessments are straight forward and take minutes to complete. Once your date is booked we will send you a custom course outline for you to approve. We will work with you until you or your delegates are happy with the content. If you wish to book multiple delegates on different dates or you have any questions please contact us using the details below.

Excel Essential Skills
Understanding the Excel Interface
Understanding and Editing Formulas
Introduction to Functions
Decimal Places/Currency
Selecting Cells/Cell Referencing
Auto Sum and Auto Fill
Formatting Numbers and Cells
Working with Rows and Columns
Customising Worksheets
Edit, Copy and Move Cells
Introduction to Charts
Excel Intermediate
Functions including Min, Max, Sum
Count and Counta
Absolute and Relative References Percentages, Profit and Loss
Date Functions including Now()
Date and Number Series
Advanced Sort and Filter/Query Data Linking Data across Worksheets
Linking Data across other MS Programs
Consolidate Data
Conditional Formatting

Excel Advanced
Understanding IF Statements
IF/AND/OR Functions
SumIf and CountIf’s
Nested IF Functions
Lookup, VLookup and Hlookup
Working with PivotTables
Creating Pivot Charts
Creating and Editing Subtotals
Database Functions
What If Analysis – Goal Seek
What If Analysis – Scenarios

Creating Dynamic Dashboards in Excel

This is a hot topic for Excel users and a must have skill for any Excel user who prepares reports as the ability to create dynamic dashboards is increasingly becoming a requirement of employers. Dashboards are a visual display of your data. They convey the most important information at a glance and they often enable the user to interact with the report and choose how they view the data. They enable the reader to quickly make sense of the raw numbers by presenting them in visually rich charts and tables.

Course Location
Focus4 Training | Lumonics House, Valley Drive, Swift Valley, Rugby, Warwickshire

Our modern training rooms and comfortable rest areas provide a welcoming and relaxed learning environment. On arrival please proceed to the top floor where you will meet with your trainer and other course delegates over tea or coffee. A light lunch is provided with refreshments available throughout the day. Laptops are provided for the day and you receive full course notes to take away.

Course Schedule
Arrival: 9.15 am
Start: 9.25 am
Break: 11.30 am
Lunch: 1.15 pm
Finish: 4.00 pm

Lunch Included | Dress Code Casual | Pre Course Assessment | After Course Support | Course Certificate

Focus4 Training | Rugby