709 Courses

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. 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 2010 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 2010 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Lightroom Photo Editing will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Lightroom Photo Editing comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Lightroom Photo Editing. It is available to all students, of all academic backgrounds. Requirements Our Lightroom Photo Editing is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 44 lectures • 06:02:00 total length •Module 01: Introduction: 00:03:00 •Module 02: Editing Overview: 00:02:00 •Module 03: Importing, Catalogue and Sub Folders: 00:05:00 •Module 04: Advanced Organising: 00:04:00 •Module 05: Hidden Gems in Lightroom: 00:03:00 •Module 06: Overview of the Lightroom Panels: 00:04:00 •Module 01: Understand the Histogram: 00:05:00 •Module 02: Local Adjustments: 00:10:00 •Module 03: Basics of Global Adjustments: 00:09:00 •Module 04: Tone Curves: 00:05:00 •Module 05: Hue, Saturation & Luminance: 00:05:00 •Module 06: Split Toning: 00:03:00 •Module 07: Sharpening & Noise Reduction: 00:06:00 •Module 08: Lens Correction: 00:03:00 •Module 09: Transform: 00:02:00 •Module 10: Effects & Calibration: 00:03:00 •Module 01: Landscape Image: 00:17:00 •Module 02: Cityscape Image: 00:18:00 •Module 03: Blue Hour Image: 00:18:00 •Module 04: Small Sensor Image: 00:14:00 •Module 05: Low Light Image: 00:10:00 •Module 06: Milky Way Image: 00:20:00 •Module 07: Reflection Image: 00:15:00 •Module 08: Waterfall Image: 00:15:00 •Module 09: Winter Image: 00:15:00 •Module 10: Sunrise Image: 00:12:00 •Module 11: Travel Portrait Image: 00:12:00 •Module 12: Architecture Image: 00:11:00 •Module 13: HDR Image: 00:13:00 •Module 14: Panoramic Image: 00:15:00 •Module 15: HDR Panoramic Image: 00:05:00 •Module 01: Cloaning & Object Removal: 00:07:00 •Module 02: Presets: 00:05:00 •Module 03: Dodge & Burn: 00:09:00 •Module 04: Orton Effect: 00:05:00 •Module 05: Sun Flare: 00:04:00 •Module 01: Basics of Exporting: 00:09:00 •Module 02: Exporting for Social Media: 00:04:00 •Module 03: Exporting for Printing: 00:04:00 •Module 04: Creating Export Presets: 00:03:00 •Module 01: Focus Stack: 00:07:00 •Module 02: Exposure Blending: 00:05:00 •Module 03: Blending Moments in Time: 00:05:00 •Module 04: Advanced Object removal: 00:13:00

Description: WordPerfect X3 is a word processing application owned by Corel. In this Corel WordPerfect X3 Application Training, there are several modules which will help you learn all the aspects acquire the skills to master WordPerfect. In this course, you will be able to learn the different elements and get accustomed to the WordPerfect interface. You will also learn about the tools necessary to operate during any task from the toolbar to make your work efficient. After finishing this course, you will be to create, customize, edit, and save documents which are essential for your workplace. Learning Outcomes: Understanding the structure of email addresses, advantages of email, email etiquette, spams and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Utilizing the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Best ways to use the contact list, search for messages, create folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Discover more about message tools through flagging, marking messages as read or unread, opening and saving attachments, using reply and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Advanced message tools like adding and removing attachments, changing priority, copying text into a message Compare HTML vs. Plain text emails, set up default text fonts, add images, and check spellings Adding people to your contact list, how to create a distribution list, and changing the addresses from the distribution list 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? Corel WordPerfect X3 Application 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 Corel WordPerfect X3 Application 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. Understanding E-mail All About E-mail 00:15:00 Getting Started 00:30:00 Components of the Mail Interface 00:30:00 Working with Messages 00:30:00 Working With E-mail Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 00:30:00 Printing Messages 00:30:00 Advanced E-mail Topics Creating Messages 00:30:00 Advanced Message Tools 00:30:00 Working With E-mail 00:30:00 Address Tools 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Why Choose Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate? Learn Rhino 3D and V-Ray for Rhino Basic to Intermediate Training Course. Suitable for beginners and experienced users alike, this program equips you with vital modeling and rendering skills. Opt for in-person or live online sessions. Click here for more info: Website Duration: 16 hours. Approach: 1-on-1 Sessions, Customized Content and Flexible Learning. Scheduling Flexibility: Tailor your sessions from Mon to Sat between 9 am and 7 pm. Course Title: Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate - 16 Hours Session 1-2: Introduction to Rhino 3D Basics (2 hours) Understanding Rhino Interface: Navigating toolbars, command line, and properties panel. Basic Geometric Shapes: Creating lines, circles, and polygons with precision. Editing Tools: Mastering move, rotate, scale, and mirror commands. Session 3-4: Advanced Rhino 3D Modeling Techniques (2 hours) Curves and Surfaces: Delving into NURBS curves, creating complex surfaces, and blending techniques. Modeling Aids: Utilizing grids, snaps, and construction planes for accuracy. Organizing with Layers: Managing complex projects efficiently. Session 5-6: Introduction to V-Ray for Rhino (2 hours) V-Ray Interface: Understanding V-Ray toolbar and settings. Basic Lighting: Exploring different light types and their effects on scenes. Materials: Creating realistic materials, understanding diffuse, reflection, and transparency. Session 7-8: Intermediate V-Ray Concepts (2 hours) Advanced Lighting: Mastering HDRI lighting, creating natural outdoor lighting scenarios. Texture Mapping: Understanding UV mapping, applying textures seamlessly. Rendering Optimization: Reducing noise, optimizing settings for quicker, high-quality renders. Session 9-10: Rhino-V-Ray Integration (2 hours) Model Preparation: Optimizing Rhino models for V-Ray rendering. Advanced Material Manipulation: Creating complex materials, incorporating textures. Interactive Rendering: Real-time adjustments for immediate feedback. Session 11-12: Advanced Modeling Techniques in Rhino (2 hours) Advanced Surface Modeling: Creating organic shapes, advanced surfacing techniques. Precision Modeling: Advanced curve editing, filleting, and trimming. Working with 3D Text: Creating custom 3D text for design projects. Session 13-14: Scene Composition and Presentation (2 hours) Camera Settings: Understanding focal length, depth of field, and perspective. Scene Composition: Design principles, rule of thirds, focal points, and balance. Post-Processing: Enhancing renders in Photoshop, adding atmosphere and context. Session 15-16: Final Project and Portfolio Review (2 hours) Final Project Work: Participants apply learned skills to create a complex 3D scene. Instructor-led Critique: Feedback session for final projects. Portfolio Guidance: Tips for selecting the best works for a professional portfolio. By the end of this 16-hour course, participants will have a deep understanding of both Rhino 3D and V-Ray, allowing them to create intricate 3D models and produce high-quality, realistic renders for various applications. Upon completing the Rhino 3D and V-Ray Basic to Intermediate Training Course, participants can expect to achieve the following learning outcomes: Proficiency in Rhino 3D and V-Ray: Develop a comprehensive understanding of Rhino 3D and V-Ray interfaces, tools, and functionalities, enabling participants to navigate and utilize the software effectively. 3D Modeling Skills: Master the art of creating captivating 3D objects and shapes using Rhino 3D, including editing, transforming, and refining designs for diverse applications. Material Application: Acquire the ability to apply and customize materials and textures to enhance the visual appeal and realism of 3D models, elevating the quality of designs. Lighting Techniques: Gain expertise in utilizing V-Ray lighting tools, such as V-Ray lights and HDRI maps, to achieve striking lighting effects in rendered scenes. Rendering Excellence: Learn to optimize V-Ray render settings, control global illumination, and apply dynamic effects like depth of field and motion blur for high-quality and impressive renders. Advanced Modeling: Develop skills in advanced modeling techniques, including handling curves, surfaces, and solids, enabling participants to tackle complex design challenges. Lighting Mastery: Acquire the knowledge and expertise to create and adjust artificial lights, utilize the Sun and Sky system, and craft custom HDR images for realistic lighting setups. Seamless File Management: Understand various file formats for exporting and importing 3D models, facilitating efficient collaboration and preparation for 3D printing. Creative Problem-Solving: Enhance creative thinking and problem-solving abilities through hands-on practice and exploration of diverse design scenarios. Professional Presentation: Learn post-production techniques in Photoshop to enhance renders and create visually appealing design presentations for effective communication. Continuous Learning: Access valuable resources and tips to encourage continuous learning and professional growth in Rhino 3D and V-Ray. Skills You'll Gain: Master Rhino 3D basics: Curves, surfaces, modeling aids, and precision techniques. Explore intermediate V-Ray concepts: Advanced lighting, material manipulation, and texture mapping. Understand Rhino-V-Ray integration for seamless 3D modeling and rendering workflows. Optimize render settings for high-quality output and reduced rendering times. Career Opportunities: Upon completing this program, you'll be prepared for various roles in the design and visualization industry, such as: 3D Modeler: Create detailed 3D models for diverse industries, including architecture and product design. Architectural Visualizer: Produce realistic architectural visualizations for presentations and marketing materials. Product Designer: Develop visually appealing product prototypes and visualizations for marketing and manufacturing. Visualization Specialist: Work in design studios, advertising agencies, or game development companies, creating immersive visual content. Freelance Designer: Offer your skills on platforms like Upwork or Fiverr, providing 3D modeling and rendering services to clients worldwide. Solidify Rhino 3D Expertise: Master foundational modeling skills, including intricate geometries and surface manipulation, establishing a robust foundation for your 3D design journey. Unlock V-Ray for Rhino: Explore the potential of V-Ray for Rhino, learning to create mesmerizing visualizations and achieve lifelike rendering results that bring vitality to your designs. Enhance Visual Appeal: Grasp advanced lighting techniques, material application, and texture methods to elevate the visual allure of your 3D creations, making them more immersive and authentic. Explore Advanced Concepts: Delve into optimizing rendering settings, post-production tactics, and efficient workflows, advancing your design proficiency to higher levels. Hands-On Experience: Engage in practical exercises and real-world projects, applying your skills in practical contexts to enrich your portfolio and showcase your capabilities effectively. Certification of Achievement: Receive a valuable Certificate of Completion, confirming your expertise in Rhino 3D and V-Ray for Rhino, enhancing your professional credibility as a skilled designer. Flexible Learning Paths: In-Person or Live Online: Opt for in-person sessions, fostering collaborative learning, or choose live online classes for convenience and accessibility, tailoring your learning experience to your preferences. Personalized Guidance: Regardless of your chosen format, benefit from tailored instruction and guidance, ensuring optimal learning outcomes and continuous support throughout the course.

It has been found that visual communication is vastly more effective than other forms of communication. It is a very stimulating form of communication especially when paired with vivid colours. Graphic designers have a similar job, where they convey many different subtle messages using their creativity and artistic talents. This Diploma in Graphic Design course will help you learn basic techniques in Adobe photoshop, Illustration and In-design in order to build up your confidence and help you start the journey to become a professional. This course will initially give you a background understanding in what graphic design really is, following which you will learn about the principles and elements of design -which are considered the building blocks of graphic designing. You will also discover the different terms, tips and tolls used to pick the best colours. After this is where the whole course starts getting interesting as you start learning to use Photoshop, understand Typography, design logos using illustrator and finally discover more about web designing and printing. This diploma level course is the full package and is ideal for anyone pursuing a career in graphics design. Course Highlights Diploma in Graphic Design is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Diploma in Graphic Design into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Diploma in Graphic Design Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Diploma in Graphic Design is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Diploma in Graphic Design 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. LESSON 01 Basics of Graphic Design 00:56:00 LESSON 02 Foundation in Design 01:00:00 LESSON 03 Adobe Photoshop Basics 01:02:00 LESSON 04 Designers go to Software 01:03:00 LESSON 05 Adobe Illustrator Introduction and Typography 01:01:00 LESSON 06 Creating Logos with Illustrator 01:01:00 LESSON 07 Web Page Design Basics 00:51:00 LESSON 08 Adobe in Design and Print Work Introduction 01:02:00 Final Exam Final Exam - Diploma in Graphic Design 00:20:00

As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an advantage. This Microsoft Excel 2010 Essentials course is created to help you in learning the basics and importance of this program. In this course, you will learn the necessary skills, knowledge and information about how to plan and organise your data using the tools in this program. Learn the basics and common functions of Microsoft Excel that will help you finish your tasks faster. You will learn writing the right formula and functions that can save you time and become more productive in your work. Course Highlights Accredited Microsoft Excel 2010 for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Excel 2010 for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 10 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Excel 2010 for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Excel 2010 for Beginners is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Microsoft Excel 2010 for Beginners 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Accredited Microsoft Excel 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Excel 2010 for Beginners 00:20:00 Final Exam Final Exam- Accredited Microsoft Excel 2010 for Beginners 00:20:00

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Learn the main topics related to Microsoft excel 2007. Identify the basic excel techniques, explore the advanced functions of excel 2007 and create automated reports with the press of a button in this course. By completing this course, you will become an excel expert and use excel 2007 as a professional. Who is the course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The diploma in Microsoft Excel 2007 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Final Exam Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Are you looking to enhance your Microsoft Office Course skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office Course will assist you in producing the best possible outcome by mastering the Microsoft Office Course skills. The Microsoft Office Course is for those who want to be successful. In the Microsoft Office Course, you will learn the essential knowledge needed to become well versed in Microsoft Office Course. Our Microsoft Office Course starts with the basics of Microsoft Office Course and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office Course is intuitive and easy to understand. Why would you choose the Microsoft Office Course from Compliance Central: Lifetime access to Microsoft Office Course materials Full tutor support is available from Monday to Friday with the Microsoft Office Course Learn Microsoft Office Course skills at your own pace from the comfort of your home Gain a complete understanding of Microsoft Office Course Accessible, informative Microsoft Office Course learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Microsoft Office Course bundle Study Microsoft Office Course in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Microsoft Office Course Improve your chance of gaining in demand skills and better earning potential by completing the Microsoft Office Course Microsoft Office Course Curriculum Breakdown of the Microsoft Office Course Section 01: Getting Started Section 02: Excel 2021: Basics Section 03: Excel 2021: Rows, Columns, and Cells Section 04: Excel 2021: Data Handling Section 05: Excel 2021: Page Setting Up and Print Section 06: Excel 2021: Sorting and Filtering Section 07: Excel 2021: Writing Formulas Section 08: Excel 2021: Advanced Formulas Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 Section 10: Excel 2021: Data and Tools Section 11: Excel 2021: Formatting data and tables Section 12: Excel 2021: Pivot Tables Section 13: Excel 2021: Charts Section 14: PowerPoint 2021: Course Introduction Section 15: PowerPoint 2021: Basics Section 16: PowerPoint 2021: Text and Bullet Options Section 17: PowerPoint 2021: Adding Graphic Assets Section 18: PowerPoint 2021: Picture Formatting Section 19: PowerPoint 2021: SmartArt Graphics Section 20: PowerPoint 2021: Working with Tables Section 21: PowerPoint 2021: Working with Charts Section 22: PowerPoint 2021: Adding Multimedia Section 23: PowerPoint 2021: Working with Transition Section 24: PowerPoint 2021: Animation Section 25: PowerPoint 2021: Slideshow Effects Section 26: Word 2021: Introduction Section 27: Word 2021: Basics Section 28: Word 2021: Word Formatting Section 29: Word 2021: Tables Section 30: Word 2021: Styles Section 31: Word 2021: Page Layout Section 32: Word 2021: Envelops and Lables Section 33: Word 2021: Mail Merges Section 34: Word 2021: Review and Printing CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office Course. It is also great for professionals who are already working in Microsoft Office Course and want to get promoted at work. Requirements To enrol in this Microsoft Office Course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office Course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Course. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course. Module 1: Getting Started with Access What is a Database 00:03:00 Database Terminology 00:05:00 The Access Interface 00:08:00 What is a Flat File Database 00:03:00 What is a Relational Database 00:10:00 Relating Tables 00:10:00 Reviewing The Access Ribbon 00:02:00 Module 2: Working with Data Working with Tables 00:07:00 Navigating Tables 00:04:00 Editing Data 00:03:00 Adding New Records 00:05:00 Using Subdatasheets 00:04:00 Module 3: Creating Databases and Objects Understanding Database and Table Design Principles 00:08:00 Using Table Data Sheet View 00:03:00 Working with Field Data Types 00:07:00 Using Table Design View 00:04:00 Calculating Numbers 00:05:00 Calculating Dates 00:02:00 Calculating Strings 00:03:00 Using The Lookup Wizard 00:12:00 Lookup Wizard Linking Tables 00:09:00 Using Indexes 00:04:00 Module 4: Working with Queries What are Queries? 00:08:00 Creating Simple Queries 00:05:00 Entering Criteria-Exact Match and Range Operators 00:05:00 Understanding And Versus Or 00:06:00 Using Wildcards 00:05:00 Using Key Words 00:04:00 Sorting and Hiding Fields 00:03:00 Creating Multi-Table Queries 00:03:00 Additional Tips C4 00:06:00 Module 5: Working with Reports What are Reports 00:05:00 Understanding Report Types 00:03:00 Building Good Reports 00:02:00 Using AutoReport 00:08:00 Understanding The Report Wizard 00:11:00 Using the Report Design View 00:08:00 Printing Reports 00:04:00 Creating labels 00:08:00 Additional Tips C5 00:10:00 Module 6: Working with Forms What are Forms 00:04:00 Understanding Form Types 00:03:00 Creating Forms 00:03:00 Navigating Forms 00:03:00 Editing Data in Forms 00:05:00 Understanding the Form Wizard 00:05:00 Using Form Design View 00:04:00 Working with Controls 00:10:00 Using Form Layout View 00:04:00 Additional Tips C6 00:07:00 Resource Resource - Access 365 Beginner 00:00:00 Final Exam Final Exam - Access 365 Beginner 00:20:00