12263 Video courses

Description This CompTIA Advanced Security Practitioner (CASP) - Video Training Course establishes knowledgeable professionals in the field of advanced security practices. At first you will learn about the enterprise security architecture, security technology and resource technology. Then you will learn security design and solutions, application security design, managing risk, security policies, security procedures and enterprise security integration. Finally, you will learn about security research and analysis, disaster recovery and business continuity, managing risk in projects, legal issues and judgment and decision-making. It involves applying critical thinking and judgment across a broad spectrum of security disciplines to propose and implement solutions that map to enterprise drivers. This course will prepare you to pass the exam CompTIA Advanced Security Practitioner (CASP). So, if you are interested to get this course don't delay to join now. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our CompTIA Advanced Security Practitioner (CASP) - Video Training 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. The Enterprise Security Architecture The Basics of Enterprise Security FREE 01:00:00 The Enterprise Structure 00:21:00 Enterprise Security Requirements 00:09:00 The Enterprise Security Technology Common Network Security Components and Technologies 00:55:00 Communications and Collaboration Security 00:40:00 Cryptographic Tools and Techniques 00:56:00 Advanced Authentication 00:14:00 Enterprise Resource Technology Enterprise Storage Security Issues 01:18:00 Distributed, Shared, and Virtualized Computing 00:26:00 Cloud Computing and Security 00:10:00 Security Design and Solutions Network Security Design 02:22:00 Conduct a Security Assessment 00:55:00 Host Security 01:19:00 Managing Risk in Projects Create a Risk Management Plan 01:15:00 Identify Risks and Their Causes 00:11:00 Analyze Risks 00:19:00 Develop a Risk Response Plan 00:07:00 Integrating Advanced Authentication and Authorization Techniques Implement Authentication 00:19:00 Implement Advanced 00:07:00 Implementing Cryptographic Techniques Describe Cryptographic Concepts 00:19:00 Choose Cryptographic Techniques 00:31:00 Choose Cryptographic Implementation 00:07:00 Integrating Hosts, Storage, Networks, and Apps in a Secure Enterprise Architecture Implement Security Standards in the Enterprise 00:13:00 Select Technical Deployment Models 00:28:00 The Enterprise Structure 00:21:00 Secure Enterprise Application Integration Enablers 00:21:00 Security Research and Analysis Perform an Industry Trends and Impact Analysis 00:41:00 Perform an Enterprise Security Analysis 00:26:00 Disaster Recovery and Business Continuity BCP Fundamentals 00:21:00 BCP Implementation 00:10:00 DRP Fundamentals 00:18:00 DRP Implementation 00:03:00 Responding to and Recovering from Incidents Design Systems to Facilitate Incident Response 00:14:00 Conduct Incident and Emergency Responses 00:20:00 Legal Issues Computer Crime Laws and Regulations 00:16:00 Computer Crime Incident Response 00:17:00 Judgment and Decision-Making Develop Critical Thinking Skills 00:12:00 Determine the Root of a Problem 00:06:00 Use Judgment to Make Sound Decisions 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

It is no secret that taking great photographs requires the right gears. So, capture the splendour of nature

The Savile Row Academy Advanced Course in Bespoke Tailoring and Cutting starts each September. The course is a modular programme of advanced study modules including; pattern drafting, cloth cutting, fitting and remarking; Waistcoat making; Trouser making; Coat making. Students will complete one three-piece suit and successful trainees will be awarded a Bespoke Tailor’s Certificate.

If you've always wanted to master in Photography, then this is the course for you. The Photography Fundamentals course will equip you with the useful lessons to improve your photography skills and enable you to become a professional photographer. This course teaches the essentials of photography in the fastest amount of time. Besides, you will understand the fundamental concepts and terms of the camera in the most efficient way possible. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Intro to Photography Promo FREE 00:01:00 Introduction 00:01:00 How does a camera work? 00:02:00 How to Expose Your Photo Properly Aperture 00:07:00 Shutter Speed 00:06:00 ISO 00:04:00 Exposure Triangle 00:05:00 Lights & Filters 00:03:00 Basic Camera Settings and Composition White Balance 00:03:00 File Types: JPEG vs. RAW 00:03:00 Photo Resolution & Quality 00:03:00 Composing Better Images Composition 00:06:00 Course Conclusion 00:02:00 Mock Exam Mock Exam - Photography Fundamentals 00:20:00 Final Exam Final Exam - Photography Fundamentals 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Our high performance camp is aimed at the better player looking for the tour player experience. The camp offers extensive 1:1 coaching using all the technology to include Trackman/GC Quad, video analysis, SAM PuttLab. Players will also be tested on the golf course with a challenging schedule of courses. This two week camp focuses on coaching and technical development in week 1 and 3 and tournament preparation in week 2 & 4 before competing in a 54 hole WAGR ranked tournament, during week 2 & 4. Golfers can stay for 1, 2, 3 or 4 weeks, please select the weeks you require.

Email Marketing is an effective digital marketing strategy of sending emails to prospects and customers. Effective email marketing converts prospects into customers and turns one-time buyers into loyal, and lifetime buyers. However, building a large list of quality subscribers takes time. Fortunately, there is AWeber - an affordable and easy to use email marketing and autoresponder tools that will make your work easy and fast. Using the tool, you can create professional email campaigns, grow your list and build your business. The Professional Email Marketing Diploma course shows you how to build a targeted email list of customers and run an email marketing through AWeber. The course covers step-by-step instructions on how to collect emails, create a relationship with your subscribers and grow your business. After completing the course, you will be able to export and upload pre-existing contacts, build a new list from scratch, compare and contrast various email autoresponders on the market to decide which is best for them. Shortly, you will learn to use software like AWeber for creating email campaigns. What Will I Learn? Export and upload pre-existing contacts, build a new list from scratch, compare and contrast various email autoresponders on the market to decide which is best for them and Use an email software to create email campaigns Requirements You should be able to use a PC at beginners level and have access to the internet Module: 01 Introduction and the Biggest Mistakes People Make With Email Marketing FREE 00:06:00 Introduction to Course Tutor FREE 00:15:00 What is email marketing all about? FREE 00:04:00 Promotional Email 00:08:00 Value Email 00:10:00 Email Checklist 00:12:00 Autoresponder - Send a broadcast 00:14:00 Example Promotional Email 00:03:00 Testing the broadcast 00:02:00 Send the broadcast 00:04:00 Module: 02 How to add a pop up opt in 00:07:00 How to add a pop over opt in 00:13:00 Autoresponders 00:06:00 Free Trial Aweber 00:02:00 Create a New List 00:05:00 Turn off double opt in 00:03:00 Company Branding 00:05:00 Create an opt in box 00:10:00 Pop up box opt in 00:02:00 Module: 03 Blog 24 Follow up email series 00:13:00 Blog 25 Email test 00:17:00 The Benefits of the Internet 00:06:00 What are we trying to achieve 00:09:00 6 steps to a video opt in 00:11:00 End result 00:06:00 Next steps 00:05:00

Register on the Sell Stock Footage & Photography from ZERO to PASSIVE INCOME today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Sell Stock Footage & Photography from ZERO to PASSIVE INCOME course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Sell Stock Footage & Photography from ZERO to PASSIVE INCOME course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Sell Stock Footage & Photography from ZERO to PASSIVE INCOME course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Welcome & How it All Works, 00:05:00 Proof of Success: How much a file can make 00:03:00 What Differentiates Pros & Beginners 00:04:00 Do Your First Upload Understand Licensing 00:04:00 Meet the (Profitable) Agencies 00:04:00 Become a Contributor 00:02:00 Shoot Something NOW 00:01:00 Upload Your First File 00:01:00 Write Metadata & Submit 00:02:00 Pic a Topic that Sells Mine, Observe & Produce 00:05:00 STUDY CASE: Mine & Observe 00:06:00 Understand Your Customer 00:05:00 Watch The Trends 00:06:00 STUDY CASE: Make The Most Of Your Travelling 00:04:00 ASSIGNMENT: Mine or Capture 00:01:00 STUDY CASE- The Bestsellers of 2018 00:12:00 Shoot & Release Understand Technical Requirements 00:06:00 STUDY CASE: Creative Shot Ideas 00:03:00 Get a Release Signed 00:03:00 Get a Digital Signature 00:04:00 Understand Commercial & Editorial 00:04:00 Find Models for Stock Footage & Photography 00:08:00 Editing Edit Your Photos & Illustrations 00:04:00 Edit Your Footage 00:03:00 Export With Confidence 00:04:00 Upload & Submit Upload Your Photos 00:07:00 Upload Your Video Files 00:03:00 Write Professional Metadata (Keywords & Description) 00:07:00 How To Upload Editorial Content 00:02:00 Speed Up & Grow Your Income Speed up your Stock Photography Workflow 00:05:00 Speed up your Stock Footage Workflowaa 00:04:00 Write keywords quickly & efficiently 00:08:00 Diversify earnings with Multi-uploaders - Alternative I: StockSubmitter 00:08:00 Diversify earnings with Multi-uploaders - Alternative II: Xpiks 00:12:00 CSV Spreadsheets: Organize and Upload Metadata for Multiple Stock Files 00:11:00 Google Trends & Shutterstock Search 00:06:00 Conclusion Thanks & What's Next 00:01:00 Master The Agencies BlackBox 00:07:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Award Winning Scalp Micropigmentation 3 Day Training Course including a full equipment kit. £2499. Near Manchester

Register on the Graphic Design - Colour Theory today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Graphic Design - Colour Theory course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Graphic Design - Colour Theory course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Graphic Design - Colour Theory course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Module 01: Colour Theory- Basic Terms 00:03:00 Module 02: Use Values to Establish Hierarchy in Photoshop CC 00:04:00 Module 03: Class Exercise: Value 00:01:00 Module 04: Colour Fundamentals: Colour Wheel 00:02:00 Module 05: Colour Combinations 00:05:00 How To Work With Colours In Adobe Illustrator CC 2020 Module 06: Colour Modes in Adobe Illustrator CC 00:01:00 Module 07: Working with Existing Colours 00:02:00 Module 08: Customising Colours 00:01:00 Module 09: Save Colour Swatches 00:01:00 Module 10: Global Colours 00:01:00 Module 11: Duplicate Global Colours 00:01:00 Module 12: Adobe Colour Themes 00:04:00 Module 13: Colour Guides 00:01:00 Module 14: Recolour Artwork 00:03:00 Module 15: Colouring the Line Art 00:03:00 Module 16: Save as Template 00:03:00 Colour Systems Module 17: CMYK Colour System 00:02:00 Module 18: RGB Colour System 00:01:00 Module 19: Pantone Colour System 00:01:00 Different Techniques To Develop Successful Colour Palettes Module 20: Colour Technique - The Subordinate, Dominant and Accent Technique 00:01:00 Module 21: Colour Technique - Meaning Based Technique for Harmonising Colours 00:01:00 Module 22: Colour Technique - Meaning Based Colour Technique Exercise 00:03:00 Module 23: Colour Technique - One Colour Palette Technique 00:01:00 Module 24: Colour Technique - Two Colour Palette Technique 00:01:00 Module 25: Colour Technique - Progressive Colour Technique 00:01:00 Module 26: Colour Technique - Repetition or Reoccurrence or Gradient Technique 00:01:00 Module 27: Colour Progression and Repetition Exercise 00:08:00 Module 28: Colour Technique- Black and White Technique 00:02:00 Module 29: Colour as Provocateur 00:01:00 Module 30: Excessive Colour Solutions 00:02:00 Module 31: Colour Overlap Technique 00:01:00 Colour Interaction And Proximity Module 32: Introduction 00:01:00 Module 33: Colour Interaction 00:01:00 Module 34: Different Colour Types 00:04:00 Module 35: Class Exercise: Colour Interaction 00:03:00 Module 36: How Light Affect Your Colours 00:01:00 Module 37: Interaction and Proximity 00:01:00 Module 38: Colour Proximity Exercise 00:02:00 Module 39: How to Make that Geometric Grid Design to Practice Your Colour 00:08:00 Colour And Imagery Module 40: Colour in Images, Illustrations and Type 00:01:00 Module 41: Colour and Imagery 00:01:00 Module 42: Best Royalty-free Images Websites 00:02:00 Module 43: Apply Colour to Your Images in Photoshop CC 00:06:00 Module 44: Images as Element of the Composition 00:04:00 Module 45: Proofing Colours 00:05:00 Module 46: Save for Printing 00:02:00 Module 47: Class Project- Colour and Texture 00:03:00 Colours And Illustration Module 48: Colour and Illustration 00:02:00 Module 49: Best Resources to Get Customisable Illustration 00:02:00 Colour And Type Module 50: How to Use Colours and Type 00:01:00 Module 51: Colour and Hierarchy 00:01:00 Module 52: Display text 00:02:00 Module 53: Specific Fonts 00:01:00 Module 54: Body Text and Colour 00:02:00 Module 55: Apply Effects to Display Text in Adobe Illustrator 00:04:00 Module 56: Best Fonts Resources Websites 00:02:00 Module 57: Class Project- Magazine Mock-up 00:07:00 Colours In Data Visualisation Module 58: Introduction to Colours in Data Visualisation 00:01:00 Module 59: Colours in Data Visualisation 00:03:00 Module 60: Different Ways to Import Charts 00:04:00 Module 61: The Process of Decluttering 00:09:00 Colours In Brand Identity Basics Module 62: Introduction to Colours in Branding 00:01:00 Module 63: Colours in Brand Identity- Part 1 00:10:00 Module 64: Colours in Brand Identity- Part 2 00:06:00 Module 65: Class Project- Logo 00:01:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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