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

76 Courses in London

MS Access Intermediate Course

4.6(12)

By PCWorkshops

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

MS Access Intermediate  Course
Delivered Online & In-PersonFlexible Dates
FREE

Advanced Bookkeeping Excel Courses online | Excel Training in Campus

By Osborne Training

Why Join Digital Marketing Training Course at Osborne Training Osborne Training is well Recognised for quality Regular Lectures led by Industry Expert Tutors Unlimited Access to the State of the Art Virtual Learning Campus Exclusive Access to High quality study materials Flexible payment option available Join Digital Marketing Training course as Pure Online or Blended with Classroom Delivery Access to Digital Marketing Internship for 3 months at the end of the training Unlimited Tutorial Support from expert tutors Get a Student Discount Card from NUS* Get a Free Tablet PC for limited period* Practical Hands-on Projects, Practical focused Assignments and Group-work for greater skills enhancement and understanding real life issues for real life problems Once you complete the bookkeeping course, you will get a certificate from Osborne Training confirming your professional Digital Marketing Qualifications. What jobs could I qualify for? Senior Digital Marketing Manager Digital Marketing Coordinator Executive Digital Marketing Strategist Digital Marketing Consultant In these roles, you could earn on average more than £40,000 annually (source: Reed Salary Checker, UK). Moreover, many go on to become successful (Millionaire sometime) entrepreneur by offering Digital Marketing services or formulating successful Digital Marketing Strategy for their own business. Digital Marketing Qualifications Digital Marketing Qualifications at Osborne Training are developed in Association with Google. Osborne Training offers Total Digital Marketing Course which combines all major skills required to be a successful Digital Marketeer and you also have option to join a complementary Internship at the end of your course. In joining the Total Digital Marketing Course at Osborne Training, you will make one of the greatest decision of your career and can look forward to a successful career in digital marketing. Digital Marketing Course Overview Total Digital Marketing Course covers major areas of Digital Marketing to make you completely ready for the digital era. The Digital Marketing course comes with optional Internship at the end of the training making you highly employable. Practical focused and hands-on approach of the training method helps you to be ready to offer real life solutions for real life problems. Digital Marketing Training Course Content Basics of marketing Marketing In Digital Era All About Web Search Engine Optimization Search Engine Marketing Affiliate Marketing Social Media Marketing Email marketing and nurturing (inbound) Mobile app marketing Content marketing Web, mobile and app analytics Growth Hacking Creating robust digital marketing strategy

Advanced Bookkeeping Excel Courses online | Excel Training in Campus
Delivered in Birmingham + 1 more or OnlineFlexible Dates
Price on Enquiry

Advanced Microsoft Excel Training Course on Bookkeeping

By Osborne Training

Advanced Microsoft Excel Training Course on Bookkeeping Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Advanced Microsoft Excel Training Course on Bookkeeping
Delivered in London or OnlineFlexible Dates
Price on Enquiry

Advanced Bookkeeping Excel Courses online | Excel Training in Campus

By Osborne Training

Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. A comprehensive training course with up to date material to practice at home and during your class. You will also be provided a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental programme for professional Accountants. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills on excel is a must for any potential professional accountants. You will receive an attendance certificate once you complete the course successfully. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Autocomplete, using styles, headers and footers, Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Sumifs Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Advanced Bookkeeping Excel Courses online | Excel Training in Campus
Delivered In-Person in Birmingham + 1 moreFlexible Dates
Price on Enquiry

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

For all of our courses go to tunneys.co.uk

By Tunneys

professional financial modelling and data analysis courses

For all of our courses go to tunneys.co.uk
Delivered In-PersonFlexible Dates
FREE
1...678

Educators matching " Microsoft Office"

Show all 85
Jobwise Training

jobwise training

3.2(6)

London

Fairgold Training & Development Ltd provide IT training courses on a freelance basis to organisations around the globe. Based in London we have provided courses as far a field as South Africa. Instructor Led Training All courses are instructor led, based on our wealth of experience and all training is backed up by a comprehensive delegate manual. In addition to our standard courses we build training to clients specifications ensuring we only cover the topics your organisation requires. Contact us today for a free consultation and discover how you can. – Maximise your investment IT – Become more productive and save time – Use Microsoft Office and the Internet to its maximum potential – Learn new skills, reduce stress and much more…. Incompany or Public Courses If you have a number of staff to train we can run Incompany courses. These courses are built from the ground up, around YOUR objectives and are delivered either, on your premises, or a fully furnished IT training centre. Mixed Ability Classes We can usually accommodate mixed ability classes without any problems. If you are unsure which course is best for you or if you have a number of delegates with mixed abilities contact us and we will advise you on the best route forward. Remember your consultation is FREE. PC Skills Training End-user application training courses are developed to maximise your investment in technology. Topics range from general PC awareness skills through to Advanced Microsoft Excel™. New Internet courses including ‘Fundamentals of Web Design’ and ‘Getting the most of the Web’ have been added to our portfolio. New Courses New courses are added to our portfolio in a continuing process to offer our clients a complete service. The latest addition being a Train the IT trainer course. Fairgold Wins Award for Excellence in Service At a prestigious award ceremony in London, Fairgold was presented with a second award for excellence in service delivery. The criteria was calculated over the last 700 delegates trained where the feedback score was excellent. Commenting on receiving it John Kelly said that the award was recognition of the hard work, determination and focus that Fairgold places on creating a perfect learning environment. We achieve the objectives of the course by ensuring every delegate takes full part in each and every course.