167 Print courses in Ewell

Why Opt for SketchUp Course With Layout and V-Ray? Learn SketchUp with Layout and V-Ray for professional 3D modeling, detailed modeling, and high-quality rendering. Essential for architects and designers for creating visualizations and precise presentations. Check our Website When can I Enrol? 1-on-1 training. Mon to Sat 9 am and 7 pm Book over the Phone 02077202581. Training Duration: 10 hours. You have the flexibility to split these hours over multiple days. Training Method: In-person or live online. Course Outline: SketchUp, Layout, and V-Ray - 10-Hour Training Module 1: Introduction to SketchUp (1 Hour) SketchUp Interface: Explore the basics of the SketchUp user interface. Navigation and View Tools: Learn how to navigate and manipulate 3D space. Module 2: SketchUp Fundamentals (1 Hour) Drawing and Modeling: Begin creating 3D objects and structures. Editing Tools: Manipulate and modify objects efficiently. Module 3: Advanced SketchUp Techniques (1 Hour) Components and Groups: Understand component and group organization. Layers and Scenes: Organize your model and create dynamic views. Module 4: SketchUp for Architectural Design (1 Hour) Architectural Modeling: Explore architectural modeling techniques. Interior Design: Apply SketchUp to interior space design. Module 5: Landscape Design with SketchUp (1 Hour) Landscape Modeling: Use SketchUp for outdoor environment design. Terrain and Topography: Model terrain and natural landscapes. Module 6: Introduction to Layout (1 Hour) Layout Basics: Get familiar with the Layout interface. Setting Up Viewports: Begin using viewports for presenting your SketchUp models. Module 7: Creating Layout Documents (2 Hours) Document Setup: Set up and customize your layout documents. Inserting SketchUp Models: Import SketchUp models into Layout viewports. Dimensioning and Labeling: Add dimensions and labels to your layout documents. Module 8: Presentation and Export (1 Hour) Styling and Rendering: Enhance your SketchUp models for presentations. Exporting and Printing: Learn how to export and print your Layout documents. Module 9: Introduction to V-Ray (1 Hour) V-Ray Interface: Get acquainted with the V-Ray user interface. Materials and Lighting: Learn the basics of materials and lighting in V-Ray. Module 10: Advanced V-Ray Rendering (1 Hour) Advanced Materials: Explore advanced material creation and customization. Realistic Lighting: Master V-Ray lighting techniques for photorealistic renders. By the end of this 10-hour course, you'll have a comprehensive understanding of SketchUp for 3D modeling, Layout for professional documentation, and V-Ray for rendering, empowering you to create stunning 3D designs and presentations. Upon completing this course, you will: Master SketchUp: Create 3D models with precision and creativity. Layout Proficiency: Produce professional design documentation. V-Ray Rendering Skills: Craft photorealistic visualizations. Advanced Techniques: Explore advanced modeling and rendering. Project Experience: Apply skills to real-world projects. Job Opportunities: Architectural Designer Interior Designer Landscape Designer CAD Technician 3D Modeler Rendering Specialist Visualization Artist Layout Specialist Freelance Designer Urban Planner Learning Objectives: Mastering SketchUp with Layout: Learn to create precise 2D floor plans, elevations, and construction documents using SketchUp's Layout tool. Advanced Rendering with V-Ray: Dive into V-Ray to create photorealistic renders, enhancing your visualizations with lighting, textures, and realistic materials. Collaborative Design: Develop skills for collaborative project planning and presentation, enabling effective communication with clients and teams. Job Opportunities: Architectural Visualization Specialist: Create detailed architectural visualizations and presentations for clients and marketing purposes. Interior Designer: Design interior spaces, produce detailed layouts, and create realistic renders for residential and commercial projects. 3D Visualization Artist: Work in the gaming or animation industry, creating 3D models and environments. Freelance Rendering Expert: Offer specialized rendering services to architectural firms, interior designers, or real estate developers. Layout Designer: Specialize in creating professional 2D layouts and construction documents for architectural projects. Why Choose Us? Tailored One-on-One Training: Personalized coaching from industry experts, in-person or online, Monday to Saturday. Customized Tutorials: Enhance skills with exclusive video tutorials designed for your learning journey. Comprehensive Resources: Access a digital reference book for thorough concept revision. Free Ongoing Support: Enjoy continuous assistance via phone or email even after the course ends. Flexible Syllabus: Adapted to your needs for focused and efficient learning. Official Certification: Ccertificate upon course completion. Why Us? Supported Individual Learning: Unwavering support with personalized homework and post-course assistance. Personalized Attention: Experience one-on-one learning, fostering a confident and comfortable environment. Financial Flexibility: Choose from various payment plans tailored to your budget. Expert Instructors: Learn from industry experts dedicated to your success.

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

COBOL training course description A hands on training course providing an introduction to COBOL. What will you learn Write COBOL programs Debug COBOL programs Examine existing code and determine its function. COBOL training course details Who will benefit: Programmers working with COBOL. Prerequisites: None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming. Duration 5 days COBOL training course contents Introduction to COBOL Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure. COBOL statement structure COBOL words, format of statements. Divisions Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry. File and Working-Storage Sections Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause. Procedure Division File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification. Perform statement Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement. Program design Design techniques, design considerations, procedure names, program structure. Printing Printed output, Write, advancing option, editing characters; Initialize. Condition testing Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue. Arithmetic Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute. Non-sequential files File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start. Declarative routines Clauses. Subroutines Call, Using clause - calling program/called program, Linkage Section, returning control. Table handling Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing. Data Manipulation Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.

Who is this course for? The 3D Printing Bespoke 1-on-1 Training Course is designed for individuals seeking personalized instruction and hands-on experience in the field of 3D printing. Click here for more info: Website Training: 40 hrs, split as per your availability. When: 9 a.m. to 7 p.m., Mon-Sat. Call 02077202581 to reserve. Live online, or in-person. Option A: AutoCAD 10 hrs, Rhino 16 hrs, Vray 4 hrs, Photoshop 4 hrs, 3D Printing 6 hrs Option B: AutoCAD 12 hrs, 3ds Max 16 hrs, Vray 4 hrs, Photoshop 4 hrs, 3D Printing 4 hrs.  Option A: AutoCAD, Rhino, Vray, Photoshop, 3D Printing (Total: 40 hours) AutoCAD (10 hours): Module 1: Introduction to AutoCAD (2 hours) Familiarization with AutoCAD interface and tools Creating, opening, and saving drawings Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) Lines, circles, and arcs Polylines and polygons Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) Using coordinate systems Dimensioning and text Hatching and gradients Module 4: Advanced Tools (2 hours) Blocks and attributes Layers and object properties Creating layouts and plotting Rhino (16 hours): Module 1: Introduction to Rhino (2 hours) Navigating the Rhino interface Basic 2D and 3D modeling concepts Creating and manipulating objects Module 2: Advanced Modeling (6 hours) Modeling with curves and surfaces Editing and transforming geometry Building complex 3D structures Module 3: Visualization with Vray (4 hours) Understanding the Vray rendering engine Applying materials and textures Setting up lighting and cameras for realistic rendering Module 4: Presentation and Editing (2 hours) Exporting and sharing Rhino models Post-processing and enhancing designs Photoshop (4 hours): Module 1: Introduction to Photoshop (2 hours) Navigating Photoshop interface Image resolution and size Basic image editing tools Module 2: Image Editing and Enhancement (2 hours) Adjusting colors and tones Using layers and masks Retouching and image manipulation 3D Printing (6 hours): Module 1: Introduction to 3D Printing (2 hours) Basics of 3D printing technology Understanding file formats and requirements Module 2: Preparing 3D Models (2 hours) Model optimization for 3D printing Creating supports and rafts Ensuring successful prints Option B: AutoCAD, 3ds Max, Vray, Photoshop, 3D Printing (Total: 38 hours) AutoCAD (12 hours): Module 1: Introduction to AutoCAD (2 hours) Overview of AutoCAD interface and tools Creating, opening, and saving drawings Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) Lines, circles, and arcs Polylines and polygons Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) Using coordinate systems Dimensioning and text Hatching and gradients Module 4: Advanced Tools (4 hours) Blocks and attributes Layers and object properties Creating layouts and plotting 3ds Max (16 hours): Module 1: Introduction to 3ds Max (2 hours) Exploring the 3ds Max interface Navigating viewports and objects Basic modeling techniques Module 2: 3D Modeling (6 hours) Creating and editing 3D objects Modifiers and deformations Working with shapes and splines Module 3: Visualization with Vray (4 hours) Setting up lights and cameras Rendering settings and options Post-production and compositing Photoshop (4 hours): Module 1: Introduction to Photoshop (2 hours) Navigating Photoshop interface Image resolution and size Basic image editing tools Module 2: Image Editing and Enhancement (2 hours) Adjusting colors and tones Using layers and masks Retouching and image manipulation 3D Printing (4 hours): Module 1: Introduction to 3D Printing (2 hours) Basics of 3D printing technology Understanding file formats and requirements Module 2: Preparing 3D Models (2 hours) Model optimization for 3D printing Creating supports and rafts Ensuring successful prints Training Duration: 40 hours Flexible Timings: Students can choose their preferred time slots based on our availability, operating from 9:00 am to 7:00 pm (Monday to Saturday). Pricing Details: Company Rate: £1200 (Plus 20% VAT) = £1440 inc VAT. Student, Self-Financed, and Live Online Rate: £1000 (Plus 20% VAT) = £1200 inc VAT. Who Should Enroll: This course caters to a wide range of individuals, including: Novices: Perfect for beginners unfamiliar with AutoCAD, 3ds Max, Adobe Photoshop, Rhino, Vray, and 3D printing, providing a solid foundational understanding. Architects and Interior Designers: Tailored insights for professionals seeking precision in enhancing their design skills, valuable for design firms. Industry Professionals: Establishes industry benchmarks, offering adaptable education applicable across sectors like interior design, architecture, and civil engineering. Learning Approach: Hands-On Practicality: Emphasizes practical, real-world skills through personalized one-on-one training, available in face-to-face or live online sessions. Step-by-Step Instruction: Experienced instructors guide you systematically through techniques using AutoDesk AutoCAD, Autodesk 3ds Max, Adobe Photoshop, and Trimble Sketchup. What You'll Receive: Certificate of Achievement: Upon completion, receive a certificate validating your expertise. Comprehensive Training Guide: Access an extensive PDF guide compatible with both Windows and MAC. Live Feedback: Connect with your tutor for real-time feedback during sessions and the option to record each session for future reference. Our Benefits: Price Assurance: Guaranteeing exceptional value for your career investment. Personalized Training: Tailored one-on-one sessions, adjusting to your learning pace and style. Flexible Scheduling: Choose your preferred training time and day, available Monday to Sunday, from 9 am to 8 pm. Lifetime Support: Ongoing email and phone support beyond the course completion. Computer Setup Assistance: We assist in configuring your computer for seamless software installation. Referral Benefits: Recommend a friend and enjoy discounts, including significant savings on group training courses. Advantages of Option A: Diverse Skill Enhancement: Acquire proficiency in AutoCAD, Rhino, Vray, Photoshop, and 3D Printing, expanding your skill repertoire. Career Opportunities: Access a wide range of career paths in design, architecture, and 3D printing fields, enhancing your professional prospects. Compelling Visualizations: Craft realistic and visually appealing 3D renderings using Vray, elevating the quality of your design presentations. Image Editing Expertise: Master the art of enhancing design projects with Photoshop, adding finesse to your creative work. Prototyping Prowess: Develop essential skills in 3D Printing, enabling you to create physical design prototypes for various applications. Advantages of Option B: Versatile Skill Mastery: Excel in AutoCAD, 3ds Max, Vray, Photoshop, and 3D Printing, gaining expertise in diverse areas of design and visualization. Career Advancement: Unlock opportunities in architecture, animation, and visualization fields, broadening your career horizons. High-Quality Renderings: Showcase your designs impressively with high-quality renderings generated through Vray, leaving a lasting impact on viewers. Image Editing Mastery: Polish your design concepts and presentations using advanced Photoshop techniques, ensuring your visuals are refined and professional. 3D Printing Expertise: Bring your digital designs to life across various industries, mastering the intricate art of 3D printing. Our training courses cater to both Mac and Windows operating systems and provide: Price Assurance: Ensuring the best value for your investment. Personalized Attention: Benefit from one-on-one training sessions tailored to your learning pace and style. Flexible Scheduling: Choose your preferred time and day for training sessions, available seven days a week from 9 am to 8 pm. Ongoing Support: Enjoy lifetime email and phone support, ensuring you're never alone on your learning journey. Technical Assistance: Receive guidance in configuring your computer for software installation, ensuring a seamless learning experience. Special Benefits: Avail special discounts when you refer a friend and significant savings on group training courses, maximizing the value of your training investment.

Java OOP Course Duration: 1 Day Who would find this course useful? This is useful if you have some coding skills already. This course is fast paced, not quite basics level. It specifically concentrates on Object Oriented Programming Principles (OOP) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java OOP Course description Session 1: General Concepts Revision: Scanner, Input from stdin, Print to stdout. Descision, While and For Loops Arrays Session 2: Packages, Methods, Encapsulation Using packages Creating and calling methods, parameters, method overloading Data protection through encapsulation Session 3: Classes, object construction Inheritance, method overload and override Polymorphism or runtime binding Session 4: Constructors, parameterised constructors Create abstract classes and methods Create and use an interface Session 5: Use the access modifiers protected and the default (package-friendly) Create static variables, methods, and initialisers Create final classes, methods, and variables Session 6: Nested Classes, Local Classes, Anonymous Classes, and Lambda Expressions, Enum Types Nested and inner classes; A stack class. What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java OOP Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Supporting Windows 10 course description This course is designed to provide students with the knowledge and skills required to support and troubleshoot Windows 10 PCs and devices in a Windows Server domain environment. These skills include understanding of Windows 10 features, how they can be used in an Active Directory environment and how to troubleshoot them. What will you learn Troubleshoot startup issues and operating system services on a Windows 10 PC. Troubleshoot issues related to network connectivity. Troubleshoot client configuration failures and GPO application issues. Troubleshoot issues related to application installation and operation. Recover a PC running Windows 10. Supporting Windows 10 course details Who will benefit: Anyone supporting users running Windows 10 personal computers within a medium to large enterprise. Prerequisites: None. Duration 5 days Supporting Windows 10 course contents Implementing a Troubleshooting Methodology Overview of Windows 10, Introduction to the EDST Job Role, Overview of the Troubleshooting Steps & Tools. Hands on Implementing a Troubleshooting Methodology. Hands on Using Troubleshooting Tools for Windows 10. Troubleshooting Startup Issues Overview of the Windows 10 Startup Recovery Environment, Troubleshooting Startup Settings & Operating System Services Issues, Recovering BitLocker-Protected Drives. Hands on Troubleshooting Startup Issues. Hands on Recovering BitLocker-Encrypted Drives, Creating a New BitLocker Password. Troubleshooting Hardware and Device Drivers Troubleshooting Device Driver Failures & Physical Failures, Overview of Hardware Troubleshooting, Monitoring Reliability, Configuring the Registry. Hands on Troubleshooting Device Driver Issues, Resolving Hardware Issues, Adding a Missing Device Driver to a Driver Store, Reverting a Problematic Device Driver. Hands on Troubleshooting Hardware Issues, Diagnosing Memory, Troubleshooting and Repairing Failed Disk Redundancy Synchronizing Settings, Accessing Data on a Foreign Volume. Troubleshooting Remote Computers Using Remote Desktop and Remote Assistance, Remoting with Windows PowerShell Hands on Troubleshooting Remote Computer by using Remote Desktop and Remote Assistance. Hands on Troubleshooting Remote Computer by using Windows PowerShell. Resolving Network Connectivity Issues Determining Network Settings, Troubleshooting Network Connectivity Issues, Troubleshooting Name Resolution. Hands on Resolving Network Connectivity Issues. Hands onResolving Name Resolution Issues. Troubleshooting Group Policy Overview of Group Policy Application, Resolving Client Configuration Failures and GPO Application Issues. Hands on Troubleshooting Group Policy Application Issues. Hands on Resolving Group Policy Issues. Hands on Installing and Sharing a Printer. Troubleshooting User Settings Troubleshooting Sign In Issues, Troubleshooting the Application of User Settings. Hands on Troubleshooting Sign in Problems. Hands on Troubleshooting the Application of User Settings, Resolving Folder Redirection Problem, Resolving Roaming User Profile Problem. Troubleshooting Remote Connectivity Troubleshooting VPN Connectivity Issues & DirectAccess. Hands on Troubleshooting VPN Connectivity Lab : Configuring and Troubleshooting DirectAccess Configuring and Verifying, DirectAccess Client-Side Settings, Troubleshooting DirectAccess. Troubleshooting Resource Access Within a Domain & File Permissions Issues, Recovering Files Encrypted by EFS, Troubleshooting Printer Access Issues. Lab : Troubleshooting File Access Issues Lab : Troubleshooting Access to Encrypted Files. Hands on Troubleshooting Printer Access Issues Troubleshooting Resource Access for Non Domain Member Clients Configuring and Troubleshooting Device Registration, Configuring and Troubleshooting Work Folders, Configuring and Troubleshooting OneDrive Access. Hands on Troubleshooting Resource Access for Clients that are not Domain Members. Troubleshooting Device Registration, Work Folders and OneDrive for Business. Troubleshooting Applications Troubleshooting Desktop App Installation Issues, Desktop Apps, Managing Windows Store Apps, Troubleshooting Access to Company Web Applications. Hands on Troubleshooting Desktop Apps, AppLocker Policy Application & Application Compatibility issue. Hands on Troubleshooting Access to Company Web Applications, Internet Explorer Issue & Microsoft Edge. Maintaining Windows 10 Managing & Troubleshooting Windows Activation, Troubleshooting Performance, Applying Applications. Hands on Monitoring and Troubleshooting Performance. Recovering Data and Operating System File Recovery in Windows 10, Recovering an OS. Hands on Recovering Data, Recovering Data from Azure Backup, Recovering Deleted File by Using File History. Hands on Provisioning Computer to Comply with Company Standards, Provision Computer to Comply with Company Standards.

Complete C programming training course description A hands-on introduction to programming in the ANSI C programming language. The course initially moves at a fast pace in order to spend as much time as possible on the subject of pointers - the area which cause the most bugs in C programs. What will you learn Write ANSI C programs Use the C libraries Debug C programs Examine existing code and determine its function. Complete C programming training course details Who will benefit: Programmers wishing to learn C. Programmers wishing to learn C++ or Java. Prerequisites: None, although experience in another high level language would be useful. Duration 5 days Complete C programming training course contents Getting started The compilation process, comments, main(), statement blocks, printf(). C data types and operators char, int, float and double, qualifiers, arithmetic and assignment operators, precedence, Associativity. Basic I/O C libraries, stdin and stdout, getchar(), putchar(), printf() formatting. Flow control if else, dangling elses, else if, while and for loops. switch statements, the null statement, break, continue and gotos. Functions Function calls, arguments and return types, function declarations (prototypes), function definitions, scope of variables. The preprocessor Preprocessor actions, macros, #include. Libraries and their relationship with header files. Conditional compilation. More data types and operators Logical, bitwise and other operators, type conversion, casting, typedefs and access modifiers. Arrays Declaring and handling arrays, common gotchas, multidimensional arrays. Pointers What are pointers? Why they are so important, declaring and using pointers,The three uses of the *,pointer example - scanf, pointers as arguments. More pointers Golden rules of pointers and arrays, pointers to arrays, pointer arithmetic, arrays of pointers, multiple indirection. Character/string manipulation Arrays of characters, string definition, working with strings, String library. Program arguments argc and argv, example uses,char *argv[] versus char ** argv. Program structure and storage classes Globals (externals), multi source programs, the look of a C program. Structures Declaration, the . and - operators, unions and bitfields. Library functions File handling, fopen and fclose, reading from and writing to files, fseek().calloc() and malloc()

Publisher Courses. With MS Publisher, combine text and photos illustrations to make professional newsletters publications. At our MS Publisher course, learn how to.

This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact. This course will help participants: Using Slide Master Create a presentation using a template Insert slides and change the layout Manage slides and control formats Enhance slides using animation, pictures, charts and graphics Work with tables, rows, cells and columns Create and control paragraph lists Insert titles and labels Effectively use slide show controls and presenter view Print slides, handouts and notes 1 Introduction to PowerPoint Navigating the features Creating a simple presentation Inserting new slides and changing layouts Creating speaker notes 2 Using Layouts in Slide Master Editing templates in slide master Adding a design theme Adding transitions, pictures and logos Using Slide Show View 3 Drawing shapes and SmartArt Using Drawing Tool Formats Creating shapes Aligning shapes and stacking order Creating a cycle graphic Creating an organisation chart 4 Animation Visually enhancing slides with animation Using text and object animation Adding animation to lists Making animation work for you 5 Presenting Confidently running a presentation Using presenter view Using the slide show controls

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