5337 Productivity courses in Cardiff delivered Online

Register on the Excel Pivot Tables, Pivot Charts, Slicers, and Timelines today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Excel Pivot Tables, Pivot Charts, Slicers, and Timelines is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Excel Pivot Tables, Pivot Charts, Slicers, and Timelines, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21: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.

Description: To build a successful career, you need to have excellent presentation skills. As a result, you need to have expertise on different software. This Corel Presentations X3 Application Training will help you with just that. This course will teach you about Corel Presentations X3, a highly customizable software which includes animations of text and images, sounds, spreadsheets, etc. These features will facilitate you to make an attractive presentation and in turn, it will help you stand out among others in any professional field. So if you want to promote your career, this course should help a lot. Learning Outcomes: Common presentation applications, opening and closing the program, understanding the application and getting help Create blank presentations, enter text in standard and outline view, and edit and delete text Create presentations from a template, saving multiple times, opening presentations, switching between open presentations, and closing them Using editing tools like undo, cut, copy, find and replace, QuickCorrect and more Using viewing tools by changing views, using zoom, showing and hiding toolbars, and changing basic options Adding new, copying, moving and deleting slides; also discover how to change slide layout and design Explore how to apply master to a presentation, switch masters, add animations and slide transitions Format texts by changing font type, size, colours, applying effects, using alignment, styles and much more Discover how to choose an output format, use 'Show on the Go', add speaker notes, change orientation and size, access print settings and print out slides Hide and show slides, start and navigate through slide show, and stop the show Add pictures from a file or scrapbook, move, resize, cut, copy and paste them Working with data and organisation charts Working with and editing objects through drawing text box, shapes, rotation, resize and other options Create Master slides and footers, work with background and layout layers, and add dynamic elements Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Corel Presentations X3 Application Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Corel Presentations X3 Application Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started 01:00:00 Creating a Presentation 00:30:00 Working With Files 01:00:00 Editing Tools, Part 1 00:30:00 Editing Tools, Part 2 01:00:00 Viewing Tools 01:00:00 Basic Presentations 01:00:00 Designing a Presentation 01:00:00 Formatting Text 01:00:00 Finishing Touches 01:00:00 Delivering Your Presentation 01:00:00 Working With Images 01:00:00 Working with Data Charts 01:00:00 Working with Organization Charts 01:00:00 Working with Objects 01:00:00 Editing Objects 01:00:00 Master Slides and Layers 01:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course is a short and crisp introduction to those who do not have any prior knowledge of scripting or any programming basics. The instructor has tried to explain the concepts in such a simple terminology that even non-technical people will find it very easy to grasp the various Windows PowerShell concepts.

Description: This Microsoft Office 2013 PowerPoint Advanced - Complete Video Course covers more advanced features of PowerPoint 2013. In this series, you will learn how to modify the PowerPoint environment, using methods like customizing design templates, working with media and animations, and adding SmartArt to a presentation, customizing a slide show and securing and distributing a presentation, use tables and spreadsheets to display data in a presentation, learn how to add, format and edit charts with the chart tools and quick clicks, design slide masters and apply slide transitions, apply animations to images in a slide show and edit the timing, add videos to a PowerPoint presentation and trim the media, practice delivering presentations with the presenter's tools, use the review tools to proof and protect presentations, and more. If, you have the basic skills with Microsoft Office 2013 PowerPoint and want to learn advanced-level skills then this course will be perfect for you. 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 2013 PowerPoint Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 PowerPoint Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Modifying the PowerPoint Environment Customize the User Interface FREE 00:12:00 Set PowerPoint 2013 Options 00:04:00 Customizing Design Templates Modify Slide Masters and Slide Layouts 00:12:00 Add Headers and Footers 00:06:00 Modify the Notes Master and the Handout Master 00:04:00 Adding SmartArt to a Presentation Create SmartArt 00:06:00 Modify SmartArt 00:07:00 Working with Media and Animations Add Audio to a Presentation 00:13:00 Add Video to a Presentation 00:12:00 Customize Animations and Transitions 00:14:00 Collaborating on a Presentation Review a Presentation 00:18:00 Store and Share Presentations on the Web 00:11:00 Customizing a Slide Show Annotate a Presentation 00:04:00 Set Up a Slide Show 00:04:00 Create a Custom Slide Show 00:04:00 Add Hyperlinks and Action Buttons 00:10:00 Record a Presentation 00:07:00 Securing and Distributing a Presentation Secure a Presentation 00:09:00 Broadcast a Slide Show 00:08:00 Create a Video or a CD 00:09:00 Mock Exam Mock Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields. The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Excel 2016 Introduction 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 MS Excel 2016 Introduction 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. Introduction Introduction FREE 00:01:00 Getting Started with Excel What is Excel 00:02:00 Opening Excel 00:04:00 Navigating the Excel User Interface 00:07:00 Using the Excel Ribbon 00:03:00 Understanding Excel Work Components 00:04:00 Using the Backstage View 00:03:00 Creating Workbooks and Using Templates Creating a New Workbook 00:03:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using Convert and Checking Compatiblity 00:02:00 Entering Data Navigating a Worksheet by Mouse or Keyboard 00:05:00 Excel Data Types 00:03:00 Cell and Range Addressing 00:02:00 Data Selection Techniques 00:05:00 Common Excel Commands 00:07:00 Using the Autofill Handle 00:03:00 Excel Formula Basics Data What are Formulas and Functions 00:02:00 Components of a Formula 00:06:00 Calculation Hierarchy Using the Order of Operations_Revise 00:02:00 Creating Basic Formulas 00:08:00 Working with Basic Functions and Autosum 00:04:00 Using Cell References 00:04:00 Using the Quick Analysis Tool 00:01:00 Adjusting a Worksheet Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:03:00 Formatting and Aligning Worksheet Data Formatting and Aligning Data 00:06:00 Merging Data 00:03:00 Wrapping Text Orientation 00:02:00 Formatting Numbers 00:03:00 Using Borders and Shading 00:03:00 Using the Format Painter 00:01:00 Removing Formatting Quickly 00:01:00 Using Cell Styles and Themes Understanding Cell Styles 00:02:00 Applying Cell Styles 00:04:00 Applying Themes 00:03:00 Inserting Objects and Graphics Inserting and Formatting Images 00:03:00 Inserting and Formatting Shapes 00:04:00 Inserting and Formatting Smart Art 00:04:00 Inserting Screenshots 00:02:00 Inserting Hyperlinks 00:03:00 Inserting Symbols and Equations 00:03:00 Inserting Word Art Or Text Boxes 00:04:00 Inserting Other Excel Objects 00:04:00 Arranging Objects 00:04:00 Proofing a Workbook Using Find and Replace 00:04:00 Finding and Replacing Formatting 00:01:00 Using Got to and Go to Special 00:02:00 Using the Spell Checker 00:03:00 Using the Theasaurus and Translation Feature 00:03:00 Printing an Excel File Printing and Previewing Excel Files 00:03:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:04:00 Formatting a Page with the Page Layout Tab 00:03:00 Printing Titles and Specific Worksheet Areas 00:05:00 Exporting to PDF and XPs 00:02:00 Managing Worksheets Renaming and Coloring Worksheet Tabs 00:03:00 Adding, Deleting, and Navigating Worksheets 00:03:00 Moving and Copying Worksheets 00:04:00 Hiding and Unhiding Worksheets 00:02:00 Navigating and Viewing Excel Files Viewing Workbooks 00:03:00 Using Zoom Tools 00:02:00 Configure Sheet Options 00:02:00 Using Freeze Panes and Split Commands 00:05:00 Working with Window Commands 00:04:00 Adjusting Workbook Properties 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

The Diploma in Event Management is a comprehensive online course designed to equip you with the essential skills and knowledge to excel in the fast-paced event industry. Whether you dream of organizing corporate conferences, weddings, music festivals, or sporting events, this course covers event planning, budgeting, marketing, logistics, and risk management. You’ll learn from industry experts through real-world case studies, interactive modules, and hands-on projects. This course blends theoretical knowledge with practical insights, ensuring you understand the latest trends, digital tools (like event management software), and sustainability practices in events. By the end, you’ll be able to plan, execute, and evaluate successful events while managing clients, vendors, and teams efficiently. Perfect for aspiring event planners, entrepreneurs, or professionals looking to switch careers, this diploma provides a globally recognized certification to boost your credibility in the industry. With flexible online learning, you can study at your own pace and gain access to exclusive resources, networking opportunities, and career support. Start your journey towards becoming a skilled event manager today! Learning Outcomes Master end-to-end event planning, from concept to execution. Develop budgeting and financial management skills for profitable events. Learn effective marketing strategies, including social media & branding. Understand venue selection, logistics, and vendor management. Gain expertise in risk assessment and crisis management. Utilise event technology & software (e.g., Eventbrite, Cvent). Enhance client communication and negotiation skills. Explore sustainable and eco-friendly event practices. Build a professional portfolio with real-world projects. Who is This Course For? This course is ideal for aspiring event planners, hospitality professionals, marketing executives, entrepreneurs, and career changers seeking entry into the event industry. It’s also beneficial for small business owners who want to organize their own events or corporate professionals handling company meetings and conferences. No prior experience is required—just a passion for creating unforgettable experiences! Career Path Event Coordinator – £22,000 - £30,000 Wedding Planner – £25,000 - £40,000 Corporate Event Manager – £30,000 - £50,000 Festival Organizer – £28,000 - £45,000 Conference Producer – £35,000 - £55,000 Exhibition Manager – £32,000 - £48,000 Why Enroll? Industry-recognised certification Flexible online learning Expert-led training & case studies Career support & job placement guidance Start your journey in event management today and turn your passion into a thriving career! 🎉

Transform your data into actionable insights with Microsoft Power BI. Empower your business decisions through dynamic visualizations, interactive dashboards, and robust analytics. Unleash the power of data with this industry-leading business intelligence tool, designed to help you make informed choices and drive success. Explore the capabilities of Microsoft Power BI today for a smarter, data-driven future.

Microsoft Project 2016 Complete Course is one of our best. Offering excellent value for money, we can promise you high-quality and comprehensive content created by our subject matter experts. Organised into separate, digestible modules, the course is guaranteed to provide you with everything you need to know in order to accomplish your professional goals. If so, this is the perfect course to help you develop as a leader, and to learn how the Microsoft Project software package can be an essential tool in your project's success. This course will teach you how to exchange project plan data with other applications, customise element of your plan, and reuse project plan information. You will gain all the knowledge you need to plan, track and report on projects, in turn helping you set clear goals to manage in a cost-effective manner. By staying on top of seemingly minor details, you will develop essential skills in managing both your project and team effectively, now and in the future. Why choose this course Earn an e-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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Anyone who already has an understanding of project management concepts, and possesses the basics in creating and modifying project plans in Microsoft Project 2016. This is an essential course for those who need to use Microsoft Project 2016 to manage and customise project plans throughout the implementation stage.

Elevate your skills with the Diploma in Microsoft Azure 2017 – a comprehensive program offering in-depth insights and hands-on training in the latest cloud computing technologies. Master the intricacies of Microsoft Azure, stay ahead in the ever-evolving tech landscape, and unlock new career opportunities. Enroll now for a transformative learning experience that aligns with the cutting-edge advancements of 2017.