Description Explore the strategies of viewing, creating, manipulating, printing and managing files in Portable file Documents with the Adobe Acrobat 9 Advanced course. The course is designed for the people who have the basic knowledge of Adobe Acrobat version 9 and want to upgrade their skill. The course teaches you how to use the document properties and how to compare the documents. You will able to identify which document is the newest one by using the option of compare files from the Review and Approve groups which you will find in the tool option. The course also teaches you how to enhance the scan documents, and how to add sound, video, and buttons to your PDF. Apart from these, the course shows you how to use the Measurement tools to measure objects such as drawings. The use of distance tools, perimeter tool, the area tool, etc. will be discussed in the course. You will know how to create a form from the Word Document, how to run an accessibility test, how to create a digital signature, how to add a signature to your PDF. Shortly, the video course makes you an expert and advanced users of Adobe Acrobat 9. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Adobe Acrobat 9 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 Adobe Acrobat 9 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. Introduction Introduction 00:02:00 Advanced Document Tools Using Document Properties 00:11:00 Comparing Documents 00:04:00 Enhancing Scans 00:04:00 Adding Rich Media Adding Sound 00:04:00 Adding Video 00:03:00 Adding buttons 00:07:00 Using the Measurement Tools Understanding the Measurement Tool 00:03:00 Using the Distance Tools 00:02:00 Using the Perimeter Tool 00:02:00 Using the Area Tool 00:01:00 Creating Forms Creating a Form from a Word Document 00:03:00 Creating a Form from InDesign 00:02:00 Adding Form Elements 00:07:00 Adding Check Boxes and Radio Buttons 00:04:00 Distributing Forms 00:05:00 Understanding Accessibility What is Accessibility? 00:02:00 Running an Accessibility Test 00:06:00 Creating Signatures and Certificates What is a Digital Signature? 00:02:00 Creating a Digital Signature 00:04:00 Adding a Signature to a Document 00:01:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
The Youtube Marketing is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Youtube Marketing consists of several modules that take around 2 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. 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 Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Youtube Marketing How To Get More YouTube Views - INTRO 00:02:00 How To Go Viral On YouTube 00:05:00 How To Increase YouTube Views & Watchtime 00:09:00 YouTube Thumbnails 00:09:00 Great Video Ranking Tips 00:07:00 Secret To Getting YT Views Likes & Subscribers 00:11:00 Guru Secret - CPA Profits 00:07:00 SEO WHITE PAPERS FOR YOUTUBE RANKING & SUGGESTED VIDEOS 00:03:00 SEO WHITE PAPERS FOR YOUTUBE RANKING & SUGGESTED VIDEOS (Alison) 00:03:00 TubeBuddy Tutorial 00:30:00 Finding Great Keywords For Maximum Success 00:06:00 YouTube Ranking - Video Description SEO 00:07:00 YouTube Ranking - Turning Keywords into the Description 00:03:00 Getting in Suggested YouTube Videos 00:05:00 YouTube Ranking - Syndwire SynLab 00:07:00 YouTube Rankings - Live Event Blaster 00:06:00 YouTube Ranking - Translations for morw Views and Sales 00:03:00 BONUS - Get More YouTube Veiws - Sharree 00:07:00 BONUS - PilotPoster 00:03: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.
Duration 3 Days 18 CPD hours This course is intended for This class is designed for anyone looking to edit professional-quality video with Final Cut Pro X and who prefers hands-on and interactive instruction to best explore its functionality. Overview Start with basic video editing techniques and work all the way through Final Cut Pro's powerful advanced features. Students work with dramatic real-world media to learn the practical techniques used daily in editing projects. Final Cut Pro X is a revolutionary video editing application that makes it possible for beginners and professionals to achieve stunning results. This course teaches students to perform editing functions and becoming familiar with the user interface. Exploring the Final Cut Pro X Interface Following a Workflow Opening Final Cut Pro X Exploring the Interface Using Menus and Shortcuts Viewing and Sorting Events Skimming Clips and Changing Views Viewing and Creating Projects Working in the Project Library Viewing Projects in the Timeline Hiding and Quitting Final Cut Pro Importing Importing Media into an Event Importing Folders as Keyword Collections Analyzing and Correcting Imported Clips Importing from a Camera Importing from the Finder Importing from Other Applications Organizing Clips in an Event Using Metadata to Customize an Event Adding Keywords to Clips Assigning Multiple Keywords to Clips Applying Keywords to a Clip Range Rating, Sorting and Searching Clips Creating Smart Collections Building a Rough Cut Creating a New Project Screening and Marking Clips Appending Clips in the Timeline Viewing and Arranging Clips in the Magnetic Timeline Inserting Clips into the Primary Storyline Changing Edited Clips Connecting Clips to the Primary Storyline Closing your Project Finetuning a Rough CutAdding to the Primary Storyline Duplicating a Project Removing Clip Selections and Adding Gaps Understanding Trimming, Applying the Trim Tool Trimming with Precision Applying Transitions Preparing for Transitions Applying a Video Transition Using the Transitions Browser Modifying Transitions Changing Transition Parameters in the Inspector Adding Transitions to Other Storylines and Compound Clips Exploring Audio Transitions Working with Sound Monitoring and Adjusting Audio in the Timeline Adding Music and Sound Effects, Adjusting Levels in the Audio Inspector Creating Audio Fades Recording a Narration Track Correcting Problem Audio Working with Titles, Generators and Themes Using the Titles Browser Adding a Lower Third Modifying Titles Adding Bumpers and Credits Working with Video Generators Using Themes Retiming and Transforming Clips Understanding Motion Properties Retiming Clips Creating Holds and Variable Speed Segments Applying Preset Speed Effects Transforming an Image Cropping an Image Adding a Ken Burns Effect Creating Keyboard Shortcuts Applying Effects and Enhancing Color Applying Video Effects Modifying Effect Parameters Auditioning and Animating Effects Applying Audio Effects Enhancing Color in Final Cut Pro Exporting and Sharing Your Project Preparing a Project for Exporting and Sharing Detecting Audio Peaks Adjusting Video Levels for Broadcast Exporting Movie File Publishing a Project to Apple Devices Publishing a Project to Video Sharing Sites Exporting an Image from your Project Exporting for Blue-Ray Disc, DVD, or Disk Image Certification Exam Students can take an end user exam to earn Apple Certified Pro, Final Cut Pro X Level One status Additional course details: Nexus Humans Apple - Mac Final Cut Pro X - Level 101 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Apple - Mac Final Cut Pro X - Level 101 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Description: This Microsoft Office 2013 Word Advanced - Complete Video Course covers the advanced functions and features of Word 2013. With this advanced level, you will learn advanced skills in using Microsoft Word 2013 and be able to demonstrate the use of advanced and specialized features within the application. You should be able to create, manage, and distribute professional documents for a variety of specialized purposes and situations, and be able to customize Word 2013 environment to meet specific needs to enhance productivity. By this series, you will learn about collaborating on documents and adding reference marks and notes. You will also learn how to manage long documents, secure a document and work with forms, and more. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Word 2013 at an expert level. 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 Word Advanced - 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 Word Advanced - 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. Collaborating on Documents Modify User Information FREE 00:06:00 Share a Document 00:03:00 Compare Document Changes 00:09:00 Review a Document 00:11:00 Merge Document Changes 00:01:00 Review Tracked Changes 00:09:00 Coauthor Documents 00:10:00 Adding Reference Marks and Notes Add Captions 00:07:00 Add Cross-References 00:09:00 Add Bookmarks 00:08:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:06:00 Add Citations and a Bibliography 00:14:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:06:00 Insert an Index 00:12:00 Insert a Table of Contents 00:05:00 Insert an Ancillary Table 00:09:00 Manage Outlines 00:08:00 Create a Master Document 00:08:00 Securing a Document Suppress Information 00:08:00 Set Formatting and Editing Restrictions 00:04:00 Add a Digital Signature to a Document 00:09:00 Restrict Document Access 00:03:00 Forms Create Forms 00:14:00 Manipulate Forms 00:04:00 Mock Exam Mock Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: This Microsoft Office 2013 Outlook Advanced - Complete Video Course covers the advanced functions and features of Outlook 2013. You will learn about configuring advanced message options and advanced message, calendar and contact management. In this course you will learn how to successfully use Outlook to manage the numerous aspects of communicating electronically, including: managing email communications, managing calendar events, managing your contacts, using notes to keep yourself informed, sending and receiving invites, performing advanced message, calendar, and contacts management tasks, working with the tasks and journal workspaces, and more. It will explain all of the features and functionalities the application offers in an easy to understand. You will also learn how to manage activities by using tasks and journal entries, share workspaces with others and manage outlook data files. This course is intended for them who have basic skills with Microsoft Office 2013 Outlook, and want to learn more advanced skills. 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 Outlook Advanced - 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 Outlook Advanced - 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. Configure Advanced Message Options Insert Advanced Characters and Objects FREE 00:24:00 Modify Message Settings, Properties, and Options 00:11:00 Using an Automatic Reply 00:07:00 Advanced Message Management Sort Messages 00:03:00 Filter Messages 00:03:00 Organize Messages 00:09:00 Search Messages 00:09:00 Manage Junk Mail 00:04:00 Manage Your Mailbox 00:04:00 Advanced Calendar Management Manage Advanced Calendar Options 00:10:00 Create Calendar Groups 00:04:00 Manage Meeting Responses 00:05:00 Advanced Contact Management Edit an Electronic Business Card 00:07:00 Manage Advanced Contacts Options 00:04:00 Forward Contacts 00:02:00 Export Contacts 00:03:00 Managing Activities by Using Tasks and Journal Entries Assign and Manage Tasks 00:14:00 Record and Modify Journal Entries 00:06:00 Sharing Workspaces with Others Delegate Access to Mail Folders 00:05:00 Share Your Calendar 00:04:00 Share Your Contacts 00:02:00 Managing Outlook Data Files Back Up Outlook Items 00:02:00 Change Data File Settings 00:04:00 Mock Exam Mock Exam- Microsoft Office 2013 Outlook Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Outlook Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Nowadays data management is absolutely crucial, and there's not much room for error. If you've already taken the basic Microsoft Access 2013 course, or know your way around the program already, then you're ready for this advanced level of Microsoft Access 2013. This Microsoft Office 2013 Access Advanced - Complete Video Course covers advanced functions and features of Access 2013. You will learn about implementing advanced form design, using data validation and using macros to improve user interfacer design. You will also learn how to use advanced database management, distribute and secure a database and manage switchboards. If you want to take your Microsoft Access 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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 Advanced - 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 Advanced - 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. Implementing Advanced Form Design Add Controls to Forms FREE 00:22:00 Create Subforms 00:03:00 Organize Information with Tabs Pages 00:05:00 Enhance Navigation of Forms 00:06:00 Apply Conditional Formatting 00:05:00 Using Data Validation Field and Record Validation 00:23:00 Form Validation 00:08:00 Using Macros to Improve User Interface Design Create a Macro 00:17:00 Restrict Records Using a Condition 00:05:00 Validate Data Using a Macro 00:06:00 Automate Data Entry Using a Macro 00:06:00 Convert a Macro to VBA 00:05:00 Using Advanced Database Management Link Tables to External Data Sources 00:05:00 Manage a Database 00:07:00 Determine Object Dependency 00:05:00 Document a Database 00:05:00 Analyze the Performance of a Database 00:05:00 Distributing and Securing a Database Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:09:00 Set Passwords 00:07:00 Convert an Access Database to an ACCDE File999 00:07:00 Analyze the Performance of a Database 00:04:00 Managing Switchboards Create a Database Switchboard 00:07:00 Modify a Database Switchboard 00:04:00 Set Startup Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
This course helps you prepare for your CISSP certification. In this course, we will be discussing Domain 2, which covers 10% of the exam weightage.
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 Microsoft Office 2007 Excel Intermediate - Complete Video Course will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. 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 2007 Excel 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 2007 Excel 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. Using Multiple Worksheets and Workbooks Using Multiple Workbooks FREE 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:08:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00