• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

17 Microsoft Excel courses in Hythe, Hampshire

TEMA & HTRI Heat Exchanger Design & Cost Saving Management – Virtual Instructor Led Training (VILT)

By EnergyEdge - Training for a Sustainable Energy Future

Acquire in-depth knowledge of heat exchanger design and cost-saving management with EnergyEdge's TEM & HTRI course. Join our virtual instructor-led training to stay ahead in the industry.

TEMA & HTRI Heat Exchanger Design & Cost Saving Management – Virtual Instructor Led Training (VILT)
Delivered in Internationally or OnlineFlexible Dates
£2,099 to £2,199

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

By 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)
Delivered in Internationally or OnlineFlexible Dates
£1,500

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

By 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

Excel (but not like you've seen it before)
Delivered in Internationally or OnlineFlexible Dates
£1,500

Using Excel

5.0(50)

By Pochat Training

A series of hourly small group sessions where we look at different aspects of Excel Duration: 1 hr sessions Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £30 per hour, or £125 for 5-hour blocks.

Using Excel
Delivered in Chesterfield or UK Wide or OnlineFlexible Dates
£12.50 to £125

Excel - intermediate (In-House)

By The In House Training Company

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Excel - intermediate (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Excel - advanced (In-House)

By The In House Training Company

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Excel - advanced (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Microsoft Access Advanced - In-company / Bespoke

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office 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

Microsoft Access Advanced - In-company / Bespoke
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Educators matching "Microsoft Excel"

Show all 3
F-Keys Ltd

f-keys ltd

Canterbury

The Keys that open the doors to knowledge Alex Waterton is passionate about helping people to do things the easy way, which is why he started a business revealing the secrets of the Microsoft Office applications that people use every day. “There are easier ways to do many things in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft OneNote, Microsoft Access, Microsoft Project – and most people are just not aware of what’s possible,” he says. F-Keys was launched back in 1998 and became a limited company in March 2000 and the current team includes Carol Downey Microsoft Certfied Trainer, who started out originally as one of Alex’s students and worked her way up to become a Microsoft Office Specialist Instructor, and Microsoft Certfied Trainer just like Alex. Also on the team is Jo White, who was Alex’s tutor and mentor during his time at Mid-Kent College when he studied for his JEB Teaching Diploma qualification before continuing on to complete his Certificate in Education at Christ Church College Canterbury. Having developed a training suite that allows students to work in comfortable (rather than cramped) conditions, Alex and the team at F-Keys are flexible and passionate about designing the ideal learning solutions for individuals and businesses. “At F-Keys first we work to understand what a business wants to achieve and then the courses are customised and built around the learners. The focus is on how to make the most of the features and functionality within Microsoft Office so that the processes and people using them are ultimately more efficient and productive.” One of the most important aspects of the F-Keys training is to encourage people to become more confident and aware in their use of these programs, so that they begin to find their way around more easily to solve their own solutions rather than disturbing fellow staff members or simply following the manual blindly.

LearnDrive UK

learndrive uk

4.0(2)

Ashford

WELCOME TO LEARNDRIVE! YOUR TRUSTED ONLINE LEARNING PLATFORM! We Learndrive, are on a mission to provide easily accessible quality education and training for everyone around the world. As an online training provider, we strive to provide courses to help our learners achieve their academic and career goals. Learndrive offers a wide range of courses that are tailored to make them useful to individuals who are willing to learn. We are constantly working on delivering new and on-demand courses for our learners.   OUR MISSION & VISION The 4th industrial revolution is currently happening. Our mission at Learndrive is to empower organisations and individual employees so that they can adapt to this new way of living. We do so by providing flexible, effective skills training.  Here at Learndrive, we believe in expertise. Rather than providing shallow materials,  we provide a sophisticated platform on which the real subject experts can share knowledge with you- the learners. We provide premium learning materials so you can land your dream job. Learndrive has a clear mission; that is to get you ready for the new tech-based industrial era. The need for career advancement in this era goes far beyond mere training. Gaining in-depth subject knowledge is essential to unlocking your career goals. For this reason, we have a team that constantly works on producing premium learning materials.  Achieving our vision requires us to go to the experts in their relevant fields. With expert-written learning materials at Learndrive, you can enhance your credibility and boost your earning potential.  We want to help you reach the top of your career. The thousands of courses we offer are tailored by professionals in different fields so that you can easily grasp the concepts and apply them in real-world scenarios.  Our courses are based on industry-relevant curriculum with audio and video modules. We also offer assignments that test your learning and hone your skills. We also aid our learners to adapt to the updated industry compliance and practices. We offer our courses to students from the UK and all over the world. The focus of our organisation is to make you ready for the new industrial era. We offer our best to you without regard to race, language, or nationality.