1338 Courses

FourSquare Training specialise in private, corporate Microsoft PowerPoint courses delivered at your premises and tailored to your needs.

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth (Virtual) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

***24 Hour Limited Time Flash Sale*** The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Office skills are in high demand in the UK, with 9 in 10 middle-skill jobs requiring digital skills like Word and Excel. Do you have gaps when it comes to building spreadsheets, presentations, and working with databases? This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle can help fill those gaps. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Career Bundle: Course 01: MS Word Diploma Course 02: Microsoft Excel Level 3 Course 03: PowerPoint Diploma Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 05: Microsoft Excel: Excel Sheet Comparison with VBA Course 06: Microsoft Excel: Master Power Query in 120 Minutes! Course 07: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 08: Excel Pivot Tables Course 09: Proofreading & Copyediting Course 10: Complete Microsoft Power BI 2021 Course 11: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 12: Excel Must know Formulas and Functions Course 13: Outlook Tips and tricks Course 14: The Complete Microsoft Outlook Masterclass Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Microsoft Access Tables and Queries Course 17: Excel PowerQuery and PowerPivot Course 18: Excel spreadsheet for Beginner Course 19: Microsoft Teams Course 20: Data Analysis in Microsoft Excel Complete Training Course 21: Office Skills and Administration Management Diploma Course 22: PowerBI Formulas Course 23: Data Protection and Data Security Level 2 Course 24: Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 25: Document Control Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 27: Excel Data Analysis Course 28: Touch Typing Essentials Course 29: Microsoft Access Databases Forms and Reports Course 30: New Functions in Microsoft Excel 2021 With The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes of Ms Word, Ms Excel, Powerpoint & Access Master advanced formulas and functions in Microsoft Excel. Create automated dashboards using Excel, VBA, and Power Query. Design compelling presentations with Microsoft PowerPoint. Utilize Microsoft Word for professional document preparation. Analyze data efficiently with Excel Pivot Tables and Charts. Optimize email management with Microsoft Outlook tips and tricks. Don't let this opportunity pass you by. Enrol in The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access today and take the first step towards achieving your goals and dreams. Why buy this The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access? Free CPD Accredited Certificate upon completion of The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Get a free student ID card with The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Lifetime access to the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access course materials Get instant access to this The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access course Learn The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access from anywhere in the world 24/7 tutor support with the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access course. Start your learning journey straightaway with our The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Training! The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access course. After passing the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access course is ideal for: Students seeking mastery in The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Professionals seeking to enhance The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access skills Individuals looking for a The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access-related career. Anyone passionate about The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Requirements This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access doesn't require prior experience and is suitable for diverse learners. Career path This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will allow you to kickstart or take your career in the related sector to the next stage. Admin Assistant Data Analyst Business Analyst Marketing Manager Project Manager Entrepreneur Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Office 365 Administration Basics bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Office 365 Administration Basics related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Office 365 Administration Basics bundle will help you build a solid foundation to become a proficient worker in the sector. This Office 365 Administration Basics Bundle consists of the following 25 CPD Accredited Premium courses - Course 01 :Office Skills Training Course 02 :Admin, Secretarial & PA Course 03 :Corporate Paralegal Course 04 :Performance Management Course 05 :Team Management Course 06 :Microsoft Word, PowerPoint & Outlook Course 07 :Health and Safety in the Workplace Level 2 Course 08 :Business Etiquette and Professionalism Training Course 09 :Workplace First Aid Training Course 10 :Information Management Course 11 :Facilities Management and Workplace Services Course 12 :UK Employment Law Course 13 :Communication and Organisational Skills Course 14 :Meeting Management Online Course 15 :Minute Taking Certificate Course 16 :Document Control Course 17 :Touch Typing Course 18 :Email Writing Course 19 :Public Speaking Course 20 :Leadership Skills Course 21 :Corporate Risk And Crisis Management Course 22 :Cross-Cultural Awareness Training Course 23 :Equality, Diversity and Discrimination Course 24 :Level 3 Coaching & Mentoring Course Course 25 :Presentation Skills 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Learning Outcome This tailor-made Office 365 Administration Basics bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Office 365 Administration Basics Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course for free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Office 365 Administration Basics bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Office 365 Administration Basics Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge