431 Courses delivered Online

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Master advanced Excel skills and boost your career with our Microsoft Excel Advanced Diploma Course. Gain proficiency in data analysis, understand advanced features, and develop practical expertise.

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

Master data retrieval in Excel with our XLOOKUP and VLOOKUP course. Learn to efficiently find and analyze data, enhancing your spreadsheet skills for better decision-making.

Course overview Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course. In this course, you will develop a comprehensive understanding of the PivotTable and PivotChart and explore how they work. In this Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course, you will learn the steps to create your Pivot table and Pivot chart. We'll show you how to use Pivot tables to summarize large amounts of data. You'll also learn how to use PivotChart to provide visual representation to your summarized data. We will then take you through adding sorts, filters, timelines and slicers to create dynamic dashboards. You will also learn how to use the slicer to slice and dice your data the way you want. Learning outcomes Learn how to summaries data with Pivot Table Be able to add graphical representation to your summarized data with PivotChart Learn how to update the Pivot Table with new data Deepen your understanding of sorting and filtering Be able to import data from various sources with Power Query Gain an excellent understanding of Power Pivot Who is this course for? Professionals who want to learn how to summaries large sums of data into meaningful information using Excel Pivot and Charts can take this course. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst Accountants Financial Analyst Learn Excel With 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course overview Take your data analysis skills to the next level with this Excel Data Analysis Diploma course. This course ensures you're practiced in the data analysis tools to analyze data effortlessly and effectively.  Data analysis is imperative to get meaningful information from data. It helps businesses and organizations make informed decisions. This Excel Data Analysis Diploma course will introduce you to the built-in tools in Excel through which you can analyze data and get your desired results to make better business decisions. It will give you real insights into tracing formulas, Excel scenario manager and data tables. You will learn how to use the forecast sheet to better forecast and identify the advantages of Excel solver and goal seek. You will also discover the most used Excel formulas, such as SUMIF, COUNTIF and Nested IF.  Learning outcomes Familiarize yourself with the data analysis tools Learn about tracing formulas in Excel Deepen your understanding of Excel goal seek Learn how to use the scenario manager in Excel Understand solver add-in and how to use it Have a better grasp of the most used Excel formulas Who is this course for? The comprehensive Excel Data Analysis Diploma course is incredibly beneficial for aspiring professionals who want to learn how to use the built-in tools in Excel for effective data analysis. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Excel Data Analysis Diploma course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst Accountants Financial Analyst Excel Data Analysis Diploma Excel data analysis - 1 00:04:00 Excel data analysis - 2 00:07:00 Excel data analysis - 3 00:03:00 Excel data analysis - 4 00:03:00 Excel data analysis - 5 00:11:00 Excel data analysis - 6 00:16:00 Excel data analysis - 7 00:02:00 Excel data analysis - 8 00:09:00 Excel data analysis - 9 00:16:00 Resource Resource - Excel Data Analysis Diploma 00:00:00 Assignment Assignment - Excel Data Analysis for Beginner 03:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: Corel Quattro Pro X3 is a spreadsheet program; it is practically designed for storing, calculating and analyzing massive amount of data in an efficient way. In this {course_title] you will learn the basic concepts that revolves around this program. Spreadsheet applications are essential for running any office work. In this course, you will start off with an introduction in the basic functions and interactions with the program. After learning the basics, you will categorically move up through the hierarchy to advanced levels. This course will sharpen your skills and help you in the professional field. Learning Outcomes: Review common spreadsheet applications, opening and closing the spreadsheet application Creating a blank spreadsheet, entering, editing and deleting data Creating a spreadsheet from a template, saving it multiple times, changing default directory, opening and closing the program, and switching between open spreadsheets Utilizing the editing tools like select, undo, cut, copy, changing cell dimensions, sort and other related options Using zoom, showing and hiding toolbars, locking and unlocking rows and columns, changing basic options Inserting, naming, deleing, moving and copying worksheets Creating basic formulas, identifying errors, using cell referencing, advanced formulas and IF functions Formatting cells to include decimals, commas, date, currency, percentage; while also changing font size, type and adding effects More formatting options through quick format, text wrapping, aligning cell contents, centring titles, modifying cell orientation and applying borders and shading Creating a chart and changing its titles, background colour, and colour of other chart elements; also find out how to edit charts through the cut, copy, paste, resize, move and delete options Setting up worksheet by modifying margins, orientation, paper size and fitting the worksheet into a page How to prepare to print and carry out the printing job by creating header and footers and using print preview respectively, and explore many other related options 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? Corel Quattro Pro 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 Quattro Pro 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. Spreadsheet Basics Getting Started 01:00:00 Creating a Spreadsheet 00:15:00 Working with Files 01:00:00 Editing Tools Part 1 00:15:00 Editing Tools, Part 2 01:00:00 Viewing Tools 00:30:00 Working With Spreadsheets Working with Worksheets 00:15:00 Working With Formulas 00:30:00 Formatting Cells 00:15:00 Advanced Formatting 00:30:00 Advanced Spreadsheet Tasks Creating a Basic Chart 01:00:00 Editing Charts 00:15:00 Setting up the Worksheet 00:15:00 Preparing to Print 00:30:00 Printing the Worksheet 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

The Magic of Macros The Magic of Macros Learn how Excel's Macros (a.k.a. VBA), can create incredible results in the blink of an eye! We'll start with a few basics, then move to more advanced topics and work through an example. Watch Excel create multiple totals in basically one line of code! This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.