Course Overview In any position or jobs sector, leadership skills are essential for your growth and development. Learn important leadership skills and how they can help you to improve your performance from this Essential Leadership Skills for The Future course. In this Essential Leadership Skills for The Future course you will be familiarized with different leadership traits and how you can use them in your work. You will learn about the qualities of a good leader, the importance of creativity and communication in leadership. This course will teach you organizational and communication skills that will help you connect, negotiate and evolve as a leader. This course will boost your emotional intelligence and improve your overall growth. This course will help you improve your leadership skills and efficiency. You will learn about different leadership skills and their application from easily understandable comprehensive lessons of the course. This course is ideal for anyone who wants to boost their productivity and develop their leadership skills. Learning Outcomes Learn about the qualities you need to be a leader Show creativity and empathy in a leading position Be able to acquire organizational skills Familiarize with different leadership skills and competencies Learn how to negotiate and communicate with people effectively Understand the foundation of leadership and how they are used Learn how inclusiveness and engagement can improve your performance as a leader Learn about different leadership and management traits in the UK Who is this course for? This comprehensive Essential Leadership Skills for The Future course is ideal for those who want to learn leadership skills and boost their personal and professional growth You will learn how you can use leadership skills in your work from this course. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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 recognized 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. Career Path The Essential Leadership Skills for The Future is a useful qualification to possess and would be beneficial for any related profession or industry such as: Leaders Entrepreneurs Business Owners Managers Departmental Heads Company Directors Managing Directors Team Leaders Supervisors Essential Leadership Skills for The Future Module 01: Introduction to Leadership 00:25:00 Module 02: Qualities of a Good Leader and Leadership 00:15:00 Module 3. Creativity in Leadership 00:21:00 Module 4: Organisational Skills 00:28:00 Module 5. Leadership Skills and Competencies 00:32:00 Module 6: Communication Skills 00:29:00 Module 7: Negotiation Techniques 00:17:00 Module 8. Cultivating Inclusion, Belonging, and Engagement 00:27:00 Module 9. Leadership Foundations 00:26:00 Module 10. Emotional Intelligence 00:21:00 Module 11. Evolve as a Leader 00:16:00 Module 12. Leadership & Management in the UK 00:19:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Description: This Certified Professional Ethical Hacker (CPEH) - Complete Video Training covers everything you need to know about becoming a certified professional ethical hacker. In this course you will learn about security fundamentals, access controls, protocols, cryptography, vulnerability assessments, vulnerability tools of the trade, output analysis and reports, reconnaissance, enumeration and scanning, gaining access, maintaining access, covering tracks, malware, buffer overflows, and password cracking. This course is designed to introduce you to up-to-date penetrating testing, plus certification. This course will enable you to understand the importance of vulnerability assessments by providing industry knowledge and skills in Vulnerability Assessments. In doing so, you will be able to understand how malware and destructive viruses function. In addition, the CPEH course helps you to learn how to implement counter response and preventative measures when it comes to a network hack. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Certified Professional Ethical Hacker (CPEH) - Complete Video Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Certified Professional Ethical Hacker (CPEH) - Complete Video Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Security Fundamentals Security Fundamentals FREE 00:51:00 Access Controls Access Controls 00:33:00 Protocols Protocols 00:36:00 Cryptography Cryptography 00:52:00 Why Vulnerability Assessments? Why Vulnerability Assessments? 00:36:00 Vulnerability Tools of the Trade Vulnerability Tools of the Trade 00:10:00 Output Analysis and Reports Output Analysis and Reports 00:13:00 Reconnaisance, Enumeration and Scanning Reconnaisance, Enumeration and Scanning 00:51:00 Gaining Access Gaining Access 00:31:00 Maintaining Access Maintaining Access 00:17:00 Covering Tracks Covering Tracks 00:18:00 Malware Malware 00:28:00 Buffer Overflows Buffer Overflows 00:22:00 Password Cracking Password Cracking 00:33:00 Mock Exam Mock Exam- Certified Professional Ethical Hacker (CPEH) - Complete Video Training 00:20:00 Final Exam Final Exam- Certified Professional Ethical Hacker (CPEH) - Complete Video Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: This course will gradually take you through the spiritual awaking procedures. The course will help you build strength within yourself. It will also help you pass all your difficulties with ease. As far as you are aware of what is going on you are capable of making the changes according to you wills and requirements. This course will help you find the true you. It will help you love yourself for what you are and who you are which will help you raise yourself in the society. It will also teach you to become a powerful and a happy individual. Who is the course for? This course is designed for all the individuals who are facing spiritual awakening or are feeling the could be. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be ages 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment & Certification: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the test, you will be able to buy an internationally recognised Accredited Certificate of Achievement from John Academy. You can however also buy a Course Completion Certificate following the course completion without sitting for the test. PDF certificate's turnaround time is one working day and for the hardcopy certificate, it is 3-9 working days. Career Path: Psychologist Counsellor For individual's who are spiritually awaking. Diploma in Creative Arts THE STARTING-POINT 00:30:00 THE SELF-CONTEMPLATION OF SPIRIT 00:30:00 THE DIVINE IDEAL 01:00:00 THE MANIFESTATION OF THE LIFE PRINCIPLE 00:30:00 THE PERSONAL FACTOR 00:30:00 THE STANDARD OF PERSONALITY 00:30:00 RACE THOUGHT AND NEW THOUGHT 00:15:00 THE DENOUEMENT OF THE CREATIVE PROCESS 01:00:00 THE DIVINE OFFERING 00:15:00 WE IN THE DIVINE OFFERING 00:15:00 CONCLUSION 00:30:00 Mock Exam Mock Exam-Diploma in Creative Arts 00:20:00 Final Exam Final Exam-Diploma in Creative Arts 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: If you are already able to create, edit, and print word 2016 documents, then this next level is designed for you. In this Microsoft Office 2016 Word Intermediate - Complete Video Course you will learn advanced formatting, how to use word 2016's advanced editing tools, work with image, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation and layout, work with columns, work with page and section breaks, document views, using the navigation pane, and viewing multiple windows, and more. You can join this course, if you have basic skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and join this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Word Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Word Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Organizing Content Using Tables and Charts Sort Table Data FREE 00:07:00 Control Cell Layout 00:08:00 Perform Calculations in a Table 00:10:00 Create a Chart 00:11:00 Add an Excel Table to a Word Document 00:05:00 Customizing Formats Using Styles and Themes Create and Modify Text Styles 00:17:00 Create Custom List or Table Styles 00:07:00 Apply Document Themes 00:09:00 Inserting Content Using Quick Parts Insert Building Blocks 00:10:00 Create and Modify Building Blocks 00:07:00 Insert Fields Using Quick Parts 00:10:00 Using Templates to Automate Document Formatting Create a Document Using a Template 00:09:00 Create a Template 00:10:00 Manage Templates with the Template Organizer 00:05:00 Controlling the Flow of a Document Control Paragraph Flow 00:07:00 Insert Section Breaks 00:04:00 Insert Columns 00:05:00 Link Text Boxes to Control Text Flow 00:09:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:05:00 Insert an Index 00:09:00 Insert a Table of Contents 00:06:00 Insert an Ancillary Table 00:10:00 Manage Outlines 00:06:00 Create a Master Document 00:09:00 Using Mail Merge to Create Letters, Envelopes, and Labels The Mail Merge Feature 00:23:00 Merge Envelopes and Labels 00:08:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Having trouble keeping focus on the task at hand? Are you someone who is making careless mistakes during work struggling with memory retention? Or do you just want to improve your focus and improve your memory capacity? Then this course will be perfect for your needs! Description: If you are one of those people who is struggling with temporary memory loss or you are losing attention during work, this course will be helpful to retain your memory. You will learn the necessary skills to increase your productivity and get the best result from your hard work. Most importantly, expanding your memory capacity and improve your day to day activity will be lot easier. This course is ideal for you since you will be able to learn about how memory is gained and how it should be restored for you to enjoy or learn from the past. Who is the course for? Professionals or employees who want to learn about attention management People who have an interest in improving their memory and overall mental health Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. 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 recognized 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. Career Path: The Attention Management and Memory Increasing Course would be beneficial for the following careers: Employees Division/Section Heads Managers Section Chiefs Top Executives Students Director Businessman Manager Team leader Top Executive. Attention Management Module One - Getting Started 00:30:00 Module Two - Introduction to Attention Management 00:30:00 Module Three - Types of Attention 01:00:00 Module Four - Strategies for Goal Setting 01:00:00 Module Five - Meditation 01:00:00 Module Six - Training Your Attention 01:00:00 Module Seven - Attention Zones Model 01:00:00 Module Eight - SMART Goals 01:00:00 Module Nine - Keeping Yourself Focused 01:00:00 Module Ten - Procrastination 01:00:00 Module Eleven - Prioritizing Your Time 01:00:00 Module Twelve - Wrapping Up 00:30:00 Attention Management- Activities 00:00:00 Memory Increasing Techniques How Memory is Gained 01:00:00 How can You Improve Your Memory 01:00:00 A Great Technique for Improving Your Memory 01:00:00 A Healthy Lifestyle for an Improved Memory 01:00:00 Remembering Things by Association 01:00:00 Ways to Improve Your Memory 01:00:00 Conclusion 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Overview Developing a solid foundation in a B2B business development plan can be the turning point of your career. It will open new career opportunities and also provide deep insights for aspiring business owners. Our Business Development Training (B2B) course is the perfect place to build your expertise in this area. The course is designed to provide you with an overall understanding of B2B business development. Through the informative lessons, you will learn the core concepts of process and framework. Then, you will get the chance to develop B2B sales and marketing skills. Here, you will also develop the skills for forming sales teams, generating leads, creating business development plans and much more. After the completion of the course, you will receive a certificate of achievement. This certificate will help you pursue a promising career in the business world. Enrol now! Course Preview Learning Outcomes Familiarise yourself with the business development process and framework Understand the basics of B2B sales and marketing Grasp effective B2B marketing strategies Develop the skills for forming, managing and evaluating B2B sales team Enhance your knowledge of B2B selling techniques Build your expertise in sales management Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Developing business strategies Sales management Marketing Team management Who Should Take this Business Development Training (B2B)? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Business Development Training (B2B) course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Business Development Training (B2B) Certification After completing the Business Development Training (B2B) Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Pathâ This exclusive Business Development Training (B2B) course will equip you with effective skills and abilities and help you explore career paths such as Business executives Managers Sales executives Marketing executives Module 01: Introduction to Business Development Introduction to Business Development 00:27:00 Module 02: Fundamentals of B2B Sales and Marketing Fundamentals of B2B Sales and Marketing 00:15:00 Module 03: The B2B Buyer The B2B Buyer 00:13:00 Module 04: B2B Marketing Strategy B2B Marketing Strategy 00:14:00 Module 05: Sales and Marketing Alignment Sales and Marketing Alignment 00:14:00 Module 06: Forming a B2B Sales Team Forming a B2B Sales Team 00:14:00 Module 07: Generating B2B Leads Generating B2B Leads 00:15:00 Module 08: B2B Sales Techniques B2B Sales Techniques 00:16:00 Module 09: B2B Sales Management B2B Sales Management 00:14:00 Module 10: B2B Business Development Strategies B2B Business Development Strategies 00:27:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Learning more about advanced Microsoft Outlook features will help you become more productive. In the long run, knowing how to utilise this essential tool will help you in your career advancement. In this course, you will be learning about the advanced functions and features of Microsoft Outlook 2007. You will learn how customising Outlook will help you in using it efficiently. Know how adding word element emails to an email can be helpful and how to customise your profile. Understand how advanced E-mail tasks and advanced calendar tasks can function as you will learn how to manage your Outlook files and data well. Who is the course for? Professionals who want to learn about Microsoft functions and features, People who have an interest in knowing advanced Microsoft Outlook features. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. 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. Career Path: The Microsoft Outlook 2007 Advanced Workshop Manual is a useful qualification to possess and will be very beneficial and helpful, especially to the following professionals: Business IT Admin Secretary Project Management Microsoft Outlook 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Customizing Outlook 01:00:00 Module Three - Adding Word Elements to an E-mail 01:00:00 Module Four - Customizing Your Profile 01:00:00 Module Five - Advanced E-Mail Tasks 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More with Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Managing Outlook Data, Part One 01:00:00 Module Eleven - Managing Outlook Data, Part Two 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Outlook 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Outlook 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Outlook 2007 Advanced Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: In these days Keeping knowledge about data is an important part of your career. That's because to stand out in the workplace, you've got to be able to find information fast and to identify game-changing insights. This Microsoft Office 2013 Access Basic - Complete Video Course covers the basic functions and features of Access 2013. This course is designed to make you comfortable with what a database is all about and how to move around the screen. You will learn about working with table data, querying a database, how to create a simple database, and creating advanced queries. You will also learn how to generate reports and customize the Access environment. Here, you will get oriented with Microsoft Access, Windows Components, and more. This course will give you a basic understanding of the many Access 2013 features that will enable you to gather and interpret data faster than everyone else. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Access Basic - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Access Basic - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Access Orientation to Microsoft Access FREE 00:48:00 Create a Simple Access Database 00:28:00 Get Help in Microsoft Access 00:05:00 Working with Table Data Modify Table Data 00:13:00 Sort and Filter Records 00:06:00 Create Lookups 00:15:00 Querying a Database Join Data from Different Tables in a Query 00:14:00 Sort and Filter Data in a Query 00:19:00 Perform Calculations in a Query 00:11:00 Creating Advanced Queries Create Parameter Queries 00:11:00 Create Action Queries 00:08:00 Create Unmatched and Duplicate Queries 00:06:00 Summarize Data 00:09:00 Generating Reports Create a Report 00:10:00 Add Controls to a Report 00:08:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Customizing the Access Environment The Access Options Dialog Box 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Basic - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Basic - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10: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:17: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:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08: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:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23: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 Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19: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:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00