17266 Courses delivered Online

Learn to make your raw images more beautiful and appealing with a few simple tricks and easy to follow instructions! This photo editing course aims at providing you with a complete guideline to edit photos in Adobe Lightroom Classic CC and Adobe Lightroom CC. With this course, you will discover engaging lessons that incorporate Adobe Lightroom Classic CC, Adobe Lightroom CC, and Adobe Lightroom CC on a smartphone. Each and every topic of this course is presented in an easy to grasp manner. You will also develop your skills by learning a range of Photoshop techniques such as adjustment and white balance, vibrant and colour strength and many more. On completion, you will be able to manipulate images according to the need and create eye-catching photographs for branding and marketing. Work with this popular program to its full potential, whether you are using Lightroom Classic CC, Lightroom CC or Lightroom on the smartphone! Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal for people who want to start working as a receptionist, office administrator, office manager, administrative assistant or secretary Entry Requirement for this photo editing course: 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module: 01 0 Lightroom Course Promo 00:02:00 0.1 Promo for Lightroom CC Course 00:02:00 0.1 Promo Video Lightroom Classic CC Course 00:02:00 1.1 Course Introduction 00:03:00 1.1 Into Video 00:02:00 1.1 Intro Video V2 00:04:00 Module: 02 2.1 Importing 00:08:00 2.2 Organizing with Collections 00:07:00 2.4 Face Tagging 00:03:00 Module: 03 3.1 Enhancing Eyes 00:06:00 3.1 Crop and Rotate in Lightroom Classic CC 00:05:00 3.2 Whitening Teeth 00:03:00 3.2 Crop and Straighten 00:11:00 3.3 Exposure in Lightroom Classic CC 00:06:00 3.3 Smoothing Skin 00:02:00 3.4 Color and Saturation in Lightroom Classic CC 00:09:00 3.4 Removing Wrinkles 00:07:00 3.5 Enhancing Lips & Changing Lip Color 00:04:00 3.5 Presence Clarity and Saturation Jon 00:05:00 3.5 Sharpening and Noise Reduction in Lightroom Classic CC 00:07:00 3.6 Cheek Enhancements and Face Contouring 00:05:00 3.6 Tone Curve 00:07:00 3.6 Vignettes, Grain and Dehaze in Lightroom Classic CC 00:06:00 3.7 Exporting in Lightroom Classic CC 00:10:00 3.7 full portrait editing techniques 00:11:00 3.7 HSL 00:07:00 3.8 Lens Corrections in Lightroom Classic CC 00:05:00 3.9 Split Tone in Lightroom Classic CC 00:05:00 3.10 Removing Blemishes with the Heal and Clone Tools in Lightroom Classic CC 00:08:00 3.11 Graduated, Radial and Brush Adjustments in Lightroom Classic CC 00:10:00 3.12 Adjustment Brush Presets in Lightroom Classic CC 00:03:00 3.12 Calibrate Your Camera Profile 00:08:00 3.13 Range Masks in Lightroom Classic CC 00:05:00 3.13 Range Masks in Lightroom Classic CC 00:05:00 Module: 04 4.1 Full Edit - Car 00:15:00 4.1 The Adjustment Brush 00:04:00 4.1 Using, Creating, and Importing Presets 00:05:00 4.2 Color Profiles 00:04:00 4.2 Full Edit - Starry Sky 00:10:00 4.2 Radial Filter 00:03:00 4.3 Full Edit - Woman and Dog 00:15:00 4.3 Graduated Filter 00:05:00 4.3 Speed Up Your Editing Workflow 00:04:00 4.4 Full Edit - Snowy Landscape 00:11:00 4.4 Panorama 00:04:00 4.4 Spot Healing Brush 00:05:00 4.5 Full Edit - Icy River 00:12:00 4.5 HDR 00:03:00 4.6 Automatically Fix Exposure & White Balance 00:02:00 4.6 Full Edit - Surfs Up 00:10:00 4.7 Full Edit - Wildlife Bird 00:15:00 4.8 Full Edit - Roses are Red 00:11:00 Module: 05 5.1 Enhance Eyes and Change Eye Color 00:08:00 5.1 Exporting Photos from Lightroom 00:09:00 5.2 Adding a Watermark Lightroom 00:04:00 5.2 Whitening Teeth 00:03:00 5.3 Smoothing Skin 00:02:00 5.4 Removing Wrinkles 00:05:00 5.5 Enhancing Lips & Changing Lipstick Color 00:03:00 5.6 Enhancing Cheeks _ Face Contouring 00:08:00 5.7 Full Portrait Edit 00:07:00 Module: 06 6.1 Moonscape 00:11:00 6.1 Portrait of a Woman 00:20:00 6.2 Landscape Editing 00:07:00 6.2 Night Edit 00:15:00 6.3 Long Exposure 00:14:00 6.3 Ocean Flash Portrait 00:09:00 6.4 Group Photo Edit 00:16:00 6.4 Product Photo 00:12:00 6.5 Nature 00:09:00 6.5 Portrait With No Flash 00:05:00 6.6 Action 00:08:00 6.6 Lightroom To Match Color For Corporate Branding Images 00:06:00 6.7 Landscape 00:12:00 6.8 Travel 00:13:00 6.9 Couples Portrait 00:18:00 6.10 Architecture Photo 00:18:00 6.11 Aerial Photo 00:09:00 6.12 Street Photo 00:14:00 6.13 Macro Photo 00:10:00 6.14 Pet Photo 00:10:00 6.15 Maternity Couple Photo 00:12:00 6.16 Interior Nursery 00:13:00 6.17 Portrait of a Man 00:19:00 6.18 Sports Photo 00:10:00 Module: 07 7.1 Intro To Lightroom Mobile 00:03:00 7.1 The Map Module 00:04:00 7.2 Syncing Lightroom Mobile 00:08:00 7.2 The Book Module 00:10:00 7.3 Edit Lightroom Mobile 00:09:00 7.3 The Slideshow Module 00:10:00 7.4 Lightroom Mobile Organizing and Sharing 00:05:00 7.4 The Print Module 00:08:00 7.5 The Web Module 00:06:00 Module: 08 8.1 Conclusion and Thank You 00:02:00 8.1 Using Lightroom Presets 00:04:00 8.2 Installing Lightroom Presets 00:03:00 Module: 09 9.1 Calibrate Your Monitor 00:03:00 9.2 Color Checker Passport 00:10:00 9.3 Tablets 00:08:00 9.4 Catalogues 00:11:00 9.5 Brighten and Whiten Teeth and Eyes 00:04:00 9.6 Remove Wrinkles in Lightroom 00:05:00 9.7 Create a Panorama in Lightroom 00:03:00 9.8 Remove Red-Eye 00:01:00 9.9 Soften Skin in Lightroom 00:03:00 9.10 Reduce Noise in Your Photos 00:05:00 Module: 10 10.1 Google NIK 00:17:00 Module: 11 11.1 full lightroom session workflow 00:07:00 Module: 12 12.1 Conclusion 00:01:00 Resources Resources - Complete Guide to Adobe Lightroom Classic CC & CC - Photo Editing Masterclass 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Bookkeeping: Bookkeeper Training Course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Bookkeeping: Bookkeeper Training Course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Bookkeeping: Bookkeeper Training Course and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Bookkeeping: Bookkeeper Training Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Bookkeeping: Bookkeeper Training Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Bookkeeping: Bookkeeper Training Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum **Quickbook** Getting Prepared - Access The Software And Course Materials Set Up Free Trial 00:03:00 The Structure of The Course - First Things First! 00:05:00 Getting Started Starting A New Company File 00:11:00 Setting Up The System Enter Opening Balances 00:02:00 Reverse Opening Balances - Accruals And Prepayments 00:06:00 Report Journal 00:05:00 Nominal Ledger Amend The Nominal Ledger 00:07:00 Report Listing The Nominal Ledgers 00:02:00 Customers Enter Customers 00:09:00 Report On Customer Contact Information 00:01:00 Suppliers Enter Suppliers 00:05:00 Supplier Contact List 00:02:00 Sales Ledger Enter Invoices 00:09:00 Invoice Entering 00:03:00 Invoice Batch 00:06:00 Post Sales Credit Notes 00:08:00 Report Showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases Ledger Post Supplier Invoices 00:03:00 Entering A Batch Of Supplier Bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify Supplier Bills - Flash Bulbs Purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry Payments Post Cheques 00:07:00 Report Showing Supplier Payments 00:01:00 Sundry Receipts Receipts From Customers 00:07:00 Report Showing Customer Receipts 00:02:00 Petty Cash Post Petty Cash Transactions And Report 00:04:00 Post Cash Payments To Ledgers 00:02:00 Enter Petty Cash Items 00:14:00 Report On Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank Reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconnciled Transaction 00:02:00 Payroll / Wages Post The Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month End Adjustments 00:03:00 Month End Reports 00:06:00 Tasks Task- Clearing The Accounts 00:06:00 Task - Customer Report 00:01:00 Additional Resources Course Paper 00:00:00 Further Reading - QuickBooks Online 2014 The Handbook 00:00:00 **Xero Accounting** Getting Prepared - Access The Software And Course Materials Introduction To The Course And Your Tutor 00:04:00 Activating Your Free Trial With Xero 00:02:00 Getting Started Signing Up For The Free Trial 00:04:00 Create The Organisation 00:08:00 The Ficticious Scenario 00:02:00 Setting Up The System Add Bank Accounts To The System 00:14:00 Enter Opening Balances 00:07:00 Opening Trial Balance 00:01:00 Nominal Ledger Amend The Nominal Ledger 00:06:00 Chart Of Accounts Report 00:01:00 Customers & Suppliers Enter customers 00:07:00 Reporting Customer And Supplier Information 00:02:00 Sales Ledger Enter Invoices 00:07:00 Invoicing tips - adding logo, repeat billing 00:09:00 Entering Invoices 6574 to 6610 00:16:00 Post Credit Notes 00:03:00 Report Showing Customer Activity 00:08:00 Aged Debtors 00:02:00 Suppliers Post supplier invoices 00:09:00 Post supplier invoices 00:09:00 Enter More Supplier Invoices No 4308 Onwards 00:06:00 Credit Notes Suppliers 00:02:00 Supplier Activity Report 00:04:00 Aged Creditors Info 00:01:00 Reciepts from Customers 00:10:00 Apply Customer Credit Notes 00:05:00 Purchases Ledger Post Supplier Cheques 00:08:00 Apply Supplier Credit Notes 00:03:00 Print List Of Bank Receipts And Payments 00:01:00 Sundry Payments Post Sundry Payments 00:07:00 Make a credit card payment 00:08:00 Petty Cash Add Petty Cash Transactions - Week 1 00:16:00 Add Petty Cash Transactions - Week 2 00:12:00 Add Petty Cash Transactions - Week 3 00:07:00 Add Petty Cash Transactions - Week 4 00:09:00 Imprest System on Petty Cash 00:04:00 Print a Copy of Petty Cash Receipts and Payments 00:01:00 Bad Debt Writing Off A Bad Debt - Print Customer Statement 00:02:00 Write Off A Bad Debt 00:09:00 Credit Card Reconcile The Credit Card Statement 00:09:00 Bank Reconciliation Bank Statement As A CSV File 00:27:00 Bank Statement Closing Balances 00:11:00 Reconcile The Petty Cash 00:05:00 Payroll / Wages Wages And Salaries 00:09:00 Post the Wages Journal 00:07:00 Report Wages Journal 00:02:00 Payday 00:11:00 Pay The Two Staff 00:05:00 VAT - Value Added Tax Depreciation 00:04:00 VAT Return 00:03:00 Reports Month End Reports PnL, BS, TB 00:05:00 Payroll Unit Using Payroll 00:12:00 Setting Up Employees 00:10:00 Running Payroll - An Example 00:14:00 Conclude Recap And Next Steps 00:06:00 What happens next 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 5 Days 30 CPD hours This course is intended for This advanced course is for: AIX technical support personnel Performance benchmarking personnel AIX system administrators Overview Define performance terminology Describe the methodology for tuning a system Identify the set of basic AIX tools to monitor, analyze, and tune a system Use AIX tools to determine common bottlenecks in the Central Processing Unit (CPU), Virtual Memory Manager (VMM), Logical Volume Manager (LVM), internal disk Input/Output (I/O), and network subsystems Use AIX tools to demonstrate techniques to tune the subsystems In this course, students will develop the skills to measure, analyze, and tune common performance issues on IBM Power Systems running AIX. Day 1 Performance analysis and tuning overview Data collection Monitoring, analyzing, and tuning CPU usage Day 2 Virtual memory performance monitoring and tuning Day 3 Physical and logical volume performance File system performance monitoring and tuning Day 4 File system performance monitoring and tuning Network performance Day 5 NFS performance Performance management methodology

In today's competitive business world firms are under unprecedented pressure to deliver value to their shareholders and other key stakeholders. Senior executives in all parts of the organisation are finding that they need some degree of financial know how to cope with the responsibility placed on them as business managers and key decision-makers; monitoring and improving business performance, investing in capital projects, mergers and acquisitions: all require some degree of financial knowledge. The key financial skills are not as difficult to learn as many people believe and in the hands of an experienced senior executive they can provide a formidable competitive advantage. After completing this course delegates will be able to: Understand fundamental business finance concepts; understand, analyse and interpret financial statements: Profit Statement, Balance Sheet and Cashflow Statement Understand the vital difference between profit and cashflow; identify the key components of working capital and how they can be managed to generate strong cashflow Evaluate pricing decisions based on an understanding of the nature of business costs and their impact on gross margin and break-even sales; managing pricing, discounts and costs to generate strong business profits; understand how lean manufacturing methods improve profit Use powerful analytical tools to measure and improve the performance of their own company and assess the effectiveness of their competitors Apply and interpret techniques for assessing and comparing investment opportunities in capital projects, business acquisitions and other ventures; understand and apply common methods of business valuation Understand the role of business finance in formulating and implementing competitive business strategy; the role of budgeting as part of the planning process and the various approaches to budgeting and performance measurement 1 Basic principles Delivering value to key stakeholders Accounting concepts, GAAP, IFRS and common terms Understanding and using the balance sheet Understanding and using the profit statement Recognising the vital difference between profit and cashflow Understanding and using the cashflow statement What financial statements can and cannot tell us 2 Managing and improving cashflow Sources of finance and their advantages and disadvantages What is working capital and why is it so important? Managing stocks, debtors and creditors Understanding how working capital drives business growth Understanding and avoiding the over-trading trap Unlocking the funds tied up in fixed assets: asset backed loans and leasing 3 Managing and improving profit Understanding how profits generate cashflow The fundamental nature of costs: fixed and variable business costs Understanding gross margin and break-even How common pricing methods affect gross margin and profit Effective strategies to improve gross margin Using value chain analysis to reduce costs Lean manufacturing methodsUnderstanding Just-in-time, 6 Sigma and Kaizen methods Improving profitEffective and defective strategies 4 Measuring and managing business performance Measures of financial performance and strength Investor behaviour: the risk and reward relationship Return on investment (ROI): the ultimate measure of business performance How profit margin and net asset turnover drive return on net assets Why some companies are more profitable that others Understanding competitive advantage: cost and differentiation advantage Why great companies failWhat happened to Kodak? Using a 'Pyramid of Ratios' to improve business performance Using Critical Success Factors to develop Key Performance Indicators 5 Budgeting and forecasting methods Using budgets to support strategy Objectives and methods for effective budgets Using budgets to monitor and manage business performance Alternative approaches to budgeting Developing and implementing Balanced Scorecards Beyond Budgeting Forecasting methods and techniques Identifying key business drivers Using rolling forecasts and 'what-if' models to aid decision-making

Description: The advantage of digital photography is that you can take as much of photos you want without considering the film. You can take as much as your memory card can handle compared to a film that is very limited in quantity. Learning about digital photography will help you utilize the digital camera and its abilities. You will be able to produce good quality products that you can use if you aspire to be a professional photographer. This course will provide you the necessary knowledge and skills you will need to become one. Who is the course for? Photographers and other hobbyists who want to upgrade their photography skills People who have an interest in photography and want to acquire photography skills 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 Photography Bundle Course will be useful and would be beneficial for every kind of occupations and careers like: Camera Operator Digital Photographer Film and Video Editor Graphic Designer Photography Edit Professional Photographer. Stepping Into Photography Choosing Areas of Specialization in Digital Photography FREE 00:30:00 What Makes A Good Photographer? 01:00:00 Types of Cameras for Photography 00:45:00 Know About Your Camera How Does a Camera Capture an Image? 00:15:00 Which Digital Camera Features Do You Really Need? 00:30:00 Know The Basic Elements Of Your Digital Camera 00:45:00 RAW vs JPEG 00:15:00 Know About The Photographic Lenses Photographic Lenses 00:45:00 Framing Your Subject Rule of Thirds 00:15:00 The Modes of Your Camera Understanding Digital Camera Modes 00:45:00 Using Automatic Camera Modes 00:30:00 Capturing Light Exposure 00:30:00 Introduction to Aperture 00:45:00 Introduction to Shutter Speed 00:45:00 Introduction to ISO 00:45:00 Compositional Rules in Photography 00:30:00 Another Mode Of Your Camera Semi-Automatic Shooting Modes 01:00:00 Photography With Flash Flash Photography 01:00:00 Color in Photography Understanding Color in Photography 00:45:00 Edit Photos How to Edit Photos in Adobe Lightroom 00:45:00 Photo Editing Workflow Tutorial 01:00:00 Post Production Considerations 00:45:00 Shooting Landscapes Shooting Landscapes 00:45:00 Landscape Photography Tips 01:00:00 Basics of Photography How to Become a Digital Photographer? 02:00:00 Getting into the Scene 02:00:00 Choosing the Right Camera 02:00:00 Making Pictures for a Living 03:00:00 The Tools and Software for Editing the Images 02:00:00 The Most Commonly Asked Questions 01:00:00 Digital Photography How to Get the Most Out of Your Digital Camera Purchase 00:30:00 Why Having a DSLR is Like Having a Second Camera 00:30:00 What You Should Look for in a Digital Camera 01:00:00 The Benefits of Purchasing a DSLR Camera 01:00:00 Are You Getting the Most Out of Your Digital Camera? 00:30:00 Learning to Use Your Flash Properly on Your Digital Camera 00:30:00 Learn to Use Your Presets on Your Digital Camera 00:30:00 What Brand of Digital Camera is Best? 00:30:00 Understanding Shooting Speed on Your DSLR 00:30:00 Become a Good Photographer Before Buying Expensive Equipment 01:00:00 8 Digital Camera Brands You Should Know About 00:30:00 Do You Know the Best Digital Cameras to Buy? 00:30:00 Digital Camera and the Role of ISO 00:30:00 Digital Cameras Have Revolutionized Photography 00:30:00 Low Light Photography Tips 01:00:00 5 Rules of Buying a Point and Shoot Camera 00:30:00 4 Digital Camera Features You Should Understand 01:00:00 Nikon D5200 or Sony Alpha NEX-6 - Which is the Best Buy? 00:30:00 3 Basics to Consider While Buying a Digital Camera 00:15:00 Freelance Photography FREELANCE PHOTOGRAPHY AND YOU 00:30:00 SHOULD YOU BE IN THIS BUSINESS FOR YOURSELF? 01:00:00 WEDDINGS 01:00:00 PORTRAITS 01:00:00 CARDS 01:00:00 NEWSPAPERS 01:30:00 SPECIALTY PHOTOGRAPHY 01:00:00 COPYRIGHTING YOUR WORK 01:00:00 ESTABLISHING YOUR BUSINESS 00:30:00 Wedding Photography Techniques Know Why A Professional Wedding Photographer Is Best 01:00:00 The Importance Of A Wedding Photography Shot List 00:30:00 Mistakes First Time Wedding Photographers Make 00:30:00 A Wedding Photographer Cannot Be Timid 00:30:00 Are You Using RAW? 00:30:00 Getting Great Detail Wedding Shots 00:30:00 Make The Most Of The Unexpected With Wedding Photography 01:00:00 Problems On The Site For Wedding Photographers 01:00:00 Use Continuous Shooting Features 00:30:00 Wedding Photographer Gets Up High 01:00:00 Showcase Your Photos At The Wedding Reception 00:15:00 Wedding Photography With Two Cameras? 00:30:00 Selecting Property Wedding Photo Backgrounds 00:30:00 Wedding Photographer Tips For Changing Things Up 01:00:00 Wedding Photographers Should Check Out The Location 00:05:00 Wedding Photography And Diffused Light 00:30:00 Wedding Photographer Tips For Back Up Support 00:30:00 Wedding Photographer Tip For What Couples Expect From You 00:30:00 Wedding Photography: Handling The Family Photo 00:30:00 Wedding Photography Tip For Deleting As You Go 00:15:00 Wedding Photography Is Profitable 01:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Photography Bundle Course 00:30:00 Final Exam Final Exam- Photography Bundle Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Self-esteem and assertiveness are two essential skills for life success. None of your life's judgments is more important than what you make about yourself. Without some sense of self-worth, life can be extremely painful and unforgiving. Through this Self Esteem and Assertiveness Skills Course, you will learn some techniques that can dramatically change how you feel about yourself and how you approach the world to get what you want. A healthy self-esteem is necessary for growth and success. So, If you want to gain a solid and compact understanding of this topic and advance your career, this industry-standard, thorough Self Esteem and Assertiveness Skills Course is a good place to start. This comprehensive Self Esteem and Assertiveness Skills Course is designed to help delegates overcome these challenges on both a personal and professional level. This excellent course teaches delegates how to "be all they can be" both inside and outside of the working place. Delegates will learn to recognize their own "behavioral styles" as well as the behavioral styles of others, gaining insight into how they can influence, connect, and have a positive impact on relationships and situations both inside and outside of the workplace. This Self Esteem and Assertiveness Skills Course course will assist you in the process of personal growth by making you more aware of who you are, what you do in this Assertiveness and Self Esteem Development field, and the effects it has on others. Move past your fears, shyness, self-doubt, and negativity. Increase your self-esteem, improve your ability to influence others, and take action that will change your life for the better! Self-esteem & assertiveness are essential components of living a happy and successful life. Building assertiveness and self-esteem are essential for professional success. However, it is impossible to advance in your career without adequate training and guidance. And this Self Esteem and Assertiveness Skills Course Course is perfect for you in this regard. Learning Outcomes After completing Self Esteem and Assertiveness Skills Bundle course, the learner will be able to: Understand the fundamentals of self-esteem. Understand the fundamentals of assertiveness. Understand the importance of assertive communication. Understand the four basic styles of communication. Know how to respond to criticism. Gain a solid understanding of the XYZ formula for effective assertive communication. Gain in-depth knowledge of assertiveness in the workplace. Why Choose Self Esteem and Assertiveness Skills Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Self Esteem and Assertiveness Skills Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Course. ***Courses are included in this Self Esteem and Assertiveness Skills Course Course 01: Self Esteem and Assertiveness Skills Course 02: Level 7 Life Coaching Course 03: Dealing With Difficult People ***Other Benefits of this Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate will provide as soon as completing the Self Esteem and Assertiveness Skills course ] This comprehensive and accurate Self Esteem and Assertiveness Skills Course is an excellent place to start your career. You will gain a practical and theoretical understanding of this course, which will help you stand out from the competition and increase your earning potential in no time. So, once you've finished this exceptional Self Esteem and Assertiveness Skills Course, you'll have the practical knowledge and skills to pursue a variety of career opportunities in the field of assertiveness and self-esteem. After completing this Self Esteem and Assertiveness Skills Course, you'll be ready to take on any challenge and start your career in your desired industries/sectors by developing your skills. This Self Esteem and Assertiveness Skills Course will also improve your existing skills by taking them to the next level and providing up-to-date knowledge for facing tomorrow's challenges. This Self Esteem and Assertiveness Skills Course allows you to monetise your skills and makes success much easier. This course is appropriate for both full-time and part-time students and can be completed at your own pace. Our Self Esteem and Assertiveness Skills Course is the ideal one-stop solution for you to manage stress and develop persistence in your Assertiveness and Self Esteem Development work. Simply enroll in our Self Esteem and Assertiveness Skills Course, and we will take care of the rest. Detailed course curriculum *** Self Esteem and Assertiveness Skills *** Module 1: Understanding Self Esteem Defining Self-Esteem Signs of Low and High Self-Esteem What Causes Low Self-esteem? How is Low Self-esteem Related to Mental Health? Strategies to Build Healthy Self-Esteem How to Increase Your Self-esteem? What Can Friends and Family Do Help? Module 2: Understanding Assertiveness What is Assertiveness? The Origins of Assertiveness The Assertive Journey The Confidence Lane The Four Basic Styles of Communication Assertiveness vs. Aggressiveness Assertiveness vs. Passiveness Assertive Styles With Body Language Responding to Criticism Module 3: Assertiveness in Communication Assertive Communication Importance of Assertive Communication Outcomes & Benefits of Assertiveness Important Facts About Assertiveness Facets of Assertiveness XYZ Formula for Effective Assertive Communication Applications of Assertiveness Module 4: Assertiveness in Workplace Managing Assertively Assertive Roles at Work Managing Workplace Conflict 'I' Messages or 'I' Statements Social Confidence ------------------------- ***Free Courses: ------------------------- ***Level 7 Life Coaching*** Course Curriculum Module 01: Life Coaching Fundamentals Module 02: The Process of Life Coaching Module 03: Emerging Communication Skills Module 04: Introduction to Neuro-Linguistics Programming (NLP) Module 05: Mental Skills Development Module 06: Physical Skills Development Module 07: Body Language Module 08: Emerging Organizational Skills Module 09: Developing Creativity Module 10: Improving Presentation Skills Module 11: Developing Effective Negotiation Skills Module 12: Managing Your First Impression ------------------------- ***Dealing With Difficult People*** Course Curriculum Module 01: Difficult People and Their Difficult Behaviour Module 02: Communicating With Difficult People Module 03: Standing Up to Difficult People Module 04: A Quick Guide to the Seven Classically Difficult Types Module 05: Dealing with Bosses Who Drive You Barmy Module 06: Colleagues to Throttle Module 07: Dealing With Impossible People Module 08: The Temper Tantrum Type ------------------------- Assessment Method After completing each module of the Self Esteem and Assertiveness Skills Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Self Esteem and Assertiveness Skills Course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Self Esteem and Assertiveness Skills Course is ideal for anyone who wants to understand why Self Esteem & Assertiveness skills are important, how to develop and improve them, and how to advance their career. Including: Managers Team Leaders Office Executives Office Administrators Employees Business people Secretaries Receptionists Requirements Students who intend to enrol in Self Esteem and Assertiveness Skills Course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This course will help you move forward in your career by providing you with relevant information, skills, and a certificate of completion. You can expect to be significantly closer to achieve your goals after successfully completing this Self Esteem and Assertiveness Skills course. It's also securing the job you want, getting the promotion you deserve, or starting the business of your dreams. Certificates Certificate of completion Digital certificate - Included

Self-esteem and assertiveness are two essential skills for life success. None of your life's judgments is more important than what you make about yourself. Without some sense of self-worth, life can be extremely painful and unforgiving. Through this Self Esteem and Assertiveness Skill Course, you will learn some techniques that can dramatically change how you feel about yourself and how you approach the world to get what you want. A healthy self-esteem is necessary for growth and success. So, If you want to gain a solid and compact understanding of this topic and advance your career, this industry-standard, thorough Self Esteem and Assertiveness Skill Course is a good place to start. This comprehensive Self Esteem and Assertiveness Skill Course is designed to help delegates overcome these challenges on both a personal and professional level. This excellent course teaches delegates how to "be all they can be" both inside and outside of the working place. Delegates will learn to recognize their own "behavioral styles" as well as the behavioral styles of others, gaining insight into how they can influence, connect, and have a positive impact on relationships and situations both inside and outside of the workplace. This Self Esteem and Assertiveness Skill Course course will assist you in the process of personal growth by making you more aware of who you are, what you do in this Assertiveness and Self Esteem Development field, and the effects it has on others. Move past your fears, shyness, self-doubt, and negativity. Increase your self-esteem, improve your ability to influence others, and take action that will change your life for the better! Self-esteem & assertiveness are essential components of living a happy and successful life. Building assertiveness and self-esteem are essential for professional success. However, it is impossible to advance in your career without adequate training and guidance. And this Self Esteem and Assertiveness Skill Course is perfect for you in this regard. Learning Outcomes After completing Self Esteem and Assertiveness Skill course, the learner will be able to: Understand the fundamentals of self-esteem. Understand the fundamentals of assertiveness. Understand the importance of assertive communication. Understand the four basic styles of communication. Know how to respond to criticism. Gain a solid understanding of the XYZ formula for effective assertive communication. Gain in-depth knowledge of assertiveness in the workplace. Why Choose Self Esteem and Assertiveness Skill Course Bundle from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Self Esteem and Assertiveness Skill Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Course. ***Courses are included in this Self Esteem and Assertiveness Skill Bundle Course Course 01: Self Esteem & Assertiveness Skill Course 02: Communication Skills Course Course 03: Level 5 Negotiation Skills Course ***Other Benefits of the Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate will provide as soon as completing the Self Esteem and Assertiveness Skill course ] This comprehensive and accurate Self Esteem and Assertiveness Skill Course is an excellent place to start your career. You will gain a practical and theoretical understanding of this course, which will help you stand out from the competition and increase your earning potential in no time. So, once you've finished this exceptional Self Esteem and Assertiveness Skill Course, you'll have the practical knowledge and skills to pursue a variety of career opportunities in the field of assertiveness and self-esteem. After completing this Self Esteem and Assertiveness Skill Course, you'll be ready to take on any challenge and start your career in your desired industries/sectors by developing your skills. This Self Esteem and Assertiveness Skill Course will also improve your existing skills by taking them to the next level and providing up-to-date knowledge for facing tomorrow's challenges. This Self Esteem and Assertiveness Skill Course allows you to monetise your skills and makes success much easier. This course is appropriate for both full-time and part-time students and can be completed at your own pace. Our Self Esteem and Assertiveness Skill Course is the ideal one-stop solution for you to manage stress and develop persistence in your Assertiveness and Self Esteem Development work. Simply enroll in our Self Esteem and Assertiveness Skill Course, and we will take care of the rest. Detailed course curriculum *** Self Esteem and Assertiveness Skill *** Module 1: Understanding Self Esteem Defining Self-Esteem Signs of Low and High Self-Esteem What Causes Low Self-esteem? How is Low Self-esteem Related to Mental Health? Strategies to Build Healthy Self-Esteem How to Increase Your Self-esteem? What Can Friends and Family Do Help? Module 2: Understanding Assertiveness What is Assertiveness? The Origins of Assertiveness The Assertive Journey The Confidence Lane The Four Basic Styles of Communication Assertiveness vs. Aggressiveness Assertiveness vs. Passiveness Assertive Styles With Body Language Responding to Criticism Module 3: Assertiveness in Communication Assertive Communication Importance of Assertive Communication Outcomes & Benefits of Assertiveness Important Facts About Assertiveness Facets of Assertiveness XYZ Formula for Effective Assertive Communication Applications of Assertiveness Module 4: Assertiveness in Workplace Managing Assertively Assertive Roles at Work Managing Workplace Conflict 'I' Messages or 'I' Statements Social Confidence ------------------------- ***Other Courses: ------------------------- ***Communication Skills Course*** Course Curriculum Module 01: Introduction to Communication Module 02: The Communication Skills Module 03: Different Types of Communication Module 04: Different Methods of Communication Module 05: Styles of Communication Module 06: Barriers to Communication Module 07: Assessing Communication Competence: Relevant Criteria Module 08: Seven Actions for Effective Communication Module 09: Do's and Don'ts of Effective Communication ------------------------- ***Level 5 Negotiation Skills Course*** Course Curriculum Module 01: An Overview of Negotiation Module 02: How to Prepare For Negotiations Module 03: The Process of Negotiation Module 04: Ways of Developing Persuasion & Influencing Skills Module 05: Ways of Developing Communication Skills Module 06: How to Develop Active Listening Skills Module 07: Comprehending Body Language Module 08: Assertiveness and Self Confidence Module 09: Managing Anger Module 10: Managing Stress Module 11: Negotiation Tactics to Closing a Better Deal Module 12: Ways of Overcoming Sales Objections ------------------------- Assessment Method After completing each module of the Self Esteem and Assertiveness Skill, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Self Esteem and Assertiveness Skill, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This course is ideal for anyone who wants to understand why Self Esteem and Assertiveness skills are important, how to develop and improve them, and how to advance their career. Including: Managers Team Leaders Office Executives Office Administrators Employees Business people Secretaries Receptionists Requirements There are no specific requirements for Self Esteem and Assertiveness Skill because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This course will help you move forward in your career by providing you with relevant information, skills, and a certificate of completion. You can expect to be significantly closer to achieve your goals after successfully completing this Self Esteem and Assertiveness Skill course. It's also securing the job you want, getting the promotion you deserve, or starting the business of your dreams. Certificates Certificate of completion Digital certificate - Included

Unleash scientific curiosity with Spark Generation's adaptable study! Dive into flexible learning, exploring the wonders of Combined Science.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Electric Vehicle Battery Management System Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Electric Vehicle Battery Management System Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Electric Vehicle Battery Management System Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Electric Vehicle Battery Management System Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Electric Vehicle Battery Management System? 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 Electric Vehicle Battery Management System there will be a written assignment test which you can take either during or at the end of the course. 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 Electric Vehicle Battery Management System course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Electric Vehicle Battery Management System does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electric Vehicle Battery Management System 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 Electric Vehicle Battery Management System is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01 - Introduction Introduction 00:03:00 Section 02 - Passive Cell Balancing Passive Cell Balancing: Working Principle 00:09:00 Passive Cell Balancing: Hardware Circuit Design 00:06:00 Passive Cell Balancing: Balancing Current deciding factor 00:06:00 Passive Cell Balancing: Calculations 00:08:00 Passive Cell Balancing: Assignment 00:02:00 Section 03 - Voltage Measurement Voltage Measurement in Battery management system 00:02:00 Voltage Measurement: Hardware circuit design 00:04:00 Voltage Measurement: Component selection techniques 00:06:00 Section 04 - Current Measurement Current Measurement: Battery Pack 00:05:00 Current Measurement: Current Sense Resistor-based Hardware Circuit 00:09:00 Current Measurement: Assignment 00:02:00 Current Measurement: Sense Resistor and External amplifier 00:08:00 Current Measurement with Sense Resistor and External Amplifier: Assignment 00:02:00 Current Measurement: Hall Effect sensor 00:07:00 Current Measurement: Datasheet understanding 00:10:00 Current Measurement: Calculations 00:06:00 Current Measurement using Hall Sensor: Assignment 00:02:00 Section 05 - Temperature Measurement Temperature Measurement: In BMS 00:10:00 Temperature Measurement: Thermistor Calculation 00:13:00 Temperature Measurement: Assignment 00:02:00 Section 06 - Coulomb Counting Coulomb Counting - SoC Estimation 00:05:00 Coulomb counting: Calculation 00:03:00 Coulomb counting: Assignment 00:07:00 Section 07 - BMS IC Selection What parameters are taken to select your right BMS IC? 00:13:00 A tour to Texas Instrumentsfor BMS IC selection 00:09:00 A tour to Texas Instruments: Battery Protectors 00:10:00 A tour to Texas Instruments: Battery Monitors and Balancers 00:09:00 A tour to Texas Instruments: Fuel Gauge IC 00:13:00 Section 08 - MCU for BMS MCU for BMS: Basics 00:04:00 MCU for BMS: Selection Technique 00:07:00 MCU for BMS: Assignment 00:02:00 Section 09 - Lithium-ion Battery Cell Modeling Cell Modeling 1 00:02:00 Cell Modeling 2 00:02:00 Cell Modeling 3 00:09:00 Cell Modeling 4 00:08:00 Cell Modeling 5 00:14:00 Section 10 - UART Communication Communication Protocol 1 00:05:00 Communication Protocol 2.1 00:10:00 Communication Protocol 2.2 00:07:00 Communication Protocol 2.3 00:07:00 Communication Protocol 2.4 00:06:00 UART Demo 1 00:12:00 UART Demo 2 00:07:00 Section 11 - I2C Communication I2C communication protocol 1 00:06:00 I2C communication protocol 2 00:04:00 I2C communication protocol 3 00:06:00 I2C communication protocol 4 00:12:00 I2C communication protocol 5 00:04:00 I2C communication protocol 6 00:05:00 I2C communication protocol 7 00:14:00 I2C Demo 2 00:15:00 Section 12 - SPI Communication SPI Communication 1 00:06:00 SPI Communication 2 00:07:00 SPI Communication 3 00:06:00 Section 13 - CAN Communication CAN Communication 1.1 00:03:00 CAN Communication 1.2 00:04:00 CAN Communication 1.3 00:06:00 CAN Communication 1.4 00:07:00 CAN Communication 1.5 00:04:00 CAN Communication 1.6 00:06:00 CAN Communication 1.8 00:05:00 Section 14 - Power Management Power management 1 00:04:00 Power management 2 00:04:00 Power management 3 00:04:00 Power management 4 00:05:00 Section 15 - BMS Design for 12V application BQ76925 Datasheet: Part 1 00:09:00 BQ76925 Datasheet: Part 2 00:09:00 BQ76925 Datasheet: Part 3 00:14:00 BQ76925 Datasheet: Part 4 00:13:00 BQ76925 Reference Design: 1 00:10:00 BQ76925 Reference Design: 2 00:06:00 BQ76925 Reference Design: 3 00:06:00 BQ76925 Reference Design: 4 00:15:00 BQ76925 Reference Design: 5 00:05:00 BQ76925 Reference Design: 6 00:07:00 BQ76925 Reference Design: 7 00:06:00 Section 16 - Thank you Thank you 00:03:00 Downloadable Resources Resource - Electric Vehicle Battery Management System 00:00:00

The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF 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 Microsoft Excel 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 Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel 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 Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum 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: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: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: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 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 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 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00