Name: Microsoft Excel Intermediate - 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>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our 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 public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, 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><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction 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
The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.
'
Customer Feedback
Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.
Kelly Moreley - TACT
Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.
Jenny Price - Acer
1 year email support service
Take a look at the consistent excellent feedback from our 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.
Tailored training courses:
In, in company training, 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.
Recap on Excel formulas and calculations
Overview of formulas in Excel
Relative, Absolute and Mixed cell references
Group editing worksheets
Autofill and Flash Fill
Changing Excel’s environment Options
Changing the default number of sheets
Creating an Autofill Custom List
Adding tools to the Quick Access Toolbar
Mastering Excel Tables
Introducing Excel Tables
Formatting a Table
Creating Calculated Columns
Using Slicers to filter your data
Using Totals to get statistics out of your data
Removing duplicates
Converting Tables back to normal Ranges
Using names Ranges
In Excel formulas
As a way of navigating through the workbook
Advanced Formulas
Simple IF examples
Using IF to check if a cell is blank
Nested IFs
VLOOKUP
HLOOKUP
Text Functions
Date Functions
Conditional formatting
Apply Conditional Formatting
Customising Conditional Formatting
Using Icons in Conditional Formatting
Using Formulas to conditionally format cells
Linking spreadsheets and workbooks
Making a reference to another worksheet
Making a reference to another workbook
Editing links
Troubleshooting links
Analysing databases
Quick analysis
Sorting a database
Apply filters to a database
Advance filter
Sorting and Filtering by Conditional Formats
Charts
Analyse trends in data using Sparklines
Creating charts from start to finish
Exploring the different Chart Types
Apply Chart Styles
Formatting Chart Elements
Filtering Charts by Series or Categories
Adding a Trendline to a Chart
Create a Chart Template
Attaching security to a spreadsheet and workbook
Protect Cells
Protect Structure of worksheets
Protect a Workbook by adding passwords
Introduction to Pivot Tables
What are Pivot Tables?
Using recommended pivot tables to analyse your data
 Who is this course for? Who is this course for? 
For those who want to explore in more detail formulas and functions, data analysis and data presentation.
 Requirements Requirements 
Preferably, delegates would have attended the Excel Introduction 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 Market Drayton

Search By Location