Name: Microsoft Excel Introduction - 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 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)

<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)

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

<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)

London

<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

Office Skills & Productivity

Computing Skills

Excel Analytics

Microsoft Excel

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 

Microsoft Office Training

Microsoft Power BI

Microsoft Excel Advanced - In-company

<p><strong>Course Objectives</strong></p><p>This course aims to provide delegates with a foundation for Excel knowledge and skills.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Very professional and well mannered, fun and pleasant at the same time. I learnt a lot</strong></li><li>Carolina Foster - CNN</li></ul><ul><li><strong>Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.</strong></li><li>Laura Smith - James Grant</li></ul><ul><li><strong>Great course and excellent trainer. Thanks</strong></li><li>Tracy Preston - Western Power Distribution</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<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><strong>What is Excel?</strong></p><p><strong>The Excel Interface</strong></p><ul><li>Ribbon, Tabs and Groups</li><li>Microsoft Office Backstage view</li></ul><p><strong>Working with Workbooks</strong></p><ul><li>Create a blank Workbook</li><li>Create a Workbook using a Template</li><li>Opening and saving Files</li></ul><p><strong>Working with worksheets</strong></p><ul><li>Worksheet navigation</li><li>Select one or multiple Worksheets</li><li>Insert, Move, Copy or Delete a Worksheet</li></ul><p><strong>Working with Cells, Rows &amp; Columns</strong></p><ul><li>Cell References</li><li>How to select cells or ranges</li><li>Different types of data</li><li>Move, Copy and Delete cells</li><li>Pasting Options</li><li>Find and Replace</li><li>Working with Rows and Columns</li></ul><p><strong>Overview of formulas in Excel</strong></p><ul><li>Autocalculation</li><li>The parts of an Excel formula</li><li>Using calculation operators in Excel formulas</li><li>The difference between Absolute, Relative and Mixed references</li><li>Using Excel functions; Sum, Average, Max and Min</li></ul><p><strong>Cell Formatting</strong></p><ul><li>Font Format options</li><li>Number Format options</li><li>Change the Fill and Borders</li><li>Cell Alignment</li></ul><p><strong>An Introduction to Charts</strong></p><ul><li>Create a simple Chart</li><li>Format your chart</li></ul><p><strong>Page Layout and Print</strong></p><ul><li>Page Layout and Page Break View</li><li>Change the Page Orientation</li><li>Set Page Margins</li><li>Headers and Footers in a worksheet</li><li>Print a worksheet or workbook</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>All users who want to master the main features of Microsoft Excel</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</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
This course aims to provide delegates with a foundation for Excel knowledge and skills.
'
Customer Feedback
Very professional and well mannered, fun and pleasant at the same time. I learnt a lot
Carolina Foster - CNN
Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.
Laura Smith - James Grant
Great course and excellent trainer. Thanks
Tracy Preston - Western Power Distribution
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.
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.
What is Excel?
The Excel Interface
Ribbon, Tabs and Groups
Microsoft Office Backstage view
Working with Workbooks
Create a blank Workbook
Create a Workbook using a Template
Opening and saving Files
Working with worksheets
Worksheet navigation
Select one or multiple Worksheets
Insert, Move, Copy or Delete a Worksheet
Working with Cells, Rows & Columns
Cell References
How to select cells or ranges
Different types of data
Move, Copy and Delete cells
Pasting Options
Find and Replace
Working with Rows and Columns
Overview of formulas in Excel
Autocalculation
The parts of an Excel formula
Using calculation operators in Excel formulas
The difference between Absolute, Relative and Mixed references
Using Excel functions; Sum, Average, Max and Min
Cell Formatting
Font Format options
Number Format options
Change the Fill and Borders
Cell Alignment
An Introduction to Charts
Create a simple Chart
Format your chart
Page Layout and Print
Page Layout and Page Break View
Change the Page Orientation
Set Page Margins
Headers and Footers in a worksheet
Print a worksheet or workbook
 Who is this course for? Who is this course for? 
All users who want to master the main features of Microsoft Excel
 Requirements Requirements 
General knowledge of the Windows OS
 Certificates Certificates 
Certificate of completion
 Digital certificate - Included 

Educators providing Money Management Tools courses in Clay Cross

Search By Location