161 Painter courses

Your guide to practice and learn to excel in Word 2019.

If you have a creative flair and passion for interior painting and designing, then enrol in this Painting and Decorating course today and fast-track your career. Painting and decorating skills are very essential skills to have, especially for the construction and decorating industry. Knowing how to paint furniture, walls, and other surfaces make a big difference visually to the interior of a home. If your home is undergoing a makeover or you wish to become a professional painter and decorator, then this Painting and Decorating course will provide you with the knowledge and basic skills you need to kickstart your career. In this Painting and Decorating Bundle, you will learn the basics of preparing surfaces for decoration and how to apply paint systems by brush and roller. You will also develop the skills required to care for different types of furniture. How to arrange and analyse a room will also be covered in this Painting and Decorating course. Lastly, you will learn how to market your business through portfolios, flyers, and cards, to attract potential clients for painting and decoration jobs. Along with this Painting and Decorating course, you will get 10 Career development courses, an original hardcopy certificate, a transcript and a student ID card. This Painting and Decorating Level 4 Bundle Consists of the following Premium courses: Course 01: Painting and Decorating Course 02: Advanced Diploma in Architectural & Interior Design Course 03: Carpentry: Furniture Restoration and Refurbishment Course 04: Home Decoration and Refurbishment Course Course 05: Mastering Colour-Architectural Design & Interior Decoration Course 06: Visual Merchandising Course 07: Level 2 Adobe Graphics Design Course Course 08: Drawing and Illustration Level 2 Course 09: Rendering AutoCAD Drawings in Photoshop Course 10: DIY Home Improvement Course 11: Workplace Safety Course Key features of this Painting and Decorating course: This Painting and Decorating bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Painting and Decorating is entirely online 24/7 Learner support The Painting and Decorating bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Painting and Decorating expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Painting and Decorating from any place in your own time without travelling for classes. The Painting and Decorating bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Painting and Decorating expertise and essential knowledge, which will assist you in reaching your goal. How will I get my Painting and Decorating Certificate? After successfully completing the Painting and Decorating course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Painting and Decorating bundle. Requirements This Painting and Decorating course has been designed to be fully compatible with tablets and smartphones. Career path Having this Painting and Decorating expertise will increase the value of your CV and open you up to multiple job sectors. Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Painting and Decorating) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 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 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Description: Painting is a medium of expression since a lot of artists use it to express their feelings or other significant events in their life. If you would like to express yourself and bring out your hidden artistic and creativity skills, consider getting this Diploma in Art and Painting. This Diploma in Art and Painting is designed for developing you basic knowledge and skills in art and painting. The course is divided into five modules and will help you focus on several different topics. You will get knowledge in canvas painting like understanding paints and how to choose brushes to use for your art. You will also be able to become a professional painter by learning to incorporate your painting skills and use this to offer your services as a business to those who need it. Lastly you will also learn about pencil art and the basics of drawing and sketching. There is a lot more covered within the course and if you are truly dedicated in succeeding as an artist you should consider getting this course now. Who is the course for? Artists or painters who want home paintings as a business. People who have an interest in professional painting Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally 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: Diploma in Art and Painting is a useful qualification to possess, and would be beneficial for the following careers: Visual Artists Portrait Specialist Sketch Artists Logo Designers Updated Version-Diploma in Art and Painting Introduction Introduction to Drawing and Painting 00:03:00 Materials 00:08:00 Perspective What is a Horizone Line 00:11:00 One Point Perspective of a Cube 00:10:00 Two Point Perspective of a Cube 00:12:00 Perspective of a Cylinder 00:17:00 How to draw a Perfect Sphere 00:09:00 Shading Shading a Sphere 00:22:00 Shading a Cylinder 00:18:00 Shading a Cube 00:13:00 Measuring How to Measure 00:07:00 Still Life Drawing Compostion and placement 00:09:00 Finding the perspective and drawing the box 00:18:00 Constructing the Cup 00:22:00 Drawing the Drapes 00:05:00 Shading - Part 1 00:14:00 Shading - Part 2 00:19:00 Shading - Part 3 00:22:00 Drawing a Portrait Drawing a Face - Part 1. Construction 00:21:00 Drawing a Face - Part 2. Refining the features 00:10:00 Drawing a Face - Part 3. Shading 00:18:00 Drawing a Face - Part 4. Final touches 00:12:00 Drawing a Tree Drawing a Tree 00:16:00 Order Your Certificate Order Your Certificates and Transcripts 00:00:00 Old Version-Diploma in Art and Painting Module-1 Painting 101 00:30:00 Understanding Paints 00:30:00 Choosing Your Brushes 00:30:00 Color Your World 00:30:00 Light Sources in Painting 00:30:00 What type of painter are you? 00:30:00 Module-2 Choosing A Subject 01:00:00 Setting Up Your Studio 00:30:00 Art Supply Resources 01:00:00 Clean Up Time 00:30:00 Free Art Lessons 01:00:00 Take Care of Your Creation 00:15:00 Module-3 Pay Attention to Detail 01:00:00 Enjoy Your Subject 01:00:00 Frequently Asked Questions 00:30:00 Art Schools 00:30:00 Museums of Fine Art 00:15:00 One Final Word 01:00:00 Module-4 INTRODUCTION 01:00:00 BRIEF HISTORY OF PENCIL DRAWING 00:15:00 GETTING STARTED 01:00:00 LEARNING THE BASICS OF DRAWING AND SKETCHING 01:00:00 Basic Perspectives on Drawing 01:00:00 Basic Elements of Light, Shadows, and Shading 01:00:00 Different Shading Techniques 00:15:00 How to Add Tones and Values? 00:30:00 FINISHING TOUCHES 00:30:00 MIXED MEDIA APPLICATIONS 01:00:00 Drawing with Pencils in Oil Painting 01:00:00 CONCLUSION 00:15:00 Module-5 Start Your Own Art Business 00:15:00 Steps to Creating a Successful Business from Your Art 01:00:00 How to Write an Artist Business Plan 00:30:00 Module-6 Introduction 00:30:00 Incorporate Your Business 01:00:00 Employing Or Contracting - What Is The Difference? 00:30:00 From Where Can You Hire Workers 01:00:00 Getting Insurance 01:00:00 Getting Ready - Portfolios, Flyers And Cards 00:30:00 What Do You Need For Outdoor Painting 01:00:00 What Do You Need To Know About Indoor Painting 01:00:00 Fancy Indoor Painting Touches - How To Get Them 00:30:00 Paint Primer 101 01:00:00 How To Get Customers 01:00:00 The Non-Paying Customers! 00:30:00 Mock Exam Mock Exam- Diploma in Art and Painting 00:20:00 Final Exam Final Exam- Diploma in Art and Painting 00:20:00

Become a MET technician and repair vehicles of all kinds. Learn how to identify and fix damage to mechanical, electrical, and trim components.

Face Painting Course Overview Face painting is a fun activity, perfect for festivals, children's birthday parties and other fun occasions. Parents will also love getting creative with different types of face paints. If you want to learn the basics of face painting, this Face Painting Course will guide you step-by-step on how to create amazing face paint designs, including an introduction into the history of face painting. This online course consists of various user-friendly modules that are all geared towards helping you learn about face and body painting for kids. The course is divided into three sections: beginner, intermediate, and advanced face painting ideas. You'll learn expert face painting techniques, helping you to gain confidence in your artistic abilities, whether you want to become a professional face painter, or have some fun with your little ones at special celebrations. You will also learn how to take care of your skin and will familiarise with health and safety codes of practice. Whatever your academic background, this introductory face painting training course will help you to learn face painting on a basic level, building you up to eventually creating real masterpieces any child would be proud to show off! Course Preview Who is the Face Painting Course for? People interested in drawing face paintings as a part of an amusing hobby. Art professional who need this skill at the workplace. 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. 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.AssessmentAssessment test is not required in this course Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path The course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Theme parks. Kindergarten and nursery schools. Sports and recreational events. Theatres and Live events. Face Painting Course Module 01: Introduction to Face Painting 00:16:00 Module 02: Face Painting Tools and Techniques 00:15:00 Module 03: Face Painting for Different Occasions 00:13:00 Module 04: Creative Face Painting Designs 00:12:00 Module 05: Advanced Face Painting Techniques 00:13:00 Module 06: Business and Professional Development 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

4 in 1 Painting and Decorating Bundle Did you know that the average salary for a painter and decorator in the UK is over £26,000, and for interior designers it's even higher, over £35,000? Not only is this a creatively rewarding profession, but it also has great income potential. Our Painting and Decorating Diploma - QLS Endorsed bundle will guide you from the basics of art, drawing, and painting, through to modern techniques in acrylic and watercolour. But we don't stop there. You'll dive into the world of digital painting, learning advanced techniques to bring your art into the 21st century. And we round it off with a complete course on interior design, covering all aspects from style, design, and colour to space, staging, fabrics, and curtain. This truly is a complete package. This Painting and Decorating Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Art, Drawing and Painting Diploma Course 02: Modern Acrylic Painting Course Course 03: Modern Watercolor Paintings Course 04: Advanced Digital Painting Course So, don't miss this opportunity of getting everything in one bundle. Enrol in our Painting and Decorating bundle course and start your journey from today! Learning Outcomes of Painting and Decorating Bundle Understand principles of art, drawing, and painting. Explore modern acrylic painting techniques. Discover nuances of modern watercolour paintings. Delve into advanced digital painting concepts. Learn basic principles of landscape paintings. Understand interior design aspects: style, colour, space, etc. Gain knowledge about staging, fabrics and curtain selection. Why Choose Our Painting and Decorating Bundle? Get a Free CPD Accredited Certificate upon completion of the course Get a free student ID card with this training program The course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the course materials The training program comes with 24/7 tutor support Start your learning journey straightaway with our Painting and Decorating Training! Our Painting and Decorating Diploma bundle is a comprehensive platform for burgeoning artists and designers. Beginning with foundational courses in art, drawing, and painting, students will explore classical techniques before transitioning into modern acrylic and watercolour methods. The bundle also delves into digital painting, a booming field in today's increasingly digital world. You'll be exposed to advanced digital painting techniques, expanding your repertoire and adapting your skills for the digital age. Completing the curriculum is our course on interior design, where students learn to manipulate space, colour, fabrics, and staging to transform any room. CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Painting and Decorating bundle is ideal for: Aspiring Artists Beginner to Intermediate Interior Designers Art Students Individuals interested in theoretical understanding of painting and decorating Requirements You will not need any prior background or expertise to enrol in this Painting and Decorating bundle! Career path This Painting and Decorating bundle will allow you to kickstart or take your career to the next stage in the related sector such as: Artist Interior Designer Art Teacher (Secondary Education) Gallery Curator Art Therapist Digital Illustrator Certificates CPD QS Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Course Overview Watercolor is one of the most beautiful mediums of painting. The Paint Birds with Watercolor course is here to show you how you can use this painting method for creating mesmerizing bird paintings. In this Paint Birds with Watercolor course, you will get introduced to the materials and tools for watercolor painting. Then the course will show you the techniques of painting light and dark areas. You will grasp the skills and techniques to paint a bird sitting on a tree branch. Step by step, the instructor will show you the process of painting a hummingbird in detail. You will also learn how to paint an eagle and northern cardinal. This Paint Birds with Watercolor course will provide you with tips and tricks to elevate your watercolor skills. Enroll in this fantastic course and reveal the secrets of creating outstanding bird paintings with watercolor. Learning Outcomes Familiarize with the materials you will need for painting birds in watercolor Learn the process of painting a bird sitting on a brunch Understand the steps of painting an eagle Acquire the skills to paint a hummingbird and northern cardinal Who is this course for? This Paint Birds with Watercolor course is for those interested in learning the skills to paint birds with watercolor.  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 The  Paint Birds with Watercolor course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Painter Paint Birds with Watercolor Module 01: Introduction 00:01:00 Module 02: Bird on a Branch: Part 1 00:26:00 Module 03: Bird on a Branch: Part 2 00:46:00 Module 04: Paint an Eagle 00:23:00 Module 05: Paint a Northern Cardinal 00:22:00 Module 06 Hummingbird: Part 1 00:23:00 Module 07: Hummingbird: Part 2 00:22:00 Module 08: Class Project 00:01:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Inspiration and a passion for creativity are great starting points, but to be a truly brilliant artist, you need to have a solid understanding of the practical skills necessary to turn your vision into a reality. Divided into six fantastic modules, this Diploma in Art and Painting course utilises our innovative online learning platform to teach you everything you need to know, from choosing your brushes, materials and studio set up to the basic elements of light, shadow and shading, mixed media applications and perspective. This course also includes modules on marketing your work, allowing you to put together an effective portfolio and create flyers and business cards to grab people's attention and market yourself as an expert painter or artist. Why choose this course Earn a digital 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 Online study materials Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £109. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Diploma in Art and Painting is suitable for anyone who wants to gain extensive knowledge, potential experience and expert skills in the related field. This is a great opportunity for all students from any academic backgrounds to learn more on this subject. Course Content Module-1 Painting 101 00:30:00 Understanding Paints 00:30:00 Choosing Your Brushes 00:30:00 Color Your World 00:30:00 Light Sources in Painting 00:30:00 What type of painter are you? 00:30:00 Module-2 Choosing A Subject 01:00:00 Setting Up Your Studio 00:30:00 Art Supply Resources 01:00:00 Clean Up Time 00:30:00 Free Art Lessons 00:30:00 Take Care of Your Creation 00:15:00 Module-3 Pay Attention to Detail 01:00:00 Enjoy Your Subject 01:00:00 Frequently Asked Questions 00:30:00 Art Schools 00:30:00 Museums of Fine Art 00:15:00 One Final Word 01:00:00 Module-4 INTRODUCTION 01:00:00 BRIEF HISTORY OF PENCIL DRAWING 00:15:00 GETTING STARTED 01:00:00 LEARNING THE BASICS OF DRAWING AND SKETCHING 01:00:00 Basic Perspectives on Drawing 01:00:00 Basic Elements of Light, Shadows, and Shading 01:00:00 Different Shading Techniques 00:15:00 How to Add Tones and Values? 00:30:00 FINISHING TOUCHES 00:30:00 MIXED MEDIA APPLICATIONS 01:00:00 Drawing with Pencils in Oil Painting 01:00:00 CONCLUSION 00:15:00 Module-5 Start Your Own Art Business 00:15:00 Steps to Creating a Successful Business from Your Art 01:00:00 How to Write an Artist Business Plan 00:30:00 Module-6 Introduction 00:30:00 Incorporate Your Business 01:00:00 Employing Or Contracting - What Is The Difference? 00:30:00 From Where Can You Hire Workers 01:00:00 Getting Insurance 00:30:00 Getting Ready - Portfolios, Flyers And Cards 00:30:00 What Do You Need For Outdoor Painting 01:00:00 What Do You Need To Know About Indoor Painting 01:00:00 Fancy Indoor Painting Touches - How To Get Them 00:30:00 Paint Primer 101 01:00:00 How To Get Customers 01:00:00 The Non-Paying Customers! 00:30:00 Mock Exam Mock Exam- Diploma in Art and Painting 00:20:00 Final Exam Final Exam- Diploma in Art and Painting 00:20:00 Recommended Materials Workbook - Diploma in Art and Painting 1 week, 2 days Assignment Assignment - Diploma in Art and Painting 6 days, 4 hours Order Your Certificate Order your Certificate QLS 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.

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