8882 Power courses

Duration 2 Days 12 CPD hours This course is intended for This training is ideally suited for data analysts, IT professionals, and software developers who seek to augment their data processing and analytics capabilities. It will also benefit system administrators and data engineers who wish to harness Elastic Stack's functionalities for efficient system logging, monitoring, and robust data visualization. With a focus on practical application, this course is perfect for those aspiring to solve complex data challenges in real-time environments across diverse industry verticals. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll explore: New features and updates introduced in Elastic Stack 7.0 Fundamentals of Elastic Stack including Elasticsearch, Logstash, and Kibana Useful tips for using Elastic Cloud and deploying Elastic Stack in production environments How to install and configure an Elasticsearch architecture How to solve the full-text search problem with Elasticsearch Powerful analytics capabilities through aggregations using Elasticsearch How to build a data pipeline to transfer data from a variety of sources into Elasticsearch for analysis How to create interactive dashboards for effective storytelling with your data using Kibana How to secure, monitor and use Elastic Stack's alerting and reporting capabilities The Elastic Stack is a powerful combination of tools for techniques such as distributed search, analytics, logging, and visualization of data. Elastic Stack 7.0 encompasses new features and capabilities that will enable you to find unique insights into analytics using these techniques. Geared for experienced data analysts, IT professionals, and software developers who seek to augment their data processing and analytics capabilities, Working with Elasticsearch will explore how to use Elastic Stack and Elasticsearch efficiently to build powerful real-time data processing applications. Throughout the two-day hands-on course, you?ll explore the power of this robust toolset that enables advanced distributed search, analytics, logging, and visualization of data, enabled by new features in Elastic Stack 7.0. You?ll delve into the core functionalities of Elastic Stack, understanding the role of each component in constructing potent real-time data processing applications. You?ll gain proficiency in Elasticsearch for distributed searching and analytics, Logstash for logging, and Kibana for compelling data visualization. You?ll also explore the art of crafting custom plugins using Kibana and Beats, and familiarize yourself with Elastic X-Pack, a vital extension for effective security and monitoring. The course also covers essentials like Elasticsearch architecture, solving full-text search problems, data pipeline building, and creating interactive Kibana dashboards. Learn how to deploy Elastic Stack in production environments and explore the powerful analytics capabilities offered through Elasticsearch aggregations. The course will also touch upon securing, monitoring, and utilizing Elastic Stack's alerting and reporting capabilities. Hands-on labs, captivating demonstrations, and interactive group activities enrich your learning journey throughout the course. Introducing Elastic Stack What is Elasticsearch, and why use it? Exploring the components of the Elastic Stack Use cases of Elastic Stack Downloading and installing Getting Started with Elasticsearch Using the Kibana Console UI Core concepts of Elasticsearch CRUD operations Creating indexes and taking control of mapping REST API overview Searching - What is Relevant The basics of text analysis Searching from structured data Searching from the full text Writing compound queries Modeling relationships Analytics with Elasticsearch The basics of aggregations Preparing data for analysis Metric aggregations Bucket aggregations Pipeline aggregations Substantial Lab and Case Study Analyzing Log Data Log analysis challenges Using Logstash The Logstash architecture Overview of Logstash plugins Ingest node Visualizing Data with Kibana Downloading and installing Kibana Preparing data Kibana UI Timelion Using plugins

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Teach participants the basic functions of inventory management and physical inventory, and how to create different goods movements in the SAP system.Familiarize participants with the special functions of inventory management and physical inventory, and the Customizing settings relevant to inventory management and physical inventory. This course will give students an overview and in depth knowledge of the inventory management process in SAP. After attending this class, students will understand the major business processes, functions & configuration in inventory management. Introduction to Inventory Management Defining Inventory Management and Physical Inventory Moving Goods with the MIGO Transaction Goods Receipts (GRs) Posting a GR Without Reference Posting a GR with Reference Posting a GR with Automatic Generation of a PO Posting Cancellations, Return Deliveries, and Returns Applying Order Price Unit in Inventory Management Applying Tolerances and the Delivery Completed Indicator Adding Date Checks to GRs for a PO Stock Transfers and Transfer Postings Performing Transfer Postings Performing Stock Transfers Between Storage Locations Performing Stock Transfers Between Plants Reservations Creating Manual Reservations Evaluating Reservations Checking Availability and Missing Parts Goods Issues (GIs) Posting Unplanned GIs Posting a GI with Reference Configuring Stock Determination Allowing Negative Stock Special Forms of Procurement and Special Stocks Performing the Process of Subcontracting Performing Vendor Consignment Operating Pipeline Processes Posting Goods Movements for Special Stocks Special Features of Material Valuation Posting Goods Movements for Material Types UNBW and NLAG Configuring Split Valuation Physical Inventory Conducting Physical Inventory Analyzing the Determination of Book Inventory Simplifying Physical Inventory Applying Cycle Counting Applying Inventory Sampling Analyses Applying Stock Lists and Document Lists Applying Periodic Processing Customizing Implementing Settings for Documents Setting Up Movement Types Applying Other Customizing Settings Logistics Execution Managing Logistics Execution Processes Posting a GR Against a PO Posting a GI for a Sales Order Additional course details: Nexus Humans SCM510 SAP Inventory Management and Physical Inventory 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 SCM510 SAP Inventory Management and Physical Inventory 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.

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

Negotiation is an everyday challenge for some whether it be in the office, field or at home. Have you ever walked away from a situation thinking "if I'd only put my thoughts, side, opinion or words across better"? This 2-day course is perfect for managers, supervisors and sales people. It will focus on negotiation skills and the techniques that go with it. In this energy-charged provision you'll learn and practice negotiation, assertiveness and influencing techniques. Course Syllabus The syllabus of the Effective Communication and Influencing course is comprised of seven modules, covering the following: Module One An Introduction to Negotiation Assessment of your current sales and negotiation strengths and improvement areas What is negotiation? Identifying objectives and all factors affecting negotiation The negotiation model - the four stages Module Two The Preparation Stage The significance of preparation and why we need to prepare What do you need to prepare? Preparing a set of objectives: yours and theirs Understanding constants and variables Researching the other party Creating a "win-win" situation Preparing yourself for possible set-backs and objections Module Three The Discussion Stage The importance of rapport building Opening the negotiation The power of effective questioning techniques Improving your listening skills Controlling emotions Spotting the signs - non-verbal communication and voice clues Module Four The Proposing Stage Stating your opening position Responding to offers How to deal effectively with adjournments Module Five The Bargaining and Closing Stage Making concessions - the techniques Adopting key bargaining skills Dealing with objections and underhand tactics Closing techniques Confirming the agreement Creating long term, lasting commitment Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

The Computing Technology Industry Association (CompTIA) is the association representing the international technology community. Its goal is to provide a unified voice, global advocacy and leadership, and to advance industry growth through standards, professional competence, and education and business solutions. In order to most efficiently serve the industry and its members, CompTIA has developed specialized initiatives and programs dedicated to major areas within the IT industry. They include, convergence technology, e-commerce, IT training, software services, certification, public policy and workforce development. This bundle offers incredible value for money for anyone looking to get CompTIA certified. It includes 6 separate certification courses, spanning a variety of disciplines and technical fields from IT technician skills, to networking, and IT security, plus more!

Overview Learn about Sales and Marketing Principles from industry experts and boost your professional skill. This Sales and Marketing Principles course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Sales and Marketing Principles. You'll also gain the skills of Sales and Marketing Principles to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of Sales and Marketing Principles professionals and gain first-hand experience of Sales and Marketing Principles problem-solving. The Sales and Marketing Principles  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the Sales and Marketing Principles, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This Sales and Marketing Principles will provide you with the latest information and updates of Sales and Marketing Principles. It will keep you one step ahead of others and increase your chances of growth. Why buy this Sales and Marketing Principles? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Sales and Marketing Principles 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 the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Sales and Marketing Principles does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Sales and Marketing Principles was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Sales and Marketing Principles is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Sales Skills for Beginners Mindset Attitude 00:01:00 Values 00:03:00 Beliefs 00:02:00 How to Change Beliefs 00:04:00 Goals 00:06:00 Focus 00:02:00 The Extra Mile 00:03:00 Team Player 00:02:00 Accentuate the Positive 00:03:00 Be a Winner! 00:02:00 Organizational Skills Pre-call Research 00:02:00 Gaining Appointments 00:04:00 Pre-call Planning 00:04:00 Route Planning 00:04:00 Prioritizing your Time 00:02:00 Controlling the Controlable 00:03:00 Product Knowledge Know your Products 00:03:00 Features and Benefits 00:03:00 Customer Perception 00:02:00 Sales Calls Beginning Sales Calls 00:03:00 Listening & Question Listening Skills Part 1 00:07:00 Listening Skills Part 2 00:05:00 Uncovering Needs 00:05:00 Closing Sales Calls Closing a Sales Call 00:04:00 Following Up Post Call Analysis 00:05:00 Follow Up Actions 00:02:00 Onwards 00:01:00 Final Thoughts 00:01:00 Mastering Sales Techniques The Guaranteed Way to Improve Your Sales Technique The Number One Universal Killer Question in Selling 00:03:00 The Importance of Establishing the Clients Expectations 00:02:00 How to Close the Sale Without Sounding like a Salesman 00:04:00 Why People Buy and How to Get Them to Buy from Us People Buy Emotionally and Justify Logically. What to Do About It 00:04:00 Don't Assume You Know the Buyer's Priorities 00:05:00 How to Unearth the Buyer's Strategic Needs 00:03:00 The Importance of Implications 00:04:00 Why People Don't Buy and How to Counteract Any Objection Being Prepared for Objections 00:04:00 The Most Common Objections and How to Handle Them 00:04:00 How to Get People to Choose What You Want Them To 00:04:00 What Buyers Say and What They Really Mean 00:03:00 Holding a High Price What Does Value For Money Really Mean? 00:03:00 Five Proven Techniques to Save Money and Make Money 00:04:00 The Words: 'Typically', 'Realistically', 'Currently', 'Given' and 'Yet' 00:02:00 Justifying Your Price - the Power of One 00:04:00 The Final 'Killer Questions' That Allow You to Negotiate More Successfully 00:04:00 Win-Win and Increasing Average Order Value The Real Meaning of 'Win-Win' 00:04:00 The Rules for Discounting 00:03:00 How to Hold a High Price 00:04:00 How to Increase Average Order 00:03:00 The Compromise Effect 00:03:00 Sales Techniques You Need to Know All You Need to Know About Time Management 00:03:00 Recognising the Moment That Matters and the Role of 'Enough' 00:06:00 What to Do When It Starts Going Wrong 00:05:00 How to Understand Other People - Can You Clarify? 00:04:00 How to Build Your Reputation and Getting Your Client to Feel Indebted to You 00:04:00 Selling in the Long Term and Being Recommended 00:04:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This course covers the basics of agile project management, its principles, benefits and the role of leaders in agile project management. In this course, you will learn agile methodologies and master various essential skills to lead and deliver projects with adaptability and efficiency. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the fundamentals of both agile and conventional project management Recognise the principles and benefits of agile project management Understand the role of leaders in agile project management Know how to maintain diversity in an agile team Recognise the stages of both agile and conventional project management Know how to initiate a project and manage an agile team Learn the fundamental of establishing an effective communication Know how to develop and lead a high-performance team Gain skills and knowledge to develop yourself as a self-confident professional Know how to perform risk analysis and use strategies to manage risks Learn how to set goals and manage individuals Why Agile Project Management Training Course right for you? This agile project management training course is ideal for Project Managers who want to gain skills and knowledge about agile project management, as well as for those who want to create an effective agile project management strategy for their company. This course will help you develop a comprehensive understanding of both Agile and conventional project management ideas and techniques, as well as how to combine them in the proper ratios to handle any project. You will understand how to maintain diversity in an agile team, the stages of agile project management and how to ensure effective communication among all members. This course explains the definition stage, the planning stage, the delivery stage, and the closure stage of the conventional project management system. Finally, you will learn how to manage individuals and manage your team as a project manager. Upon successful completion of this course, you gain skills ad knowledge about both agile project management and conventional project management system to build a successful career in the project management sector. Agile Project Management Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum Introduction Introduction What is Agile Project Management What is Agile Project Management What is Agile Manifesto What is Agile Manifesto Four Foundational Agile Values Four Foundational Agile Values Twelve Supporting Agile Principles Twelve Supporting Agile Principles Role of Leaders in Agile PM Role of Leaders in Agile PM Managing Diversity in an Agile Team Managing Diversity in an Agile Team Importance of Leadership in Agile Importance of Leadership in Agile SCRUM Methodology SCRUM Methodology Extreme Programming Methodology Extreme Programming Methodology Stages of Agile Project Management Stages of Agile Project Management Importance of Accountability Importance of Accountability Agile Team - Values & Ethics Agile Team - Values & Ethics Agile Team Management Agile Team Management Pitfalls to Effective Communication Pitfalls to Effective Communication Tips for Effective Communication Tips for Effective Communication Launchpresentation Project Management Fundamentals: Know the Principles and Get it Right What is a Project The Four Stage Project Lifecycle Project Stages and Boundaries One Reason why Projects go Wrong Terminology used in the Project Stages More on Project Gateways / Stage Gates Project Definition Stage: The Vital Foundation to Your Success Define your Project: Goals and Objectives Understanding Project Scope Dealing with Scope Creep Project Definition: Summary Project Planning Stage: Failing to Plan = Planning to Fail The Book of the Plan The Stakeholder Engagement Process Stakeholder Analysis Milestones are your Best Friends The Work Breakdown Structure The Gantt Chart Tools for Creating a Gantt Chart The Linear Responsibility Chart (LRC) aka The RACI Chart The Risk Management Process Risk Analysis The Six Strategies for Managing Risks The Risk Register (or Risk Log) Project Delivery Stage: Don't you Love it When a Plan Comes Together The Four Essentials of Leading your Team Project Delivery - The Three Key Cycles Project Closure Stage: Deep Sigh - You're Nearly Done Closing Words Personal Effectiveness - How to Be an Awesome Professional Monday: Self-confidence Tuesday: Personal Time Management Wednesday: Assert Yourself Thursday: Problem Solving Friday: Presenting Managing Individuals - How to Get the Best From Your People Monday: Goal Setting Tuesday: Delegation Wednesday: Feedback Thursday: Poor Performance Friday: Coaching Communication Skills - How to Make Your Management Voice Heard Monday: Listening Tuesday: Motivating Wednesday: Meetings Thursday: Negotiating Friday: Conflict Team Management - How to Create and Keep A High Performance Team Monday: The Power of Teams Tuesday: Team Development Wednesday: Team Maintenance Thursday: The Four Essentials of Team Management Friday: Team Meetings Manager's Toolkit - How to Adapt to Whatever The Job Throws At Yo Monday: Emotional Intelligence Tuesday: Transactional Analysis Wednesday: The SCOPE Process Thursday: Selecting Management Styles Friday: The Powerhouse Loop Who should take this course? This agile project management training course is primarily aimed at: Project managers Team leaders Project team members Aspiring project managers Anyone looking to enhance their project management skills Anyone who wants to learn about agile project management New project managers who want to gain agile project management skills However, this course is not restricted to any single profession or field of work. This course can also benefit anyone who wants to learn more about agile project management in order to handle their own projects. Entry Requirements There are no academic entry requirements for this agile project management training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This agile project management training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Unlock the potential of AI-driven creative writing with our QuillBot AI Masterclass. Elevate your writing skills and explore advanced features for flawless content creation.

Expedite your journey with the Jq command, which is used to transform JSON data into a more readable format. Print it to the standard output on Linux with the help of this comprehensive hands-on course. This course is for anyone who works with JSON on the command line or uses Bash Shell Scripts.

Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & 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 Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 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 11 hours, 6 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 Microsoft Excel Complete Course - Beginner Intermediate & 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? Microsoft Excel Complete Course - Beginner Intermediate & 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 Microsoft Excel Complete Course - Beginner Intermediate & 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 Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting A Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working With Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working With Multiple Worksheets And Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines And Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00