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

789 Courses

Accountancy

5.0(1)

By Course Gate

Improve your accounting skills to perform a wide range of finance-related tasks by taking this Accountancy course. Through this course, you'll get a glimpse of how to perform your duties as an accountant, such as preparing financial statements and maintaining business records. The Accountancy course will thoroughly introduce you to the roles and responsibilities of a successful accountant. Here, you will gain valuable insights on accounting concepts and standards, double-entry bookkeeping, balance sheet, income statement, and financial statements. In addition, you'll learn to prepare cash flow statements and acquire knowledge of financial planning and budgeting. Finally, you'll learn the steps to a successful audit for error-free accounting processes. Learning Objectives Familiarise yourself with the roles and responsibilities of a successful accountant Learn about double-entry bookkeeping Enrich your knowledge of trial balance Learn to prepare income statements, financial statements and cash flow statements Gain the essential skills in financial budgeting and planning Know about the types of audits Who is this Course for? This introductory course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no accounting knowledge or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Accountancy course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Accounts Assistant Accounts Payable & Expenses Supervisor Accounts Payable Clerk Audit Trainee Payroll Administrator / Supervisor Tax Assistant / Accountant. Accounting Clerk Auditing Clerk Accounts Receivable Clerk Course Curriculum Module 01: Introduction to Accounting Introduction to Accounting 00:15:00 Module 02: The Role of an Accountant The Role of an Accountant 00:16:00 Module 03: Accounting Concepts and Standards Accounting Concepts and Standards 00:22:00 Module 04: Double-Entry Bookkeeping Double-Entry Bookkeeping 00:23:00 Module 05: Balance Sheet Balance Sheet 00:21:00 Module 06: Income statement Income statement 00:19:00 Module 07: Financial statements Financial statements 00:27:00 Module 08: Cash Flow Statements Cash Flow Statements 00:17:00 Module 09: Understanding Profit and Loss Statement Understanding Profit and Loss Statement 00:17:00 Module 10: Financial Budgeting and Planning Financial Budgeting and Planning 00:28:00 Module 11: Auditing Auditing 00:17:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Accountancy
Delivered Online On Demand3 hours 42 minutes
£11.99

Exploration & Production (E&P) Cost Control, Budgeting & Cost Estimation

By EnergyEdge - Training for a Sustainable Energy Future

Boost your expertise in this EnergyEdge's cost control and budgeting for exploration and production course. Enroll now and enhance your career!

Exploration & Production (E&P) Cost Control, Budgeting & Cost Estimation
Delivered In-PersonFlexible Dates
£1,899 to £2,099

Exploration & Production (E&P) Accounting Level 1

By EnergyEdge - Training for a Sustainable Energy Future

Boost your expertise in exploration and production accounting with EnergyEdge's course. Join our classroom training to gain valuable insights. Enroll now!

Exploration & Production (E&P) Accounting Level 1
Delivered In-PersonFlexible Dates
£1,899 to £2,099

Microsoft Office 2007 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2007 Excel Intermediate - Complete Video Course will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2007 Excel Intermediate - Complete Video Course 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Using Multiple Worksheets and Workbooks Using Multiple Workbooks FREE 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:08:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 56 minutes
£22

Salesforce Certification Preparation for Advanced Administrator (CRT211)

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is ideal for any administrator with an interest in furthering the development of their Salesforce CRM administration, Sales and Service Cloud management, and process automation skills, and who ultimately wants to succeed at the Salesforce Certified Advanced Administrator exam. Overview When you complete this course, you will be able to:Configure data and application security.Describe Sales Cloud and Service Cloud applications.Implement business logic and process automation.Build advanced reports and dashboards.Apply data management best practices. This course will help hone your knowledge of of next-level techniques to administer and manage Salesforce?s CRM capabilities through guided scenarios, lecture, and discussion. Salesforce Security and Custom Objects Restricting and extending object, record, and field access Determining appropriate sharing solutions Territory Management Data relationships Automation, Change Management, and Auditing Process automation tools and best practices Change management options Sandboxes Deployment tools Auditing and monitoring Analytics and Data Management Creating reports Report types Dashboards Data quality features and policies Sales, Service, and Content Applications Products, price books, schedules and quotes Forecasting Salesforce Knowledge Entitlements Service Cloud console toolkit Content management Wrapping Test preparation Practice exam Additional course details: Nexus Humans Salesforce Certification Preparation for Advanced Administrator (CRT211) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Salesforce Certification Preparation for Advanced Administrator (CRT211) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Salesforce Certification Preparation for Advanced Administrator (CRT211)
Delivered OnlineFlexible Dates
Price on Enquiry

The Digital Advertising Masterclass 2023

4.9(27)

By Apex Learning

Tired of browsing and searching for a Advertising course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Advertising bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Advertising course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Advertising and help you along your learning journey. Advanced audio-visual learning modules of these Advertising courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Advertising, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Advertising Bundle Consists of the following Premium courses: Course 01: Digital Marketing Course 02: Strategic Planning and Analysis for Marketing Course 03: Marketing Fundamentals Course 04: Business Branding Course 05: Sales and Marketing Skills Level 3 Course 06: Disruptive Innovation for Business Course 07: Digital Marketing Business Tips Course 08: Social Media Strategist Training Course 09: TikTok Marketing for Business Course 10: Retail Strategy Course 11: Influencing and Negotiating Course 12: Customer Relationship Management Course 13: The Formula to Talk with Strangers Course 14: Cross-Cultural Awareness Training Enrol now in Advertising to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the Advertising course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Advertising expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Digital Marketing Section 1: Introduction Section 2: How to Apply the Internet Marketing Process Section 3: The Internet Marketing Strategies That Will Increase Your Sales Section 4: Creating an Internet Marketing Strategy for Your Business Section 5: Structuring and Auditing of Website Course 02: Strategic Planning and Analysis for Marketing Module 1: An Introduction to Strategic Planning Module 2: Development of a Strategic Plan Module 3: Strategic Planning for Marketing Module 4: Strategic and Marketing Analysis Module 5: Internal Analysis Module 6: External Analysis Module 7: Market Segmentation, Targeting and Positioning Module 8: Approaches to Customer Analysis Module 9: Approaches to Competitor Analysis Course 03: Marketing Fundamentals Module 01: Introduction to Marketing Fundamentals Module 02: Definitions of Marketing Module 03: Traditional vs Contemporary Marketing Module 04: Marketing Management Orientations Module 05: Understand your Customers Module 06: Segmentation Course 04: Business Branding Business Course Promo Video Chapter1 Chapter2 Chapter3 Chapter4 Chapter5 Chapter6 Chapter7 Chapter8 Chapter9 Chapter10 Chapter11 Course 05: Sales and Marketing Skills Level 3 Module One - Getting Started Module Two - Understanding the Talk Module Three - Getting Prepared to Make the Call Module Four - Creative Openings Module Five - Making Your Pitch Module Six - Handling Objections And more... Course 06: Disruptive Innovation for Business Module 01: Introduction Disruptive Innovations for Business Module 02: The Three Key Difficulties Module 03: Six Insight on How to grow Disruptive Innovations next to core Course 07: Digital Marketing Business Tips Unit 1: You are Responsible for the Failure or Success of Your Business Unit 2: Why Internet Marketing and Social Media are important for Businesses Unit 3: How Google Search and Display Network Can Increase Your Sales Unit 4: The More You Learn the More You Earn Unit 5: Commitment Unit 6: Telling is not Selling Unit 7: Your Network is your Net-worth Unit 8: How to become Digital Marketing and Sales Expert Course 08: Social Media Strategist Training The Rise of Social Media Conducting Market Analysis Auditing Social Media Setting Goals and Selecting Platforms Creating the Social Media Policy Integrating Marketing Strategies Developing Effective Content Understanding the Popular Platforms Launching Successful Campaigns Managing the Community Providing Customer Service Measuring, Analyzing and Reporting The Social Media Strategist Career Course 09: TikTok Marketing for Business Section 1: Getting Started on TikTok Section 2: TikTok Foundations Section 3: Special Features of TikTok Section 4: How to Monetise Your Audience Section 5: Build Your Credibility Section 6: Build Your Community Section 7: How to Go Viral Course 10: Retail Strategy Module 01: Introduction to Retail Management Module 02: Retail Strategy Module 03: Retail Buying and Merchandising Module 04: Retail Pricing Module 05: Supply Chain Management in Retailing Module 06: The Sales Process and Dealing with Customers at the Checkout Module 07:Importance of Consumer Behaviour Module 08: Taking Trends and Targeting Customers Effectively Module 09: The Importance of Communicating with Customers Module 10: Choosing a Retail Location Module 11: Retail Psychology Module 12: Negotiate the Right Deal with Suppliers Module 13: Develop Store Security Procedures Module 14: Management Skills for Leading Your Team Module 15: Selling in Multiple Channels Module 16: Retail Brand Management Module 17: Health & Safety for Retail Stores Module 18: Consumer Rights Act Course 11: Influencing and Negotiating Unit 01: Influencing Unit 02: Negotiating Course 12: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course 13: The Formula to Talk with Strangers Section 01: Course Overview Section 02: The Formula Section 03: Summary Section 04: End Course 14: Cross-Cultural Awareness Training Module 1: Introduction to Cross-Cultural Awareness Module 2: Cross-Cultural Communication Module 3: Corporate Cross-Cultural Awareness Module 4: Cross-Cultural Design Module 5: Cross-Cultural Competency Module 6: Cultural Values Module 7: Working with and Managing a Culturally Diverse Team CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Advertising bundle. Requirements Our Advertising course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Advertising 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 P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

The Digital Advertising Masterclass 2023
Delivered Online On Demand
£100

Purchase Ledger Training

By Compete High

Overview With the ever-increasing demand for Purchase Ledger in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Purchase Ledger may be. Learning about Purchase Ledger or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Purchase Ledger . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Purchase Ledger is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Purchase Ledger course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Purchase Ledger course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Purchase Ledger course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Purchase Ledger , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Purchase Ledger , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Purchase Ledger , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Purchase Ledger course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 - Introduction to Purchase Ledger Introduction to Purchase Ledger 00:00 Module 2 - Purchase Ledger Account Purchase Ledger Account 00:00 Module 3 - Purchase Ledger Control Account Purchase Ledger Control Account 00:00 Module 4 - The Sales Ledger and the Purchase Ledger The Sales Ledger and the Purchase Ledger 00:00 Module 5 - Difference Between Sales Ledger and Purchase Ledger Difference Between Sales Ledger and Purchase Ledger 00:00 Module 6 - Reconciliation Reconciliation 00:00 Module 7 - Paperless Purchase Paperless Purchase 00:00 Module 8 - Auditing - Vouching of Ledger Auditing - Vouching of Ledger 00:00

Purchase Ledger Training
Delivered Online On Demand8 hours
£4.99

Ultimate Financial Controller Course

4.3(43)

By John Academy

Overview From planning to auditing, a financial controller has many roles to play. Learn how to fulfil each responsibility with expertise and accuracy with our Ultimate Financial Controller Course. This course will help you gain an overall understanding in no time. At first, the course will explain the basic role of a financial controller. Then, you will explore the vitals of financial analysis. The modules will educate you on the fundamentals of ratio analysis, planning, budgeting, and forecasting. Furthermore, you should grasp the strategies of budgetary control and financial auditing. After the completion of this course, you will receive a CPD-accredited certificate of achievement. This certificate will enhance your employability in the finance sector. So, enrol today and open new doors of opportunity for yourself! Course Preview Learning Outcomes Understand the basic concepts of financial statements Develop a clear understanding of financial analysis and ratio analysis Build your expertise in financial planning, budgeting and forecasting Learn about the strategies for budgetary control Grasp your expertise in conducting financial audits Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Financial analysis Financial planning and budgeting Financial audits Who Should Take This Ultimate Financial Controller Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Ultimate Financial Controller Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Ultimate Financial Controller Course Certification After completing and passing the Ultimate Financial Controller Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Ultimate Financial Controller Course will equip you with effective skills and abilities and help you explore career paths such as  Financial Analyst Financial Controller Finance Manager Module 01: The Concept Of Financial Controller The Concept of Financial Controller 00:26:00 Module 02: Financial Statement Financial Statement 00:32:00 Module 03: Financial Analysis Financial Analysis 00:42:00 Module 04: Ratio Analysis Ratio Analysis 00:40:00 Module 05: Planning, Budgeting And Forecasting Planning, Budgeting and Forecasting 00:45:00 Module 06: Budgetary Control Budgetary Control 00:52:00 Module 07: Internal Control And Cash Internal Control and Cash 01:03:00 Module 08: Strategic Management Decision Strategic Management Decision 01:03:00 Module 09: Financial Audit Financial Audit 00:46:00 Additional Resources Resources - Financial Controller Training 00:00:00 Assignment Assignment - Financial Controller Training 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Ultimate Financial Controller Course
Delivered Online On Demand6 hours 49 minutes
£11.99

Microsoft Excel Advanced (now with live online classes) One-to-One Training

By Microsoft Office Training

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

Microsoft Excel Advanced (now with live online classes) One-to-One Training
Delivered In-Person in LondonFlexible Dates
£650

Data Protection and Information Management Training Courses - Double Endorsed Certificate

By Imperial Academy

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Data Protection and Information Management Training Courses - Double Endorsed Certificate
Delivered Online On Demand
£159