Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities... Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL 1 year email support service Take a closer look at the consistent excellent feedback from our growing 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Description Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements General knowledge of the Windows OS Career path Microsoft Office 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
Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Overview Spanish Language for Beginners to Intermediate Bundle Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Spanish Language for Beginners to Intermediate Bundle Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. ***Spanish Language for Beginners*** Introduction Introduction 00:05:00 Lesson: 01 Lesson 1a 00:03:00 Lesson 1b 00:04:00 Lesson 1c 00:04:00 Lesson 1d 00:04:00 Lesson: 02 Lesson 2a 00:03:00 Lesson 2b 00:04:00 Lesson 2c 00:04:00 Lesson 2d 00:04:00 Lesson 2e 00:03:00 Lesson: 03 Lesson 3a 00:04:00 Lesson 3b 00:03:00 Lesson 3c 00:04:00 Lesson 3d 00:03:00 Lesson 3e 00:03:00 Lesson 3f 00:05:00 Lesson: 04 Lesson 4a 00:03:00 Lesson 4b 00:03:00 Lesson 4c 00:03:00 Lesson 4d 00:03:00 Lesson 4e 00:03:00 Lesson 4f 00:03:00 Lesson 4g 00:03:00 Lesson 4h 00:04:00 Lesson: 05 Lesson 5a 00:03:00 Lesson 5b 00:03:00 Lesson 5c 00:03:00 Lesson 5d 00:03:00 Lesson 5e 00:03:00 Lesson 5f 00:03:00 Lesson 5g 00:03:00 Lesson 5h 00:03:00 Lesson 5i 00:03:00 Lesson 5j 00:03:00 Lesson 5k 00:03:00 Lesson: 06 Lesson 6a 00:03:00 Lesson 6b 00:03:00 Lesson 6c 00:03:00 Lesson 6d 00:03:00 Lesson 6e 00:03:00 Lesson 6f 00:03:00 Lesson 6g 00:03:00 Lesson: 07 Lesson 7a 00:03:00 Lesson 7b 00:03:00 Lesson 7c 00:03:00 Lesson 7d 00:03:00 Lesson 7e 00:03:00 Lesson 7f 00:03:00 Lesson 7g 00:03:00 Lesson 7h 00:03:00 Lesson: 08 Lesson 8a 00:03:00 Lesson 8b 00:03:00 Lesson 8c 00:03:00 Lesson 8d 00:04:00 Lesson 8e 00:03:00 Lesson 8f 00:04:00 Lesson 8g 00:03:00 Lesson 8h 00:03:00 Lesson 8i 00:03:00 Lesson 8j 00:03:00 Lesson 8k 00:04:00 Lesson: 09 Lesson 9a 00:03:00 Lesson 9b 00:03:00 Lesson 9c 00:03:00 Lesson 9d 00:03:00 Lesson 9e 00:03:00 Lesson 9f 00:03:00 Lesson 9g 00:03:00 Resources Resources: Beginners Spanish Course 00:00:00 ***Spanish Language : Intermediate Level*** Learn Spanish - The Past I- Simple and Compound 00:10:00 Learn Spanish - The Past I- Simple and Compound (Contrast) 00:14:00 Learn Spanish - The Past II- Past Perfect 00:07:00 Learn Spanish - The Past III- Past Imperfect 00:09:00 Learn Spanish - The past IV- Contrast 00:10:00 Learn Spanish - The Gender of nouns 00:15:00 Learn Spanish - The Number of nouns 00:07:00 Learn Spanish - Informal affirmative imperative 1 00:11:00 Learn Spanish - Informal affirmative imperative 2 00:04:00 Learn Spanish - Formal affirmative imperative 00:09:00 Learn Spanish - Affirmative imperative 00:12:00 Learn Spanish - The indefinite 00:14:00 Learn Spanish - Quantifiers 00:16:00 Learn Spanish - The frequency 00:14:00 Learn Spanish - Perfect future 00:09:00 Learn Spanish - The simple conditional 00:10:00 Learn Spanish - Conditional Sentences 00:14:00 Learn Spanish - In the car 00:10:00 Learn Spanish - The negative imperative 00:10:00 Learn Spanish - Pronouns 00:10:00 Learn Spanish - Present Subjunctive 00:24:00
English language book club to use and improve your English. Qualified and experienced British English teacher.
English language book club to use and improve your English. Qualified and experienced British English teacher.
Choose what you want to learn in this fast-track hairdressing course. Aimed at those who’ve left college with a hairdressing qualification but don’t feel confident enough on the salon floor or those needing to brush up on a specific skill. Our training concentrates on cutting, colouring, styling and barbering.
Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is as follows: System engineers Technical support personnel Channel partners and resellers Overview Upon completion of this course, the learner should be able to meet the following objectives: Installing a Cisco Meeting Server in a single combined deployment Installing a Cisco Meeting Server in a single split deployment Troubleshooting tools Integrating Cisco Meeting Server with Cisco TelePresence Video Communication Server (VCS), Cisco Unified Communications Manager and Microsoft Skype for Business In this course, you will learn how to install, troubleshoot, and maintain a single server and single server split deployment of Cisco Meeting Servers This course is designed to establish a minimum level of knowledge and competency among Cisco Meeting Server resale and installation partners. The recently purchased Acano collaboration hardware and software includes video and audio-bridging technology that allows customers to connect video systems from multiple vendors across both cloud and hybrid environments. Cisco has incorporated Acano collaboration technologies into the new Meeting Server tool. Module 1: Cisco Meeting Server Single Server Solution Cisco Meeting Server Solution Reviewing Authentication and Encryption Single Server Solution Preparing for Cisco Meeting Server Installation Installing Cisco Meeting Servers Configuring the Web Admin Configuring the Call Bridge Configuring the Web Bridge Module 2: Troubleshooting Tools Seven call detail record (CDR) record types and the information contained in each Capture server configuration files (.json), crash log files, media and application .dmp files. Cisco Meeting App crash files, and Cisco Meeting App diagnostic logs Employ the built-in commands to identify Cisco Meeting Server solution issues including PKI, DNS Lookup, Ping, and Service Status Common issues for end users using the Cisco Meeting Server solution Module 3: Firewall Traversal and Unified Communications Application Integration Deploying a TURN Server Deploying Firewall and NAT Traversal Integrating with UC Platforms Additional course details: Nexus Humans Cisco Meeting Server Intermediate (COLLAB250) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Meeting Server Intermediate (COLLAB250) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Introduction: Unlock the power of Microsoft Excel with this comprehensive four-course bundle. Gaining mastery of Macros, you'll move through beginner, intermediate, and advanced levels. Solidify your knowledge and refine your skills with each step, and become an Excel expert. This Microsoft Excel course caters to beginner, intermediate, and advanced levels. It aims to provide students with a comprehensive understanding of Excel, a powerful spreadsheet software that is widely used in business and other industries. For Beginners, the course covers the basics of Excel, including creating and formatting worksheets, entering data, and performing calculations using formulas and functions. Students will also learn how to create charts and graphs to display data visually. For Intermediate learners, the course delves deeper into Excel's functionalities, including sorting and filtering data, conditional formatting, and basic data analysis using PivotTable and PivotChart. They will also learn how to use macros to automate repetitive tasks and increase productivity. For Advanced learners, the course covers advanced Excel features such as complex formulas, array functions, and advanced charting techniques. Students will also learn how to use Excel's VBA (Visual Basic for Applications) programming language to create custom macros and automate complex tasks. Overall, this course is designed to provide students with a solid foundation in using Microsoft Excel at all levels. Whether a beginner, intermediate or advanced user, the course will equip them with the necessary skills to manage and analyze data effectively, increasing their productivity and efficiency.