8832 Courses delivered Online

Unlock the power of perfect communication with our comprehensive course designed to enhance your English skills. Whether you're a student, a professional, or a language enthusiast, this course is your gateway to mastering the nuances of English grammar, punctuation, and spelling. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access This course covers essential skills in grammar, punctuation, and spelling. Learners start by understanding the basics of sentences, including how they are structured. The course then moves on to teach fundamental grammar rules, ensuring a solid grasp of how to construct clear and correct sentences. Punctuation and capitalization are explored in detail, helping learners to correctly use commas, periods, and other punctuation marks. The spelling module focuses on common spelling rules and tips for avoiding mistakes. Additionally, the course identifies frequent errors in writing and provides strategies for improvement. By the end, learners will have the confidence to write accurately and effectively, with a thorough understanding of proper grammar, punctuation, and spelling. Course Curriculum Module 01: Introduction to the Course Module 02: The Basics of Sentence Module 03: Structure of Sentence Module 04: Basics of Grammar Module 05: Punctuation and Capitalisation Module 06: Spelling Module 07: Common Mistakes and Ways to Improve Module 08: Questions Learning Outcomes Understand basic sentence structure and its essential components. Master complex sentence structures and their various forms. Grasp foundational grammar rules and applications. Apply correct punctuation and capitalisation in writing. Improve spelling accuracy and techniques. Identify common mistakes and learn effective correction methods. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring writers seeking grammatical proficiency Students improving their writing skills Professionals refining communication abilities Teachers enhancing grammar knowledge Language enthusiasts aiming for linguistic accuracy Career path Editorial Assistant Content Writer Copy Editor Proofreader Teacher Communications Officer Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Unlock the power of perfect communication with our comprehensive course designed to enhance your English skills. Whether you're a student, a professional, or a language enthusiast, this course is your gateway to mastering the nuances of English grammar, punctuation, and spelling. Key Features: CPD Certified Developed by Specialist Lifetime Access This course covers essential skills in grammar, punctuation, and spelling. Learners start by understanding the basics of sentences, including how they are structured. The course then moves on to teach fundamental grammar rules, ensuring a solid grasp of how to construct clear and correct sentences. Punctuation and capitalization are explored in detail, helping learners to correctly use commas, periods, and other punctuation marks. The spelling module focuses on common spelling rules and tips for avoiding mistakes. Additionally, the course identifies frequent errors in writing and provides strategies for improvement. By the end, learners will have the confidence to write accurately and effectively, with a thorough understanding of proper grammar, punctuation, and spelling. Course Curriculum Module 01: Introduction to the Course Module 02: The Basics of Sentence Module 03: Structure of Sentence Module 04: Basics of Grammar Module 05: Punctuation and Capitalisation Module 06: Spelling Module 07: Common Mistakes and Ways to Improve Module 08: Questions Learning Outcomes Understand basic sentence structure and its essential components. Master complex sentence structures and their various forms. Grasp foundational grammar rules and applications. Apply correct punctuation and capitalisation in writing. Improve spelling accuracy and techniques. Identify common mistakes and learn effective correction methods. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring writers seeking grammatical proficiency Students improving their writing skills Professionals refining communication abilities Teachers enhancing grammar knowledge Language enthusiasts aiming for linguistic accuracy Career path Editorial Assistant Content Writer Copy Editor Proofreader Teacher Communications Officer Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Premium Bundle of all Time | Ofqual Regulation + NCFE Awards + QLS Endorsement | Assessment & Tutor Support Included

The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City & Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners). During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning. We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course. (The kits may also be purchased by the learner….see the Kits Page Link for more details). The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.

Embark on your journey to mastering the IELTS with our comprehensive 'IELTS Exam Preparation' course. Imagine yourself confidently navigating the complexities of this globally recognized English proficiency test. Our course begins with an introduction to IELTS, providing a clear understanding of what to expect, setting the stage for a focused and effective study plan. As you progress, each module meticulously breaks down the IELTS test format, transforming a daunting exam into a series of manageable, conquerable sections. This course is designed not just to prepare you for the IELTS but to equip you with the English language skills that will serve you well beyond the test. Delve into the heart of IELTS with detailed modules on grammar, from the basics to sentence structure, punctuation, and capitalisation. These foundational lessons are crucial, not just for acing the test but for effective communication in English. As you move through the course, you'll tackle the specific challenges of the listening, reading, writing, and speaking sections, with strategies tailored for both the academic and general training versions of the test. The course concludes with practical advice for the days leading up to the test and full-length practice tests to ensure you are as prepared as possible. By the end of this course, you will not only be ready to take the IELTS but also to embark on new opportunities that proficiency in English can bring. Learning Outcomes Gain a comprehensive understanding of the IELTS format and expectations. Develop a strong foundation in English grammar and sentence structure. Acquire effective strategies for tackling each section of the IELTS. Improve listening, reading, writing, and speaking skills in English. Build confidence and readiness for the IELTS through full-length practice tests. Why choose this IELTS Exam Preparation course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this IELTS Exam Preparation course for? Students planning to study in English-speaking countries. Professionals seeking employment opportunities abroad. Individuals aiming to improve their English language proficiency. Immigrants needing to pass the IELTS for residency applications. Anyone interested in a structured approach to mastering English for the IELTS. Career path English as a Second Language (ESL) Teacher: £20,000 - £35,000 Study Abroad Advisor: £25,000 - £40,000 International Student Coordinator: £23,000 - £38,000 Language Translator: £22,000 - £36,000 Immigration Consultant: £24,000 - £42,000 Corporate English Trainer: £27,000 - £45,000 Prerequisites This IELTS Exam Preparation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This IELTS Exam Preparation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to IELTS Introduction to IELTS 00:25:00 Module 02: IELTS Test Format IELTS Test Format 00:30:00 Module 03: Grammar for IELTS: Basics of Grammar Grammar for IELTS: Basics of Grammar 00:12:00 Module 04: Grammar for IELTS: The Basics of Sentence Grammar for IELTS: The Basics of Sentence 00:15:00 Module 05: Grammar for IELTS: Structure of Sentence Grammar for IELTS: Structure of Sentence 00:25:00 Module 06: Grammar for IELTS: Punctuation & Capitalisation Grammar for IELTS: Punctuation & Capitalisation 00:25:00 Module 07: The Listening Section The Listening Section 00:15:00 Module 08: The Reading Section [Academic] The Reading Section [Academic] 00:30:00 Module 09: The Writing Section [Academic] The Writing Section [Academic] 00:40:00 Module 10: The Speaking Section The Speaking Section 00:30:00 Module 11: IELTS [General Training] IELTS [General Training] 00:45:00 Module 12: IELTS Life Skills IELTS Life Skills 00:50:00 Module 13: What To Do Before The IELTS Test? What To Do Before The IELTS Test? 00:30:00 Module 14: IELTS Full-length Practice Tests IELTS Full-length Practice Tests 00:00:00

Learn how to code in HTML from scratch. Perfect for beginners and anyone who wants to learn HTML

FREE Level 5 QLS Certificate | FREE 11 CPD Courses & PDF Certificates | 200 CPD Points | Lifetime Access

Why Learn Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course? Course info Master architectural visualization and photorealistic renderings. In-person or live online options available. Learn Revit and 3dsMax, V-Ray rendering, and advanced techniques. Hands-on projects for real-world experience. Duration: 40 hrs Method: 1-on-1 - Individual support. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Part 1: Revit (16 hours) Module 1: Introduction to Revit Familiarizing with the Revit interface and workspace Embracing the Building Information Modeling (BIM) workflow Creating a fundamental building model as a starting point Module 2: Basic Modeling in Revit Working with essential elements such as walls, doors, and windows Constructing floors and roofs to complete the building structure Crafting functional and visually appealing stairs and railings Module 3: Advanced Modeling in Revit Delving into the creation and manipulation of families Utilizing parameters and constraints to enhance modeling efficiency Exploring intricate geometries for complex designs Module 4: Annotation and Documentation in Revit Enhancing project documentation by adding text and dimensions Generating informative schedules for better project management Mastering the printing and exporting processes for professional output Part 2: 3ds Max (16 hours) Module 1: Introduction to 3ds Max Navigating the 3ds Max interface and workspace Understanding the 3D modeling workflow for design visualization Initiating the creation of basic 3D models Module 2: Basic Modeling in 3ds Max Working with primitive shapes to build foundational models Creating and refining splines to form versatile shapes Advancing to complex 3D model development for intricate designs Module 3: Materials and Textures in 3ds Max Exploring the material editor and its functionalities Skillfully applying and adjusting materials for realistic renders Incorporating textures to add depth and detail to the models Module 4: Lighting and Cameras in 3ds Max Mastering the art of lighting creation and manipulation Utilizing the daylight system for enhanced realism Understanding cameras and perspectives for compelling visual storytelling Part 3: V-Ray (8 hours) Module 1: Introduction to V-Ray Getting acquainted with the V-Ray interface and workflow Exploring V-Ray materials and textures for high-quality renders Module 2: Lighting and Rendering in V-Ray Creating and refining lighting setups for stunning renders Utilizing global illumination to enhance the realism of scenes Implementing advanced rendering techniques for professional output Module 3: Materials and Textures in V-Ray Crafting and modifying V-Ray materials for realistic surfaces Applying V-Ray textures to add depth and realism to objects Utilizing V-Ray displacement maps for intricate details For 3ds Max free trial, visit: https://www.autodesk.co.uk/products/free-trial. To access the V-Ray free trial, visit: https://www.chaosgroup.com/. Start your journey to becoming a proficient designer and renderer in the world of 3D modeling and visualization. Download Revit Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course: Proficient Software Skills: Acquire a strong command of Revit and 3dsMax, along with advanced techniques in V-Ray rendering. High-Quality Visualizations: Create realistic and visually stunning architectural visualizations using V-Ray. Architectural Modeling: Master the process of modeling architectural elements with precision and efficiency. Materials and Textures: Understand how to apply realistic materials and textures to enhance visualizations. Lighting Setup: Set up lighting environments to achieve optimal illumination and ambiance in renderings. Rendering Techniques: Explore advanced rendering techniques, including global illumination, caustics, and ambient occlusion. Real-World Projects: Complete industry-relevant projects to build a professional-grade portfolio. Problem-Solving Skills: Develop the ability to troubleshoot and resolve rendering challenges effectively. Efficient Workflows: Learn time-saving workflows and best practices for efficient visualization production. Portfolio Showcase: Showcase your newly acquired skills through a diverse range of visualizations.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server. This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches. Prerequisites Before attending this course, students must have: -Experience with Windows networking technologies and implementation. - Experience with Windows Server administration, maintenance, and troubleshooting. 1 - Review Windows PowerShell Learn about Windows PowerShell Get familiar with Windows PowerShell applications Identify factors to install and use Windows PowerShell Configure the Windows PowerShell console Configure the Windows PowerShell Integrated Scripting Environment (ISE) Use Visual Studio Code with PowerShell 2 - Understand the command syntax in Windows PowerShell Discover the structure of PowerShell cmdlets Discover the parameters for using PowerShell cmdlets Review the tab completion feature in PowerShell Display the About files content in PowerShell 3 - Find commands and Get-Help in Windows PowerShell Define modules in PowerShell Find cmdlets in PowerShell Use command aliases in PowerShell Use Show-Command and Get-Help in PowerShell Interpret the help file contents and update the local help content in PowerShell 4 - Manage Active Directory Domain Services using PowerShell cmdlets Manage user accounts in PowerShell Manage groups and group memberships in PowerShell Manage computer accounts in PowerShell Manage organizational units and Active Directory objects in PowerShell 5 - Manage network service settings for Windows devices using PowerShell cmdlets Manage IP addresses in PowerShell Manage IP routing in PowerShell Manage DNS clients in PowerShell Manage Windows Firewall settings in PowerShell 6 - Manage Windows Server settings using PowerShell cmdlets Automate management tasks using the Group Policy management cmdlets Manage server roles and services using PowerShell cmdlets Manage Hyper-V Virtual Machines using PowerShell cmdlets Manage Internet Information Services using PowerShell cmdlets 7 - Manage settings for a local Windows machine using PowerShell cmdlets Manage Windows 10 using PowerShell Manage permissions with PowerShell 8 - Understand the Windows PowerShell pipeline Review Windows PowerShell pipeline and its output Discover object members in PowerShell Control the formatting of pipeline output 9 - Select, sort, and measure objects using the pipeline Sort and group objects by property in the pipeline Measure objects in the pipeline Select a set of objects in the pipeline Select object properties in the pipeline Create and format calculated properties in the pipeline 10 - Filter objects out of the pipeline Learn about the comparison operators in PowerShell Review basic filter syntax in the pipeline Review advanced filter syntax in the pipeline Optimize the filter performance in the pipeline 11 - Enumerate objects in the pipeline Learn about enumerations in the pipeline Review basic syntax to enumerate objects in the pipeline Review advanced syntax to enumerate objects in the pipeline 12 - Send and pass data as output from the pipeline Write pipeline data to a file Convert pipeline objects to other forms of data representation in PowerShell Control additional output options in PowerShell 13 - Pass pipeline objects Pipeline parameter binding Identify ByValue parameters Pass data by using ByValue Pass data by using ByPropertyName Identify ByPropertyName parameters Use manual parameters to override the pipeline Use parenthetical commands Expand property values 14 - Connect with data stores using PowerShell providers Define Windows PowerShell providers Review the built-in providers in PowerShell Access provider help in PowerShell 15 - Use PowerShell drives in PowerShell Explain PowerShell drives in PowerShell Use PowerShell drive cmdlets in PowerShell Manage the file system in PowerShell Manage the registry in PowerShell Work with certificates in PowerShell Work with other PowerShell drives in PowerShell 16 - Review CIM and WMI Review architecture of CIM and WMI Review repositories in CIM and WMI Locate online class documentation by using CIM and WMI cmdlets 17 - Query configuration information by using CIM and WMI List local repository namespaces and classes by using CIM and WMI Query instances by using commands and WMI Query Language Connect to remote computers by using CIM and WMI cmdlets Query repository classes from remote computers by using CIMSession objects 18 - Query and manipulate repository objects by using CIM and WMI methods Discover methods of repository objects by using CIM and WMI Locate class methods and documentation by using CIM and WMI Invoke methods of repository objects by using CIM and WMI 19 - Manage variables in Windows PowerShell scripts Define variables in Windows PowerShell scripts Create variable names in Windows PowerShell scripts Assign values and types to variables in Windows PowerShell scripts Identify the methods and properties of variables in Windows PowerShell scripts Use string variables and methods in Windows PowerShell scripts Use date variables and methods in Windows PowerShell scripts 20 - Work with arrays and hash tables in Windows PowerShell scripts Define an array in Windows PowerShell scripts Work with array lists in Windows PowerShell scripts Define hash tables in Windows PowerShell Scripts Work with hash tables in Windows PowerShell scripts 21 - Create and run scripts by using Windows PowerShell Review Windows PowerShell scripts Modify scripts in the PowerShell Gallery Create scripts using Windows PowerShell Review the PowerShellGet module in Windows PowerShell Run scripts and set the execution policy in Windows PowerShell Review Windows PowerShell and AppLocker Sign the scripts digitally in Windows PowerShell 22 - Work with scripting constructs in Windows PowerShell Review and use the ForEach loop in Windows PowerShell scripts Review and use the If construct in Windows PowerShell scripts Review and use the Switch construct in Windows PowerShell scripts Review the For construct in Windows PowerShell scripts Review other loop constructs in Windows PowerShell scripts Review Break and Continue in Windows PowerShell scripts 23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets Use the Get-Content command in Windows PowerShell scripts Use the Import-Csv cmdlet in Windows PowerShell scripts Use the Import-Clixml cmdlet in Windows PowerShell scripts Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts 24 - Use methods to accept user inputs in Windows PowerShell scripts Identify values that might change in Windows PowerShell scripts Use the Read-Host cmdlet in Windows PowerShell scripts Use the Get-Credential cmdlet in Windows PowerShell scripts Use the Out-GridView cmdlet in Windows PowerShell scripts Pass parameters to a Windows PowerShell script 25 - Troubleshoot scripts and handle errors in Windows PowerShell Interpret error messages generated for Windows PowerShell commands Add output to Windows PowerShell scripts Use breakpoints in Windows PowerShell scripts Interpret error actions for Windows PowerShell commands 26 - Use functions and modules in Windows PowerShell scripts Review functions in Windows PowerShell scripts Use variable scope in Windows PowerShell scripts Create modules in Windows PowerShell scripts Use the dot sourcing feature in Windows PowerShell 27 - Manage single and multiple computers by using Windows PowerShell remoting Review the remoting feature of Windows PowerShell Compare remoting with remote connectivity Review the remoting security feature of Windows PowerShell Enable remoting by using Windows PowerShell Use one-to-one remoting by using Windows PowerShell Use one-to-many remoting by using Windows PowerShell Compare remoting output with local output 28 - Use advanced Windows PowerShell remoting techniques Review common remoting techniques of Windows PowerShell Send parameters to remote computers in Windows PowerShell Set access protection to variables, aliases, and functions by using the scope modifier Enable multi-hop remoting in Windows PowerShell 29 - Manage persistent connections to remote computers by using Windows PowerShell sessions Review persistent connections in Windows PowerShell Create and manage persistent PSSessions by using Windows PowerShell Disconnect PSSessions by using Windows PowerShell Review the feature of implicit remoting in Windows PowerShell 30 - Review Azure PowerShell module Review Azure PowerShell Review the benefits of the Azure PowerShell module Install the Azure PowerShell module Migrate Azure PowerShell from AzureRM to Azure Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules 31 - Review the features and tools for Azure Cloud Shell Review the characteristics of Azure Cloud Shell Review the features and tools of Azure Cloud Shell Configure and experiment with Azure Cloud Shell 32 - Manage Azure resources with Windows PowerShell Create a new Azure virtual machine by using Windows PowerShell commands Manage Azure virtual machines by using Windows PowerShell commands Manage Azure related storage by using Azure PowerShell Manage Azure subscriptions by using Azure PowerShell 33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell Review benefits to manage Microsoft 365 services by using Windows PowerShell Connect to the Microsoft 365 tenant by using Windows PowerShell Manage users in Microsoft 365 by using Windows PowerShell Manage groups in Microsoft 365 by using Windows PowerShell Manage roles in Microsoft 365 by using Windows PowerShell Manage licenses in Microsoft 365 by using Windows PowerShell 34 - Manage Exchange Online by using Windows PowerShell Connect to Exchange Online by using Windows PowerShell Manage mailboxes in Exchange Online by using Windows PowerShell Manage resources in Exchange Online by using Windows PowerShell Manage admin roles in Exchange Online by using Windows PowerShell 35 - Manage SharePoint Online by using Windows PowerShell Install and connect to SharePoint Online Management Shell by using Windows PowerShell Manage SharePoint Online users and groups by using Windows PowerShell Manage SharePoint sites by using Windows PowerShell Manage SharePoint Online external user sharing by using Windows PowerShell 36 - Manage Microsoft Teams by using Windows PowerShell Review Microsoft Teams PowerShell module Install the Microsoft Teams PowerShell module Manage teams with Microsoft Teams PowerShell module 37 - Create and manage background jobs using Windows PowerShell Define the types of background jobs in Windows PowerShell Start remote jobs and CIM/WMI jobs in Windows PowerShell Monitor jobs in Windows PowerShell Retrieve results for running jobs in Windows PowerShell 38 - Create and manage scheduled jobs using Windows PowerShell Create and run Windows PowerShell scripts as scheduled tasks Define scheduled jobs in Windows PowerShell Create job option and job trigger objects in Windows PowerShell Create and register a scheduled job in Windows PowerShell Retrieve the results from a scheduled job in Windows PowerShell

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills