Name: Microsoft Excel Advanced - In-company
Price: 650 GBP
Availability: InStock

Letchworth

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(100, 102, 108);">These remote training sessions are flexible to enable you to pick and choose the features within FreeAgent that you would like to focus on, and ensure you maximise your training. These sessions can cover FreeAgent Accounting or Payroll - let us know your requirements.</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp;</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.</span></p>

These remote training sessions are flexible to enable you to pick and choose the features within FreeAgent that you would like to focus on, and ensure you maximise your training. These sessions can cover FreeAgent Accounting or Payroll - let us know your requirements.

Request a date, and we'll suggest some options so you can pick a time to suit you. 

If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

Back Office Software Support Ltd T/A Boss

Remote training session for FreeAgent Accounting and Payroll software.

FreeAgent Training Session (1 Hour)

1 Hour Xero Training Session

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(100, 102, 108);">These remote training sessions are flexible to enable you to pick and choose the features within Sage that you would like to focus on, and ensure you maximise your training. These sessions can cover Sage Accounting or Payroll - let us know your requirements.</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp;</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.</span></p>

These remote training sessions are flexible to enable you to pick and choose the features within Sage that you would like to focus on, and ensure you maximise your training. These sessions can cover Sage Accounting or Payroll - let us know your requirements.

Request a date, and we'll suggest some options so you can pick a time to suit you. 

If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

Sage Payroll

Remote training session for Sage Accounting and Payroll software.

Sage Training Session (1 Hour)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(100, 102, 108);">These remote training sessions are flexible to enable you to pick and choose the features within QuickBooks that you would like to focus on, and ensure you maximise your training. These sessions can cover QuickBooks Accounting or Payroll - let us know your requirements.</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp;</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.</span></p>

These remote training sessions are flexible to enable you to pick and choose the features within QuickBooks that you would like to focus on, and ensure you maximise your training. These sessions can cover QuickBooks Accounting or Payroll - let us know your requirements.

Request a date, and we'll suggest some options so you can pick a time to suit you. 

If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

QuickBooks

Remote training session for QuickBooks Accounting and Payroll software.

QuickBooks Training Session (1 Hour)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(100, 102, 108);">These remote training sessions are flexible to enable you to pick and choose the features within Xero that you would like to focus on, and ensure you maximise your training. These sessions can cover Xero Accounting or Payroll - let us know your requirements.</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp;</span><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><br style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style=" color: rgb(100, 102, 108);"><span style="color: rgb(100, 102, 108); box-sizing: border-box;" fr-original-style="color: rgb(100, 102, 108);">If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.</span></p>

These remote training sessions are flexible to enable you to pick and choose the features within Xero that you would like to focus on, and ensure you maximise your training. These sessions can cover Xero Accounting or Payroll - let us know your requirements.

Request a date, and we'll suggest some options so you can pick a time to suit you. 

If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

Remote training session for Xero Accounting and Payroll software.

Xero Training Session (1 Hour)

Chesterfield

<h2 style="color: var(--list-section-simple-card-title-color); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--list-section-simple-card-title-color);">DAY VISIT - WITH YOU &amp; YOUR XERO.</h2><div style="color: rgb(53, 53, 53); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);"><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(53, 53, 53);">Our signature bespoke onsite Xero Training is for 5 hours with a short break in the middle (typically 10am - 3pm)</p><p data-rte-preserve-empty="true" style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);"></p><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);">Ideal for business that:</p><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);">✔️ have been using Xero for more than a year, without any help.</p><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);">✔️ would like expert support with Xero.</p><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);">✔️ have errors or issues in Xero &amp; need help with fixing them.</p><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);">✔️ would like to get an add-on set up &amp; connected to Xero properly.</p><p style="color: rgb(53, 53, 53); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(53, 53, 53);">✔️ are converting to Xero from another accounting system &amp; want to get everything set up correctly.</p></div>

DAY VISIT - WITH YOU & YOUR XERO.
Our signature bespoke onsite Xero Training is for 5 hours with a short break in the middle (typically 10am - 3pm)

Ideal for business that:
✔️ have been using Xero for more than a year, without any help.
✔️ would like expert support with Xero.
✔️ have errors or issues in Xero & need help with fixing them.
✔️ would like to get an add-on set up & connected to Xero properly.
✔️ are converting to Xero from another accounting system & want to get everything set up correctly.

Progression Accountancy

Xero

Our bespoke Xero Training sessions are designed to get your Xero working properly & showing you the correct information, and to save you time for the important things...
Get Xero set up properly, working as it should, error free
Fix all of your Xero issues, once & for all
Learn how to deal with your transactions correctly
Use reporting to understand how your business is performing
Gain confidence using Xero
Save oodles of time on your accounting every single day with our bespoke Xero Training!

XERO TRAINING "DAY VISIT" (IN PERSON)

General admission

Birmingham

Bolton

Bradford

Bristol

Cambridge

Coventry

Derby

Gloucester

Hertford

High Wycombe

Huddersfield

Hull

Leeds

Leicester

Liverpool

London

Luton

Manchester

Melton Mowbray

Middlesbrough

Milton Keynes

Northampton

Norwich

Nottingham

Oxford

Peterborough

Reading

Sheffield

Slough

Solihull

Stoke-on-Trent

Swindon

Telford

Warrington

Watford

Wolverhampton

Worksop

York

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Microsoft Excel trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outlines</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_in_leeds.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Beginners - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_birmingham_excel_training_coventry.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Intermediate - 1-2 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_aylesbury_excel_training_milton_keynes.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Advanced - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_masterclass_course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Masterclass&nbsp;- 3 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_power_query_training_course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Power Query - 1 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pricing</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;450.00 plus VAT per day and mileage for up to 3 learners. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

Our regionally-based associate Microsoft Excel trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.
Course Outlines
Excel Beginners - 1 day course
Excel Intermediate - 1-2 day course
Excel Advanced - 1 day course
Excel Masterclass - 3 day course
Excel Power Query - 1 day course
Pricing
£450.00 plus VAT per day and mileage for up to 3 learners. Just add £50.00 plus VAT per additional learner up to the 10 delegate maximum.

FourSquare Innovations Ltd

Office Skills & Productivity

Office Skills

Microsoft Excel

Spreadsheet

FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.

Microsoft Excel Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You&#39;re OK at Excel, maybe you&#39;re great, we get it. Maybe you&#39;re the person people come to in the office to fix their spreadsheets, maybe you just like tinkering in Excel.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Did you ever wonder if there was something more?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">VBA will enable you to harness the full power of your spreadsheets.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Any repetitive tasks? Automated.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Any jobs that often end up with errors due to their complexity? Not any more.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need to collect and analyse data quickly? Done.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">These VBA sessions will not only teach you great coding best practices and ensure you know your way around the Development Environment, it will give you the practical skills to automate your workflow.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We also give you the resources to take your knowledge further</p>

You're OK at Excel, maybe you're great, we get it. Maybe you're the person people come to in the office to fix their spreadsheets, maybe you just like tinkering in Excel. 
Did you ever wonder if there was something more? 
VBA will enable you to harness the full power of your spreadsheets. 
Any repetitive tasks? Automated. 
Any jobs that often end up with errors due to their complexity? Not any more. 
Need to collect and analyse data quickly? Done. 
These VBA sessions will not only teach you great coding best practices and ensure you know your way around the Development Environment, it will give you the practical skills to automate your workflow.
We also give you the resources to take your knowledge further

Alumno Consulting

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Visual Basic for Applications (VBA) in Excel (from cool to geek in less than 1 day)

Class (max 20)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Excel but different. Harness this most powerful tool but on a course tailored to your business and needs.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn&#39;t a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge</p>

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. 
Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. 
Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. 
They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel (but not like you've seen it before)

<h2>Microsoft Excel® in Depth: In-House Training</h2>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li> 
 <li>Create meaningful charts</li> 
 <li>Use pivot tables</li> 
 <li>Use Conditional Formatting, Data Validation</li> 
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li> 
 </ul><section>
                    <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


                </section>

Microsoft Excel® in Depth: In-House Training
The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.
This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.
What you Will Learn
You'll learn how to:
Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more
Create meaningful charts
Use pivot tables
Use Conditional Formatting, Data Validation
Take advantage of using Named ranges, do sorting, filtering, tables
Getting Started
The building blocks of Excel, built-in functions, will be examined
The basics of formatting your data will be examined
Shortcuts and data manipulation will be explored
Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail
Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more
Using Named ranges, Data Validation, Sorting, and Filtering
Learn the Name manager;
Learn the difference between local and global names;
Ensure correct access to linked workbooks;
Ensure data accuracy;
Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);
Sorting by more than 3 fields;
Filtering by font, pattern, or value;
See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value
Conditional formatting and data formatting
Make relevant data stand out
Isolate highs and lows
Make error cells invisible
Learn about Data bars, Icon sets, and Color scales
Highlight differences between worksheets
Learn all the codes in the Format/Number list
Using cell Styles
Learn all about alignment, protection, borders, colors and more
Pivot Tables
Learn how to summarize large amounts of data with a few clicks
Learn various ways of presenting the data
Learn the various pivot table tools
Learn how to customize and format a pivot table to suit your needs
Learn how to group data
Learn how to use the various options to present your data
Charts
Learn how to create a chart with one keystroke!
Learn the 11 types of built-in charts
Learn how to create a chart with one keystroke!
Learn how to customize the charts to make the information tell the right story
Learn how to use the design, layout, and formatting available to charts in Excel 2007
Learn embedded charts versus chart sheets
Learn how to use modify all the pieces of a chart
Array formulas
Learn how to use the most powerful formulas in Excel
Learn how to combine many formulas into one compact array-formula
Learn the real power of these formulas and why regular formulas can't do the job
Learn how to use built-in array formulas, like TREND or TRANSPOSE

IIL Europe Ltd

Computing Skills

Excel Analytics

Microsoft Office

Microsoft Access

Microsoft Excel in Depth: In-House Training

General Admission

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Course Objectives
At the end of this course you will be able to:
Work with advanced lookup and reference functions
Create macros to automate common tasks
Use advanced techniques to analyse data
Create PivotTables and PivotCharts
Work with data validation tools
Import and export data
'
Customer Feedback
Best Training Ever!
Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.
Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All
The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.
Marving Lopez - AM Best Europe
Pedro was excellent. Very knowledgeable, clear and great rapport with class.
Darren Barkey - Direct Wines
Great content and learnt a lot. Really enjoyable :)
Kristie-Lee Ryan - Stirling Ackroyd
1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.
Advanced Functions
COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL
IF, OR, AND, IFERROR
VLOOKUP to lookup Exact Values and Approximate values
MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET
Analysing Data
PMT function to calculate a monthly payment of a loan
What If Analysis using Goal Seek
Use scenarios to consider many different variables
Using Solver Add-in to optimize variables
PivotTables
Create a PivotTable to analyse worksheet data
Add or remove fields in a PivotTable
Change the data source for a PivotTable
Working with external data sources
Using different Statistical Functions
Calculate a Running Total, % of Grant Total, Difference From…
Using the Slicer and Timeline to filter the PivotTable
Using Filters in a PivotTable
Group by Date, Auto Group by ranges of values, Custom Group
Create a PivotChart
The GETPIVOTDATA function
Formula auditing
Precedents and dependents
Error checking
Watch a formula and its result by using the Watch Window
Evaluate a nested formula one step at a time
Data Validation
Number Validation
Data List Validation
Message Prompts and Alerts
Conditional Data Validation
Data Validation Errors
Consolidation
Consolidate data by position
Consolidate data by category
Use a formula to consolidate data
Outline (group) data in a worksheet
Create an outline of rows
Create an outline of columns
Copy outlined data
Hide or remove an outline
Connect external data to your workbook
Using the Power Query Editor to import data
From Text and CSV, From Access, From Web, From another Workbook
Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.
Deleting Applied Steps
Refreshing your data
Working with Form Controls; Buttons, Option Buttons and Scroll Bars
Introduction to Macros
Change Macro Security settings
How to Record a macro
Some Macro Examples
Delete a macro
Edit the macro to view the VBA code
Copy part of a macro to create another macro
Assign a macro to a button
 Who is this course for? Who is this course for? 
This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.
 Requirements Requirements 
Preferably, delegates should have attended the Excel Intermediate course.
 Career path Career path 
Excel know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills
 Certificates Certificates 
Certificate of completion
 Digital certificate - Included 

Educators providing Money Management Tools courses in North Wingfield

Search By Location