1336 Courses

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

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

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.

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 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.

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.

Boost Your Career By Enrolling In This Microsoft Excel & Data Analysis Bundle To Overcome Your Challenges! 4 in 1 Microsoft Excel & Data Analysis Bundle Improve your knowledge and enhance your skills to succeed with this Microsoft Excel & Data Analysis bundle. This Microsoft Excel & Data Analysis bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This Microsoft Excel & Data Analysis Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Microsoft Excel Complete Course Course 02: Basic Data Analysis Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 04: SQL for Data Science, Data Analytics and Data Visualization All the courses under this Microsoft Excel & Data Analysis bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Microsoft Excel & Data Analysis bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive Microsoft Excel & Data Analysis bundle, you can achieve your dreams and train for your ideal career. This Microsoft Excel & Data Analysis bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us for Microsoft Excel & Data Analysis? All-in-one package of 4 premium courses' Microsoft Excel & Data Analysis bundle Earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Globally Accepted Standard Lesson Planning Free Assessments with this Microsoft Excel & Data Analysis Bundle 24/7 Tutor Support available with this Microsoft Excel & Data Analysis Bundle Start your learning journey straightaway! This Microsoft Excel & Data Analysis's curriculum has been designed by Microsoft Excel & Data Analysis experts with years of Microsoft Excel & Data Analysis experience behind them. The Microsoft Excel & Data Analysis course is extremely dynamic and well-paced to help you understand Microsoft Excel & Data Analysis with ease. You'll discover how to master the Microsoft Excel & Data Analysis skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Microsoft Excel & Data Analysis bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel & Data Analysis bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Microsoft Excel & Data Analysis bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

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.

This course will fully prepare you for virtually any Excel-related career path

Duration 1 Days 6 CPD hours This course is intended for This course is intended for those with a basic understanding of Microsoft Windows and who need to learn foundational Word skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content. Overview In this course, you will learn fundamental Word skills. You will: Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application. Format text and paragraphs. Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles. Enhance lists by sorting, renumbering, and customizing list styles. Create and format tables. Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art. Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout. Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility. These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing.Microsoft© Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements andlayout options; and proof documents.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will alsoenable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using Word for theWeb and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for the Microsoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams. Lesson 1: Getting Started with Word Topic A: Navigate in Microsoft Word Topic B: Create and Save Word Documents Topic C: Edit Documents Topic D: Work with Word for the Web Lesson 2: Formatting Text and Paragraphs Topic A: Apply Character Formatting Topic B: Control Paragraph Layout Topic C: Align Text Using Tabs Topic D: Display Text in Bulleted or Numbered Lists Topic E: Apply Borders and Shading Lesson 3: Working More Efficiently Topic A: Make Repetitive Edits Topic B: Apply Repetitive Formatting Topic C: Use Styles to Streamline Repetitive Formatting Tasks Topic D: Customize the Word Environment Lesson 4: Managing Lists Topic A: Sort a List Topic B: Format a List Lesson 5: Adding Tables Topic A: Insert a Table Topic B: Modify a Table Topic C: Format a Table Topic D: Convert Text to a Table Lesson 6: Inserting Graphic Objects Topic A: Insert Symbols and Special Characters Topic B: Add Images to a Document Lesson 7: Controlling Page Appearance Topic A: Apply a Page Border and Color Topic B: Add Headers and Footers Topic C: Control Page Layout Topic D: Add a Waterm Lesson 8: Preparing to Publish a Document Topic A: Check Spelling, Grammar, and Readability Topic B: Preview and Print Documents Topic C: Use Research Tools Topic D: Check Accessibility Topic E: Dictate Text in a Document Topic F: Save a Document to Other Form Additional course details: Nexus Humans Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1 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 Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1 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.