374 Spreadsheet courses delivered Online

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 52% of UK employers cite poor digital functional skills as a barrier to recruitment? Or that effective communication and presentation skills can boost your salary by 15%? In a world increasingly driven by technology, honing your functional skills is no longer optional; it's crucial for career success. This Functional Skills: IT, CSS & Office Administration Bundle equips you with the essential tools to thrive in the digital age. From mastering essential IT skills and web development fundamentals to acing office administration and presentation techniques, this comprehensive Functional Skills package empowers you to become a well-rounded professional, ready to tackle any challenge. This Functional Skills: IT, CSS & Time Management Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Essential IT Skills Level 2 Course 02: Fundamentals of CSS Course 03: Office Administration & Skills Diploma Course 04: Time Management Investing in yourself is the smartest investment you can make. This Functional Skills: IT, CSS & Office Administration bundle is your passport to a brighter career future. Don't wait! Enrol today in our Functional Skills: IT, CSS & Office Administration bundle and watch your confidence and opportunities soar. Learning Outcomes of Functional Skills: IT, CSS & Office Administration Gain proficiency in essential IT skills for workplace applications. Master CSS fundamentals for creating visually stunning web designs. Develop comprehensive office administration and management skills. Acquire effective time management strategies for increased productivity. Enhance problem-solving and critical thinking abilities in IT. Understand web development principles and best practices. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Functional Skills: IT Get a free student ID card with Functional Skills: IT Training program (£10 postal charge will be applicable for international delivery) The Functional Skills: IT is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Functional Skills: IT course materials The Functional Skills: IT comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Essential IT Skills Level 2 Module 01: Introduction: A Transforming Technology Module 02: Importance of Information Technology Module 03: Communication and Network Module 04: Future Skills Required in Information Technology Module 05: Technology as a Foundation Skill Area Module 06: Word Processing Software Module 07: Presentation Software Module 08: Creating and Editing Spreadsheet (Part 1: The Basics of Spreadsheets) Module 09: Creating and Editing Spreadsheet (Part 2: Navigation and Edit) Module 10: Storing Database Module 11: Information Technology Project Management Course 02: Fundamentals of CSS Unit 01: CSS In Context Module 01: What Was CSS Originally Intended To Do? Module 02: DEMO: The Most Basic CSS Usage Module 03: Responsive Design Module 04: Chapter Summary Unit 02: Overview Of CSS Module 01: What is CSS? Module 02: Where Can You Find CSS? Module 03: What CSS Can and Can't Do Module 04: Optional Demo - Serving an HTML Application Module 05: How Do we Add CSS to a Website? Unit 03: Styling HTML Elements With CSS Module 01: Why do We Style CSS Elements? Module 02: CSS and Fonts Module 03: DEMO: Styling Text with CSS Module 04: Sizing HTML Elements with CSS Module 05: DEMO: Sizing HTML Elements with CSS Unit 04: Arranging Elements With CSS Module 08: Summary of this Chapter Module 01: Introduction Module 02: Adding Margin with CSS Module 03: Advanced Positioning with CSS Module 04: DEMO: Positioning Elements Absolutely and Relatively Module 05: Positioning HTML Elements with Float Course 03: Office Administration & Skills Diploma Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language And Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 04: Time Management Module 01: Importance And Benefits Of Time Management Module 02: Assess Your Current Work Practice Module 03: Identify The Priorities Module 04: Overcome Procrastination Module 05: Set Your Goals Module 06: Plan The Work And Work The Plan Module 07: Effective Time Management Techniques Module 08: The Art Of Anticipating How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Functional Skills: IT, CSS & Office Administration bundle. This bundle is ideal for: Office professionals School leavers Job seekers Anyone seeking in-demand skills Requirements You will not need any prior background or expertise to enrol in this Functional Skills: IT, CSS & Office Administration bundle. Career path After completing this Functional Skills: IT, CSS & Office Administration bundle, you are to start your career or begin the next phase of your career. Admin Assistant IT Support Web Developer Project Manager Office Manager Business Analyst Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Master the skills you need to propel your career forward in instructional design. Equip yourself with the essential knowledge and skillset that make you a confident teacher or teaching assistant and take your career to the next level. This comprehensive course is designed to help you reach your professional goals. The skills and knowledge that you will gain through studying this instructional design diploma course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective instructional design practice and equip you with the essential skills, confidence and competence to assist you in the instructional design industry. You'll gain a solid understanding of the core competencies required to drive a successful career in instructional design. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive course is designed for instructional design professionals who are aspiring to specialise in instructional design. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction and Welcome to Curriculum Structural Design Start Here - Instructional Des 00:04:00 What Makes an Amazing Training Curriculum - Part 1 00:14:00 What Makes an Amazing Training Curriculum - Part 2 00:13:00 Identify With Your Audience Identify With Your Audience Introduction 00:05:00 Identify Their Roles 00:17:00 Identify Their Goals 00:09:00 Identify Their Why 00:18:00 Identify What They Do Identify What They Already Do 00:15:00 Identify What They Already Do Activity 00:18:00 Identify What They Want to Do 00:07:00 Identify What They Need to Do 00:09:00 Organize What They Do Organize What They Do Intro 00:07:00 Organize Tasks and Subtasks 00:19:00 Organize Tasks and Subtasks - Part 2 00:19:00 Create Modules and Lessons 00:16:00 Set Up a Curriculum Design Spreadsheet 00:20:00 Determine What to Teach Understanding Objectives 00:15:00 Understanding Objectives Activity 00:16:00 Determine Conventions to Teach 00:17:00 Determine Algorithms to Teach 00:17:00 Determine Concepts to Teach 00:17:00 Organize What to Teach Simplify and Group Objectives Part 1 00:06:00 Simplify and Group Objectives Part 2 00:17:00 Add Objectives to the Curriculum Design Spreadsheet 00:09:00 Mark Objectives For Assessments 00:11:00 Determine the Initial Class Structure Solidify Specific Course Groupings 00:15:00 Customize Course Titles and Lesson Titles 00:06:00 Determine Course Timelines 00:20:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Looking for an easy to use and functional spreadsheet application. Look no further as this course will get you started on becoming a professional on the most important spreadsheet application, Microsoft Excel 2007. Microsoft Excel 2007 is part of the Microsoft Office suite of programs which is the most widely used software package on Earth. Excel 2007 is a great tool for simple or complex calculations, particularly ones which you want to repeat. You can use this software to visualize data as well. You can use this useful tool to deal with large quantities of data, for quick data manipulation, for checklists and status reporting. Use pivot tables to aggregate and filter data. During this course, you will learn all the functions of Microsoft Excel 2007 and will make you a professional at representing your data. At the end of the course you will be able learn all there is to know about Microsoft Excel and be fully capable of presenting data or solving any problems regarding Microsoft Excel. Course Highlights Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced into 26 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 22 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Final Exam

Overview Do you want to start a fulfilling career in accounting and become an expert with numbers? Your ideal place to start is with our simple Accounts Assistant Training!Go beyond the fundamentals, become an expert in critical areas like software and bookkeeping, and acquire the strength to handle payroll and taxes. To make your CV stand out, add a reputable CPD certification. Don't wait; secure your future as an accomplished accounting professional now! Enrol right away to see your career grow! How will I get my certificate? Upon successful completion of the Accounts Assistant Training course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is This course for? No prior knowledge? Don't worry! This Accounts Assistant Training course is open to all, regardless of academic background. The only requirement is that you be curious. Requirements Our Accounts Assistant Training course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. Career Path Having these various qualifications will increase the value of your CV and open you up to multiple sectors, such as: Accounts Assistant: £18,000 - £30,000 per year Bookkeeper: £20,000 - £35,000 per year Assistant Accountant: £25,000 - £40,000 per year Finance Officer: £30,000-£45,000 per year Management Accountant: £35,000-£55,000 per year Note: Salaries vary based on experience, location, and industry. Course Curriculum 5 sections • 69 lectures • 10:02:00 total length •Getting the Facts Straight.: 00:30:00 •The Accounting Cycle: 00:30:00 •The Key Reports.: 00:30:00 •A Review of Financial Terms.: 00:30:00 •Understanding Debits and Credits.: 00:15:00 •Your Financial Analysis Toolbox.: 00:30:00 •Identifying High and Low Risk Companies.: 00:30:00 •The Basics of Budgeting .: 00:15:00 •Working Smarter.: 00:10:00 •Professional Bookkeeper .: 00:09:00 •Defining a Business.: 00:07:00 •Ethics in Accounting: 00:05:00 •Generally Accepted Accounting Principles (GAAP) .: 00:10:00 •The Accounting Equation.: 00:07:00 •Transactions .: 00:11:00 •Financial Statements .: 00:13:00 •The Accounting Equation and Transactions.: 00:16:00 •Double-Entry System.: 00:12:00 •Transactions - Journalizing .: 00:17:00 •Journal Entries.: 00:38:00 •Posting Entries.: 00:10:00 •The Trial Balance.: 00:10:00 •Finding Errors Using Horizontal Analysis.: 00:09:00 •Horizontal Trend : Balance Sheet.: 00:21:00 •Horizontal Trend: Income Statement.: 00:36:00 •The Purpose of the Adjusting Process.: 00:15:00 •Adjusting Entries - Prepaid Expenses.: 00:13:00 •Adjusting Entries - Accrued Revenues.: 00:10:00 •Adjusting Entries - Depreciation Expense.: 00:09:00 •Adjustment Summary - Review.: 00:13:00 •Vertical Analysis.: 00:33:00 •Preparing a Worksheet.: 00:06:00 •The Income Statement.: 00:11:00 •Financial Statements - Definitions.: 00:12:00 •Temporary vs. Permanent Accounts.: 00:19:00 •Accounting Cycle Illustrated - Steps 1-5.: 00:11:00 •Accounting Cycle Illustrated - Steps 6-10.: 00:12:00 •Fiscal Year.: 00:09:00 •Spreadsheet Exercise - Steps 1-4.: 00:11:00 •Spreadsheet Exercise - Steps 5-7.: 00:37:00 •Module One - Introduction: 00:30:00 •Module Two - Basic Terminology.: 01:00:00 •Module Three - Basic Terminology (II).: 01:00:00 •Module Four - Accounting Methods.: 01:00:00 •Module Five - Keeping Track of Your Business.: 01:00:00 •Module Six - Understanding the Balance Sheet.: 01:00:00 •Module Seven - Other Financial Statements.: 01:00:00 •Module Eight - Payroll Accounting Terminology.: 01:00:00 •Module Nine - End of Period Procedures.: 01:00:00 •Module Ten - Financial Planning, Budgeting and Control.: 01:00:00 •Module - Eleven Auditing.: 01:00:00 •Module Twelve - Wrapping Up.: 00:30:00 •Tax System in the UK: 01:00:00 •What Is Payroll?.: 00:30:00 •Principles Of Payroll Systems.: 01:00:00 •Confidentiality And Security Of Information..: 00:30:00 •Effective Payroll Processing.: 01:00:00 •Increasing Payroll Efficiency.: 01:00:00 •Risk Management in Payroll.: 00:30:00 •Time Management: 00:30:00 •Personnel Filing.: 00:30:00 •When Workers Leave Employment.: 01:00:00 •Hiring Employees.: 00:30:00 •Paye and Payroll for Employers.: 01:00:00 •Tell HMRC about a New Employee.: 01:00:00 •Net And Gross Pay.: 00:20:00 •Statutory Sick Pay.: 00:30:00 •Minimum Wage for Different types of Work.: 01:00:00 •Additional Resources: Accounts Assistant Training.: 00:00:00

This online course introduces a model for determining and analysing market value vs fair value of an individual art work. LEVEL 3: Fair Value Analysis This is the third online course in our 'Pathway to become an art market analyst'. This course is a building block on both Big Data and the Art Market (Level 1) and Artist Market Analysis (Level 2), and takes the participant on an analytical journey to establish the market value and the fair value of an individual art object. The analysis is based on the Damien Hirst data provided in Level 2: Artist Market Analysis, and it is important that you finish this course before going on to Level 3. The course introduces participants to the difference between market value and fair value, and provides a practical guide for using market trends to analyse and adjust comparable transactions, and to use this to help establish market value. The ArtTactic Market Metrics from Level 2: Artist Market Analysis, is brought into the analysis to establish the 'Fair Value' of the art work. In addition to this, we will provide a 15 minute online Excel workshop on how to analyse comparable transactions using a subset of the data provided in the Level 2 online course. The course includes: Videos: You will have access to 1h 10m of online video content. The content of this course is building on ArtTactic's own framework for fair analysis and what Anders Petterson is regularly teaching for Art Business programmes at Sotheby's Institute in London. The course also include a 15 minutes Excel workshop. Slides: The students can download pdf copies of the slides used in the presentations. Excel spreadsheet: The student will have access to a subset of data (auction data for Damien Hirst) and a spreadsheet with both tables and graphical tools. Certificate of Completion [NEW]: The student will be issued with a certificate of completion when all the online videos have been completed. CPD Accredited: Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. Certification: Continuing Professional Development (CPD) Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. This means our courses comply with universally accepted principles of Continual Professional Development (CPD) and have been structured to meet the criteria of personal development plans. Join one of the online courses below and get an ArtTactic Certificate of Completion with the Continuing Professional Development (CPD) certification stamp. Your Instructor Anders Petterson, Founder of ArtTactic Anders Petterson is a leading authority on the art market, with particular focus on art market research and analysis. He is the Founder and Managing Director of ArtTactic, a London-based art market research and data intelligence company he set up in 2001. All the online courses are based on his own experience in collecting, analysing and presenting data on the global art market, and the courses will give an insight into how ArtTactic conceptualizes, designs and executes research projects linked to art market and introduces analytical models to better understand the value of art. Anders is regularly lecturing on MA and Executive courses at Sotheby's Institute, Christie's Education and ESA Business School (Beirut) covering topic such as Art Market Analysis, Art & Technology and NFTs as well as Art as an Asset Class. He is also a regular speaker on these topics at international conferences and seminars. ArtTactic is also well-known for its industry research on the art market and its intersection with other industries, such as the Deloitte | ArtTactic Art & Finance Report, TEFAF Art Dealer Finance Report 2018, and the TEFAF Art Patronage Report 2020. ArtTactic has also produced the Hiscox Online Art Trade Report annually since 2013. Anders Petterson is a founding Board Member of Professional Advisors to the International Art Market (PAIAM), a role he had between 2011 and 2021. PAIAM was founded in London in 2011 bringing together professionals who provide specialist services to the art market.such as lawyers, accountants, tax advisors, insurance specialists and logistics experts, amongst others. Connect on LinkedIn Course Curriculum Introduction Introduction to Fair Value Analysis (1:39) Fair Value Analysis Market Value vs Fair Value (4:24) Artwork Analysis - Object Qualities (9:40) Market Trend Analysis & Value Adjustments (7:10) Comparable Transaction Analysis (9:30) Market Value Analysis (6:45) Fair Value Analysis (11:03) Excel Workshop - Comparable transaction analysis + Sample Analysis Excel Workshop - Comparable Transactions (12:31) SAMPLE: Damien Hirst - Fair Value Analysis Summary  Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own. It's important to note that this is a SINGLE-user only subscription (see T&Cs). Contact us if you are looking for a team discount on info@arttactic.com.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.Is this course for me?We have a broad and diverse set of students taking these courses in terms of geography, age and professional backgrounds. Based on our experience so far, the courses have attracted non-art market professionals that are looking to explore opportunities in the art market or the broader art industry - and are looking for tools to help them navigate and better understand where these opportunities might exist, and how their own interest and professional background could fit in. At the other end, we also have seen a strong interest from the art trade who are looking at exploring more quantitative and data-driven methods for their own business and to meet the demand for an increasingly data-hungry client base. However, if you have any questions, please contact us and we can set up a call to discuss what course option might be the best for you.

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

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 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 classrom, one to one, tailored and bespoke courses. Tailored 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. 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

Level 2 & 3 Endorsed Training | FREE QLS Hard Copy Certificate | FREE 5 CPD Courses | Lifetime Access

20-in-1 Cyber Security Bundle Give a compliment to your career and take it to the next level. This Cyber Security bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop Cyber Security skills for your next job or elevate your skills for your next promotion, this Cyber Security bundle will help you stay ahead of the pack. Throughout the Cyber Security programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Cyber Security course, you will get 19 premium courses, an original hardcopy, 20 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Cyber Security Bundle Consists of the following Premium courses: Course 01: Cyber Security Incident Handling and Incident Response Course 02: Computer Networks Security Course 03: Cyber Security Law Online Course Course 04: Cyber Intelligence Officer Course 05: CompTIA Security+ (SY0-401) New 2020 Course 06: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 07: Computer Hacking Forensic Investigator Course 08: Security Management Advanced Diploma Course 09: IT Administration and Networking Course 10: GDPR Training Course 11: Master JavaScript with Data Visualization Course 12: Computer Science With Python Course 13: R Programming for Data Science Course 14: WordPress Security Mastery Course 15: Mile2 Certified Network Forensics Examiner (CNFE) Course 16: Complete Web Application Penetration Testing & Security Course 17: Linux Security and Hardening Course 18: Excel Must know Formulas and Functions Course 19: Certified Information Systems Security Professional (CISSP) Course 20: Excel Spreadsheet for Beginner Enrol now in Cyber Security to advance your career, and use the premium study materials from Apex Learning. The Cyber Security bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Cyber Security expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Cyber Security from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*20 = £120) Hard Copy Certificate: Free (For The Cyber Security Incident Handling and Incident Response Course: Previously it was £10) CPD 285 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Cyber Security bundle. Requirements This Cyber Security course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course Cyber Security Incident Handling and Incident Response absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.