487 Spreadsheet courses

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS 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

Whether it is a small local business or a multinational company, there is always a spot open for accountants and bookkeepers. This line of profession provides a secure job with a good salary and other additional benefits. The Accounting, Bookkeeping & Payroll - Complete Video Course(US) is here to equip you with the vital skills to establish a promising career in the accounting and bookkeeping sector. In this Accounting, Bookkeeping & Payroll - Complete Video Course(US), you will first receive a detailed introduction to accounting. Then the course will educate you on accounting equations, transactions and financial statements. You will be able to develop the ability to prepare worksheets, complete the accounting cycle, and post and adjust entries. The second section of the course will educate you on the principles of bookkeeping. You will learn how to manage the budget and sales tax. This valuable course will also ensure that you have the essential skills for payroll management.  After completing the Accounting, Bookkeeping & Payroll - Complete Video Course(US), you will receive a valuable certificate to enrich your resume. Enrol in this excellent course today to boost your skills and your career. Learning Outcomes Enrich your knowledge of accounting equations, transaction and financial statements Develop the skills for posting and adjusting entries Understand the process of preparing a worksheet Learn about the steps of the accounting cycle Familiarise yourself with the principles of bookkeeping Grasp the skills for budgeting and managing sales tax Acquire the essential skills and abilities for payroll management Who is this Course for? Accounting, Bookkeeping & Payroll - Complete Video Course(US) is certified by CPD Quality 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 Accounting, Bookkeeping & Payroll - Complete Video Course(US) is fully compatible with any kind of device. Whether you are using Windows computers, Mac, smartphones or tablets, you will get the same experience while learning. You will be able to access the course with any internet connection from anywhere at any time without any kind of limitation. 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. Why Choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet, or desktop from anywhere, anytime; The benefit of career advancement opportunities; 24/7 student support via email.   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 the cost of £39 or in PDF format at the cost of £24.   Career Path After completing this Accounting, Bookkeeping & Payroll - Complete Video Course(US), you will be able to build up accurate knowledge and skills with proper confidence to enrich your career in the following professions Accountant Bookkeeper Finance Officer Payroll Supervisor Accounts Assistant Module 01 : Business Accounting Professional Bookkeeper Introduction Professional Bookkeeper FREE 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Accounts 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00 Module 02 : Bookkeeping and Payroll Principles Introduction - GAAP FREE 00:15:00 Transactions 00:11:00 Overview of Internal Controls The Need for Internal Controls 00:24:00 Control Concepts 00:25:00 Subsidiary Ledgers and Special Journals Subsidiary Ledgers 00:16:00 Special Journals - Posting Sales Journal 00:18:00 Special Journals - Posting Cash Receipts 00:13:00 Reconciliations Purpose 00:14:00 Reconciliation 00:22:00 Who Should Perform the Reconciliation 00:12:00 Correcting Entries Correcting Entries 00:08:00 The Wrong Account 00:05:00 Sales Tax Sales Tax 00:13:00 Sales Tax Rules and Filing 00:13:00 Budgeting All Businesses Must Have a Strategic Plan 00:28:00 Types of Budgets 00:19:00 Accounting for Merchandising Merchandising Income Statement 00:17:00 Sales Discounts 00:15:00 Purchase Discounts 00:17:00 Accounting for Cash Defining Petty Cash 00:12:00 Accounting for Cash Over or Short 00:13:00 Cash Controls - The Bank Reconciliation 00:27:00 Payroll The Payroll Process 00:35:00 Payroll Process - Deduction Tables 00:21:00 Payroll Process - Earnings Record 00:24:00 Partnerships and Corporations The Partnership 00:19:00 Corporations 00:09:00 Preferred Stock 00:18:00 Accounts Receivable and Bad Debts Accounts Receivable 00:22:00 Bad Debts 00:17:00 Interim Profit or Loss Interim 00:09:00 Year End - Preparing to Close the Books Inventory 00:21:00 Inventory Obsolescence 00:20:00 Year End - Closing the Books Year End - Closing Journal Entries 00:14:00 Year End - Post Closing Trial Balance 00:18:00 Cash Flow What is Cash Flow 00:19:00 Cash Flow - The Indirect Method 00:23:00 The Direct Method 00:22:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

IT User Skills Level 2 - CPD Certified Essential IT Skills Level 2 | IT Support Technician Training | Internet of Things Hacking | Learning Computers and Internet Level 2 | Building Your Own Computer | Electronic & Electrical Devices Maintenance | Cyber Security Incident Handling and Incident Response | GDPR Data Protection and much more... Did you know that 95% of jobs require some level of IT skills? And with the rapid advancement of technology, these skills are becoming more and more crucial in the job market. Our IT User Skills Level 2 bundle, which includes 12 CPD-certified courses, will equip you with the necessary skills to stay ahead of the game. The courses in this bundle cover a range of essential IT skills, from Essential IT Skills Level 2 to Cyber Security Incident Handling and Incident Response and GDPR Data Protection Level 5. You'll also learn how to build your own computer, maintain electronic and electrical devices, troubleshoot Windows 10, and much more. By the end of these courses, you'll have a comprehensive understanding of IT and be ready to take on any challenges in the field. One of the standout courses in this bundle is the ChatGPT Training course. This course focuses on natural language processing, a field that is rapidly growing and transforming the IT industry. You'll learn how to use Prompts and artificial intelligence effectively to have conversations with chatbots like ChaptGPT to get the best possible outcome. This course will not only enhance your IT skills but also make you stand out in the job market as an innovative and forward-thinking candidate. Investing in your IT skills is investing in your career. Don't miss out on the opportunity to gain the knowledge and expertise needed to succeed in today's job market. Enrol in our IT User Skills Level 2 bundle and take the first step towards a brighter future. Learning Outcomes: Upon completion of the courses, you will be able to: Develop essential IT skills to stay ahead in the job market Learn how to build your own computer and maintain electronic and electrical devices Understand cyber security incident handling and GDPR data protection Learn how to troubleshoot Windows 10 and other computer issues Gain knowledge on cloud computing and CompTIA Cloud+ Become knowledgeable in natural language processing with the ChatGPT Training course Learn about hacking and data centre training essentials Develop skills in IT support technician training Along with this IT User Skills Level 2 course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This IT User Skills Level 2 Bundle Consists of the following Premium courses: Course 01: Essential IT Skills Level 2 Course 02: IT Support Technician Training Course 03: Internet of Things Hacking Course 04: Learning Computers and Internet Level 2 Course 05: Building Your Own Computer Course 06: Electronic & Electrical Devices Maintenance Course 07: Cyber Security Incident Handling and Incident Response Course 08: GDPR Data Protection Level 5 Course 09: Data Center Training Essentials: General Introduction Course 10: Complete Windows 10 Troubleshooting for IT HelpDesk Course 11: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 12: Level 2 Microsoft Office Essentials Course 13: Chat GPT Crush Course Enrol now in IT User Skills Level 2 to advance your career and use the premium study materials from Apex Learning. The IT User Skills Level 2 - CPD Certified bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your IT User Skills Level 2 expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Essential IT Skills 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 Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT User Skills Level 2 - CPD Certified course is perfect for individuals who have an interest in or are currently employed in this industry. However, it is important to recognize that this IT User Skills Level 2 - CPD Certified course is not regulated. If you want to become certified, you must register for the programs listed below: BCS Level 1 Award in IT User Skills (ECDL Essentials) (ITQ) BCS Level 2 Certificate in IT User Skills (ECDL Core) BCS Level 2 Certificate in IT User Skills (ECDL Extra) (ITQ) BCS Level 2 ECDL Award in IT User Skills BCS Level 2 ECDL Certificate in IT User Skills BCS Level 3 Certificate in IT User Skills (ICDL Advanced) (ITQ) NCFE Level 3 Diploma in Skills for Business: IT Requirements This IT User Skills Level 2 course has been designed to be fully compatible with tablets and smartphones. Career path Our IT User Skills Level 2 will prepare you for a range of careers, including: IT Support Technician (£17k-£31k) Cyber Security Analyst (£25k-£50k) Cloud Computing Engineer (£25k-£70k) IT Helpdesk Manager (£25k-£45k) Data Centre Technician (£20k-£35k) IT Consultant (£20k-£60k) 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 (IT Support Technician Training) 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.

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

Join EnergyEdge's classroom training course and gain valuable insights into Exploration and Production Accounting - Level 3. Enroll today!

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

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