12804 Courses in Liverpool delivered Online

Learn video editing with iMovie on your Mac from scratch. Create stunning videos with ease – perfect for beginners!

Course Overview If you want to create customized graphics for your website, then canva mobile app is one of the easiest and most effective options for you. Learn how you can create graphics using canva mobile app from the Build Pro Web Graphics Using Canva Mobile App course and make your content more original and attractive.  This Build Pro Web Graphics Using Canva Mobile App course will teach you how you can use graphics to make your content attractive, boost your branding and make your promotion and responses faster. You will learn the basics of canva designing, colour theories, importing, editing and exporting files, using canva graphics for your website and many other functions that will help you use the platform of canva effectively. This course is ideal for anyone who wants to learn graphic designing and use it to promote their business using canva. This will help you to understand how graphic designing can improve your promotion quality, content quality, make your website more interesting and attract more viewers. Learning Outcomes Learn the basic functions of canva Create fantastic and professional graphic designs Be able to use fast and convenient designs for your websites Understand how to edit your graphics using canva mobile app Import, edit and export files in canva Use canva library to create professional and breathtaking designs Who is this course for? This course is especially for those who want to learn the techniques of web graphic designing using canva. You will learn easy steps that will help you to create beautiful and attractive web graphics by canva. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Build Pro Web Graphics Using Canva Mobile App is a useful qualification to possess and would be beneficial for any related profession or industry such as: Graphic Designers Editors Video Editors Illustrators Web Designers Unit 01: Working with Adobe Colours Online Introduction to Adobe Colour 00:03:00 Adobe Colour Lesson 2 00:03:00 Adobe Colour Lesson 3 00:05:00 Unit 02: Basic Graphics Design using Canva Getting Started 00:03:00 Designing a Flyer 00:10:00 How to Create Professional Quote Designs 00:18:00 How to Create A Story or WhatsApp Status Design 00:17:00 WhatsApp Status Design 00:06:00 Unit 03: Photo-Editing Basics Snapseed 00:14:00 Double Exposure 00:16:00 Exposure Adjustments 00:06:00 Colour Splash Part-1 00:15:00 Colour Splash Part-2 00:17:00 Unit 04: Intermediate to Pro Lessons on Canva Graphic Designs Create Flyer Designs on Canva 00:28:00 How to Work with Layers in Canva App 00:02:00 Unit 05: Bonus Creating a 3D Mockup Design withYour Phone 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This course is intended for anyone who is responsible for day-to-day management of many FortiGate devices via the FortiManager platform. Overview Describe capabilities of FortiManager Add FortiGate devices to Device Manager and import their running configuration Use provisioning templates and scripts for device-level changes across many devices Identify the synchronization states Manage the revision history of managed devices Offer a local FortiGuard Distribution Server to your Fortinet devices Deploy administrative domains (ADOMs) to support multiple customers on a single FortiManager Manage firewall policies across multiple FortiGate devices using policy packages with shared and dynamic objects Deploy policies and objects from the global ADOM to multiple ADOMs Explain high availability, backup, and recovery options for FortiManager Compare methods for centrally managing IPsec VPNs Explain the restricted ''admin'' profile and API high-level usage Use workspaces and workflow mode Identify steps to replace a managed FortiGate device Manage FortiGate devices' firmware centrally In this 2-day class, you will learn the fundamentals of using FortiManager for centralized network administration of many FortiGate devices. Example use cases include large enterprise and carrier networks. Course Outline Module1 - Introduction and Initial Configuration Module2 - Administration and Management Module3 - Device Registration Module4 - Device Level Configuration and Installation Module5 - Policy and Objects Module6 - Manager Panes Module7 - Diagnostics and Troubleshooting Module8 - Advanced Configuration Additional course details: Nexus Humans FortiManager 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 FortiManager 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.

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

Who is this course for? Advanced 3ds Max and After Effects Masterclass. This course is designed for 3D artists, animators, and visual effects artists seeking comprehensive training in 3ds Max and After Effects. Whether you're a beginner or an intermediate learner, this course provides skills and techniques for creating stunning 3D models and captivating visual effects. Check our Website Duration: 10 hours Training Approach: 1-on-1 Sessions and Tailored Content. When: Book anyday Mon to Sat between 9 am and 7 pm. Course Title: Motion Graphics Mastery: 3ds Max and After Effects Duration: 10 hours Course Highlights: Introduction to 3ds Max: Get acquainted with the 3ds Max interface Create captivating 3D objects and scenes Explore cameras, lighting, materials, and textures Basic Animation Principles in 3ds Max: Grasp keyframes and interpolation techniques Craft seamless animation cycles for 3D objects Apply animation principles with precision using the graph editor Advanced Animation Techniques in 3ds Max: Master custom controllers and expressions for intricate animations Utilize inverse kinematics for lifelike motion Create dynamic particle systems and simulations for realistic effects Exporting 3D Scenes to After Effects: Prepare 3D scenes for seamless export Effortlessly import 3D scenes into After Effects Explore 3D layer properties for depth and realism Basic Compositing in After Effects: Navigate the After Effects interface with confidence Utilize keyframes and animation curves for smooth transitions Blend 2D and 3D elements seamlessly Apply a variety of effects and filters for added visual impact Advanced Compositing Techniques in After Effects: Employ masks and mattes for precision and creative effects Harness the power of 3D camera tracking for realistic integration Work with green screen footage for professional compositions Create breathtaking special effects that captivate the audience Integrating 3D and Live-Action Footage in After Effects: Match camera angles and movements seamlessly Incorporate 3D camera data for dynamic compositions Add shadows and reflections to enhance realism Rendering and Outputting Animations: Efficiently render 3D scenes from 3ds Max Utilize the After Effects render queue for optimized output Export animations in various formats tailored to specific needs Motion Graphics Projects: Craft a fundamental motion graphics sequence Design a captivating animated logo Create an engaging animated title sequence that captures attention Course Requirements: Computer with 3ds Max and After Effects software installed Basic understanding of computer operations Enthusiasm for exploring the world of motion graphics and animation Upon completing the Motion Graphics Mastery: 3ds Max and After Effects course, participants will: Master 3D Animation: Gain expertise in creating intricate 3D objects, scenes, and animations in 3ds Max, applying advanced animation principles and techniques. Seamless Integration: Learn to seamlessly export 3D scenes from 3ds Max to After Effects, effectively blending 2D and 3D elements for dynamic compositions. Advanced Compositing: Acquire advanced compositing skills, including the use of masks, mattes, 3D camera tracking, and green screen techniques to create professional-grade visual effects. Professional Rendering: Understand the process of rendering 3D scenes and animations, ensuring optimal quality for various output formats. Motion Graphics Projects: Develop practical motion graphics projects, including motion sequences, animated logos, and title sequences, showcasing creativity and technical proficiency. Creative Problem-Solving: Enhance problem-solving skills through hands-on projects, allowing participants to tackle real-world motion graphics challenges effectively. Industry-Standard Tools: Gain proficiency in using industry-standard software tools - 3ds Max and After Effects - essential for careers in animation, visual effects, and motion graphics. Professional Portfolio: Create a compelling portfolio of motion graphics work, showcasing diverse skills and creativity, essential for professional opportunities in the field. Effective Collaboration: Develop teamwork and communication skills by collaborating on motion graphics projects, fostering a collaborative and creative working environment. Confidence and Expertise: Build confidence in applying animation principles, compositing techniques, and visual effects skills, enabling participants to approach complex projects with confidence and creativity. Download Adobe After Effects. Download Autodesk 3ds max. Skills Acquired: Advanced 3D Modeling: Master the intricacies of 3D object creation and manipulation in 3ds Max. Visual Effects Creation: Learn the art of crafting compelling visual effects using After Effects. Texturing and Lighting: Understand texturing techniques and lighting principles for realistic 3D scenes. Animation Techniques: Develop skills in animating 3D models and adding dynamic motion to visual effects. Job Opportunities: 3D Modeler: Create detailed and realistic 3D models for various industries. Visual Effects Artist: Work in film, TV, or advertising, creating stunning visual effects sequences. Motion Graphics Designer: Design animated graphics and visual elements for videos and multimedia projects. Game Designer: Contribute to game development by creating 3D assets and visual effects. Video Editor: Enhance videos with professional visual effects and animations. Step into Personalized Learning! Why Us? Discover the Advantages: Tailored One-on-One Training: Experience individualized coaching from skilled architects and designers, either in-person at (SW96DE) or through live online sessions, available Monday to Saturday, 9 am to 7 pm. Customized Tutorials: Take home exclusive video tutorials crafted to elevate your learning experience. Comprehensive Learning Resources: Access a digital reference book for thorough revision, ensuring a deep understanding of every concept. Free Ongoing Support: Enjoy continuous post-course assistance via phone or email, ensuring your success even after class completion. Flexible Syllabus: We tailor the syllabus and projects to your specific needs, ensuring focused learning on what matters most to you. Official Certificate: Certificate upon course completion. Why Us? Individualized Learning Support: Our courses, ranging from 10 to 120 hours, offer unwavering assistance at every stage. With personalized homework assignments and free post-course support, we guide you toward mastering software with unmatched expertise. Personal Attention, No Crowded Classrooms: Bid farewell to overcrowded classrooms. Experience the intimacy of one-on-one learning, ensuring you receive the undivided attention you deserve in a confident and comfortable environment. Financial Flexibility: Embarking on your educational journey shouldn't strain your finances. We offer diverse payment plans tailored to your needs. Explore available options and begin your learning adventure today. Expert Instructors, Real-world Experience: Our instructors, chosen for their industry expertise and passion for teaching, are dedicated to imparting invaluable skills to eager learners.

Description: This Microsoft Office Business Contact Manager 3 will help you to learn everything you need to teach Microsoft Office Business Contact Manager 3. In this course you will learn how to install business contact manager, use express setup and advanced setup, use the business contact manager dashboard, use the business contact manager folder list, menus, and toolbar, create and remove a database, use shared database, manage your database, access the welcome email, use the dashboard links, use 'learn about business contact manager', use the help menu, and more. This course will help you to get skilled and improve your knowledge. Learning Outcomes: Understand and install Business Contact Manager, and use express and advanced setup View folders, use dashboard, menu and toolbar in the Business Contact Manager Create, remove, share and manage database, along with connections to other shared databases Get to know welcome emails, use dashboard links, 'Learn about Business Contact Manager', and help menu Open folders, create, edit and view Accounts, Business Contacts, Opportunities and Business Projects and Project Tasks Discover how to create a history item, business note in and outside an item, view the communication history folder and use link to record and emails to auto-links Learn to open the dashboard, customize it and about the home, sales, marketing and projects tab Setup and use the Product and Service Items List, import and export data, generate reports and utilize the reports window in the information management tools Go through marketing campaigns by creating basic campaigns, campaigns through Word and Publisher, and track campaign results Create custom forms, edit lists in and outside a form 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 Business Contact Manager 3 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 Business Contact Manager 3 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. Configuring Business Contact Manager Getting Started 00:30:00 Using Business Contact Manager 00:15:00 Working with Business Contact Manager Data 00:15:00 Getting Help in Business Contact Manager 00:15:00 Using Business Contact Manager Accounts 00:15:00 Business Contacts 00:15:00 Opportunities 00:15:00 Business Projects and Project Tasks 00:30:00 Communications History and Linking 00:15:00 Business Contact Manager Tools Using the Dashboard 00:15:00 Information Management Tools 00:30:00 Marketing Campaigns 00:15:00 Customizing Forms 00:15:00 Mock Exam Mock Exam- Microsoft Office Business Contact Manager 3 00:20:00 Final Exam Final Exam- Microsoft Office Business Contact Manager 3 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers) This course provides students with an overview of the IBM Cognos Analytics suite of products and their underlying architecture. Students will examine each component as it relates to an Analytics solution & will be shown a range of resources. IBM Cognos Analytics Describe IBM Cognos Analytics Describe IBM Cognos Analytics components Describe IBM Cognos architecture at a high level Describe IBM Cognos security at a high level Consume Content in IBM Cognos Analytics Where do consumers access BI content? Use published reports Drill through to related data Specify run report options Specify properties of an entry Alerts and Watch Items Create Reports in IBM Cognos Analytics Overview of reporting and report authoring Identify package types, uploaded files, and data modules available for reporting Examine IBM Cognos Analytics - Reporting Examine the interface Explore different report types Create a simple, sorted, and formatted report Create a report view Create a subscription Create an Active Report Import and report on personal data Create Dashboards in IBM Cognos Analytics Describe IBM Cognos Dashboarding Identify the IBM Cognos Dashboarding user interface Add report content and tools to create dashboards Widget-to-widget communication Filter data in the dashboard Sort, group and ungroup, and calculate data Create Metadata Models in IBM Cognos Analytics Define IBM Cognos Framework Manager and its purpose Describe the IBM Cognos Framework Manager environment Describe IBM Cognos Cube Designer Get high-level content from Dynamic Cubes course and/or FM course Web-based Modeling Create Data Modules Extend IBM Cognos Analytics Introduction to IBM Cognos Mobile Key features Examine Cognos Mobile architecture Identify supported products Introduction to IBM Cognos BI for Microsoft Office Describe Cognos Analysis for Excel (CAF) Compare IBM Cognos Analytics & IBM Cognos BI New features in IBM Cognos Analytics Changes from IBM Cognos BI to IBM Cognos Analytics Legacy option Examine Event Studio Examine the role of Event Studio in Performance Management List the benefits of Event Studio Examine Metric Studio Identify scorecards, metrics, and metric types Organize metrics with strategies Track initiatives with projects

Master the use of Camtasia 9 for creating and editing video for MAC and PC with the Camtasia 9 Training Course. Camtasia helps you to create and share amazing videos. The course teaches you how to use the video editing software and make professional videos with the software. At first, you will be familiar with the download and installation process of Camtasia. The techniques of importing images and other media, webcam video, and other screen recordings will be shown in the course. One of the problems in the present world is copy issues. Camtasia allows you to include a watermark in your videos and the course will show you how to add the watermark to your original work. Then you will know how to edit videos, add texts, animation, background, music and more. Next, the course illustrates the process of speeding up or slowing down the video, processing videos in various formats, recording computer screen and audio, and the volume concepts. Finally, the course discusses how to choose the best video hosting platforms for you. What you'll learn Download and install Camtasia. Record your computer screen and audio with ideal settings. Import media like images, video camera video, webcam video, audio, or other screen recordings. Put media in order so certain media will appear in front of or behind other media. Use annotations to get viewers' attention and focus them on a certain area of the screen. Remove a colour to add green screen effects to their images or videos. Add a watermark to a video to reinforce a brand and discourage piracy. Be familiar with the software interface, keyboard shortcuts, and best practices. Edit recordings and add elements like text, background music, and animations. Leverage existing assets within Camtasia 9 like animated backgrounds, music, and icons. Speed up or slow down clips to synchronize with voice narration. Understand and adjust volume levels and noise removal. Produce videos in different formats. Choose a video hosting platform that best serves the needs of the viewers. Requirements You should know how to use a computer at a beginner level. Who is the target audience? Entrepreneurs Video Editors YouTube Enthusiasts Anyone who needs to have professional video work done without paying hundreds to do it. Introduction 1. Camtasia Promo 00:01:00 2. Introduction Camtasia 00:01:00 4. Why Use Camtasia 00:01:00 3. Camtasia System Requirements 00:03:00 15. Downloading & Installing Camtasia 00:03:00 The Camtasia Beginner 5. PowerPoint Add-In 00:01:00 8. Camtasia Recorder Walkthrough 00:07:00 Camtasia Recorder in Action 00:01:00 11. Cleaning Your Desktop 00:01:00 12. Tips for Cleaning Your Desktop 00:03:00 10. Recording Seperately 00:03:00 The Camtasia Adept 6. Welcome Screen 00:01:00 7. Camtasia Editor Main Menu Walkthrough 00:06:00 13. Rendering Your Video in Camtasia 00:04:00 Basic Editing Walkthrough 00:08:00 16. Camtasia Media Library 00:02:00 32. Zoom In & Fit Videos to Canvas 00:02:00 33. Scale to Fit Feature 00:01:00 17. Annotations 00:05:00 18. Transitions 00:02:00 19. Behaviors 00:03:00 31. Clip Speed & Slow Motion 00:02:00 34. Zoom & Pan Feature 00:03:00 20. Animations 00:04:00 21. Cursor Effects 00:03:00 22. Voice Narration 00:02:00 23. Audio Effects 00:03:00 25. Shortcuts & Hotkeys 00:09:00 24. Visual Effects 00:04:00 26. Interactive Hotspots 00:04:00 27. Interactivity Quizzes 00:06:00 28. Closed Captions 00:05:00 29. Green Screen Editing 00:07:00 30. Green Screen Background 00:01:00 Course Certification

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 1 in 10 children in the UK experience a mental health issue? If you work with children or young people, you may find yourself supporting those going through difficult times. This course bundle equips you with the knowledge and skills to navigate these situations effectively. Are you ready to make a positive impact on the lives of young people? This comprehensive Child Counselling & DBT bundle delves into the realms of child counselling, Dialectical Behaviour Therapy (DBT), cognitive Behavioural Therapy (CBT), and executive function development in children. You will learn about counselling approaches specifically designed for children and youth, addressing their emotional, behavioural, and developmental needs. Additionally, you'll gain insights into DBT and CBT, evidence-based therapies that can effectively treat a range of mental health conditions, including emotional dysregulation, anxiety, and depression. This Child Counselling & DBT Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Child Counselling Course 02: Diploma in Dialectical Behaviour Therapy (DBT) Course 03: Cognitive Behavioural Therapy Course Course 04: Executive Functions in Child Development Invest in your professional growth and embark on a career path that combines compassion, expertise, and a commitment to promoting positive mental health and well-being for the younger generation. Learning Outcomes of Child Counselling & DBT Develop expertise in child counselling techniques and youth interventions. Understand Dialectical Behaviour Therapy (DBT) and its applications. Learn Cognitive Behavioural Therapy (CBT) principles and practices. Gain insights into executive function development in children. Implement evidence-based therapies for mental health and behavioural challenges. Acquire essential skills for supporting child and adolescent well-being. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Child Counselling & DBT Get a free student ID card with Child Counselling & DBT Training program (£10 postal charge will be applicable for international delivery) The Child Counselling & DBT is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Child Counselling & DBT course materials The Child Counselling & DBT comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Child Counselling Module 01: Introduction To Counselling Module 02: Focusing Module 03: Assessment Module 04: Introduction To Child Psychology Module 05: Problems Of Childhood Module 06: Relationships Between Children And Parents Module 07: Understanding Between Children And Parents Module 08: Impacts Of Separation And Loss On Attachment Module 09: The Impact Of Child Neglect Module 10: Cyberbullying Module 11: Appropriate Questioning Module 12: Silence In Counselling Module 13: The Skill Of Confrontation Module 14: The Skill Of Simile And Metaphor Course 02: Diploma in Dialectical Behaviour Therapy (DBT) Introduction What Is Counselling & Psychotherapy About Dialectical Behaviour Therapy (DBT) DBT Strategies & 'Life Skills' Treatment By DBT DBT For Psychological Disorders Effectiveness Of DBT Course 03: Cognitive Behavioural Therapy Course Module 01: Introduction To CBT Module 02: CBT Theories And Principles Module 03: CBT Tools And Strategies Module 04: CBT Process Module 05: CBT For Personal Growth Module 06: Overcoming Anxiety And Depression Module 07: CBT For Children With Autism Course 04: Executive Functions in Child Development Introduction Part 1 Introduction Part 2 Lecture 1: Definition of Executive Lecture 2: Components of Executive Lecture 3.1: Development Of Executive Lecture 3.2: Affective Factors of Executive Functions Development Lecture 4: Importance of Executive Lecture 5: Assessment of Executive Lecture 6.1: Approaches that Import Lecture 6.2: Long-Term School-based Education Programs =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Teachers Counsellors Youth Workers Social Workers Parents Carers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Child Therapist School Counsellor Educational Psychologist Social Worker Youth Worker Family Support Worker Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of 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 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 2007 Excel 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. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00