3603 Office Skills & Productivity courses

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Azure Machine Learning Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training employers seek in today's workplaces. The Azure Machine Learning Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Azure Machine Learning Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Azure Machine Learning Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Azure Machine Learning? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standards accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Azure Machine Learning there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Azure Machine Learning course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Azure Machine Learning does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Azure Machine Learning was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Azure Machine Learning is a great way for you to gain multiple skills from the comfort of your home. Azure Machine Learning Module 01: Introduction to Microsoft Azure Machine Learning Studio and Administration 00:22:00 Module 02: Various Modules in Machine Learning 00:13:00 Module 03: Prediction of Income (Automated Tutorial) 00:33:00 Module 04: Prediction of Automobile Price using Linear Regression Algorithm 00:59:00 Module 05: Dataset Processing and Analysis (Sample-1) 00:57:00 Module 06: Cross Validation for Regression (Sample-2) 00:28:00 Module 07: Clustering Group Iris data (Sample-3) 00:17:00 Module 08: Introduction on Notebook in Microsoft Azure Machine Learning Studio 00:18:00 Assignment Assignment - Azure Machine Learning 06:06:00 Order Your Certificate Order Your Certificate QLS

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Are you looking to improve your current abilities or make a career move? Our unique Material Planner course might help you get there! Expand your expertise with high-quality training - study the Material Planner course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Material Planner online training course. The Material Planner course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Material Planner course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Material Planner training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum of Material Planner Training *** Here is the curriculum breakdown of this course: Module 01: Introduction to Material Management Module 02: Purchasing and Supply Chain Management Module03: Inventory Management, Planning, and Control Module04: Stores Management and Control Module05: Forecasting Module06: Materials Handling Module 07: Material Requirements Planning Module08: Operations Management Module09: Business Development and Succession Planning Module10- Business Process Management Module11: Planning & Forecasting Operations Assessment Process Once you have completed all the modules in the Material Planner course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Material Planner course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Material Planner course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Description Take your steps towards learning the advanced concepts of SQL by taking this SQL Developer 2014 Advanced. Through the course, you will master SQL skills and be able to take full command of SQL. You will learn to create materialised views and improve performance by using simple SQL syntax. Learn about partition the tables and performance optimisation using SQL partitioning and explore how to use analytic SQL to aggregate, analyse and report, and model data using the SQL analytic capabilities. You will also learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure by practising SQL Hierarchical features. Use of regular expressions and sub-expressions to search, match and replace strings using SQL built-in functions also explained in this course. Step up to the next level to learn more about the advanced SQL theories which will put you better in your performance and career advancement. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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. 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 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. Module: 01 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 02 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 03 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 04 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00 Order Your 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 There are different methods to draw diagrams, and shape in the world. But, you are in dilemma that which path you should choose. You even don't know which course will be more suitable for you. Don't worry. You can see the MS Visio 2016 Introduction course. Hope you will get an approximate solution from this course. MS Visio is a part of MS Office that deals with the concept of drawing shapes and diagrams by using templates and stencils. The purpose of the course is to make you effective in drawing diagrams, shapes, compound lines, and arrangement of the object providing you with the basic concepts of different patterns and templates. The course teaches you how to construct figures, play with text, simply formatting, create organization charts, place shape properties, and work with pages. In the end, students will come to confirm a document knowing the fact how to save and print it. 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 Visio 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 Visio 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 Understanding the Visio Environment Understanding the Visio Environment 00:05:00 Using the Backstage View 00:04:00 Using the Home Tab 00:05:00 Using the Insert and Design Tabs 00:03:00 Using the Data and Process Tabs 00:03:00 Using the Review and View Tabs 00:03:00 Using The Shapes Pane 00:04:00 Controlling Window Layout 00:03:00 Creating Diagrams Using Diagram Templates 00:07:00 Inserting Shapes 00:07:00 Manipulating Shapes 00:08:00 Using the Size & Position Window 00:08:00 Using the Pan and Zoom Window 00:04:00 Using the Shape Data Window 00:03:00 Adding Text 00:05:00 Formatting Text 00:04:00 Changing Shape Stacking 00:04:00 Formatting a Diagram Grouping Objects 00:05:00 Aligning and Distributing Objects 00:05:00 Formatting Objects 00:06:00 Applying Themes and Backgrounds 00:04:00 Applying Borders and Titles 00:03:00 Adding Pages 00:03:00 Working with Background Pages 00:04:00 Creating an Organization Chart Creating an Organization Chart 00:04:00 Using Org Chart Shapes 00:05:00 Using Org Chart Layout Options 00:04:00 Splitting and Synchronizing an Organization Chart 00:04:00 Using the Org Chart Tab 00:03:00 Using the Organization Chart Wizard 00:06:00 Creating a Flow Chart Creating a Flow Chart 00:03:00 Inserting and Connecting Flow Chart Shapes 00:07:00 Using Additional Connectors 00:04:00 Creating a Cross Functional Flow Chart 00:05:00 Creating an Office Layout Creating an Office Layout 00:04:00 Creating the Room 00:06:00 Adding Windows and Doors 00:04:00 Adding Furniture 00:03:00 Finalizing Documents Finalizing Visio Drawings 00:03:00 Sharing Visio Drawings 00:02:00 Saving Visio Drawings 00:02:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Be an expert in MS SharePoint knowing the key issues of this app from the MS SharePoint 2016 Site User course. The course can solve your different problems in MS SharePoint and make you an efficient in this field.   The MS SharePoint 2016 Site User course incorporates some effective methods of SharePoint interface and functions to teach the students easily. The course assists the students to know how to identify sites, run libraries and lists, and work with library documents. The course enables them to know about library setting incorporating the ideas of alert, check in and out of documents, and creation of calendar list, contact lists, and task list along with the relevant work of list setting. The purpose of the course is to enhance the SharePoint expertise knowing the fact of different views, use of newsfeed, and other MS office products. 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 SharePoint 2016 Site User 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 SharePoint 2016 Site User 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 SharePoint Overview SharePoint Overview 00:04:00 Accessing SharePoint Sites 00:02:00 Sharepoint Interface and Navigation 00:08:00 Using the Open Menu 00:02:00 Using the Details Pane 00:01:00 Overview of SharePoint Permissions for Site Users 00:05:00 Locating Sites, Libraries, and Lists 00:04:00 Searching for SharePoint Content 00:04:00 Working with Document Libraries SharePoint Library Overview 00:04:00 Viewing and Downloading a Document from a Library 00:03:00 Uploading Items to a Document Library 00:03:00 Syncing a Library 00:03:00 Creating and Saving New Documents 00:04:00 Editing a Document 00:03:00 Creating a New Folder 00:03:00 Uploading and Moving Document into a Folder 00:01:00 Moving Document to Another Library 00:01:00 Pin to Top 00:02:00 Renaming Documents or Folders 00:02:00 Deleting Documents or Folders 00:02:00 Restoring a Document from the Recycle 00:02:00 Working with Document Library Settings Viewing Permissions for a Document 00:03:00 Version History Overview 00:03:00 Viewing, Comparing, and Restoring Prior Document Versions 00:04:00 Check In or Check Out Overview 00:03:00 Checking Out or Checking In a Document 00:03:00 Editing a Document with Check In or Check Out Enabled 00:03:00 Uploading a File to a Library with Check In or Check Out Enabled 00:02:00 Discarding a Check Out 00:02:00 Setting an Alert on a Document 00:03:00 Setting an Alert on a Library 00:03:00 Modifying or Deleting Alert Subscriptions 00:03:00 Changing View Column Settings 00:03:00 Sorting and Filtering Library Content 00:03:00 Sharing Links Including Durable Links 00:04:00 Working with Properties 00:02:00 Adding and Editing Properties 00:03:00 Adding and Editing Properties while Editing in Office 00:02:00 Narrowing a Document Search Result by Properties 00:02:00 Working with SharePoint Lists SharePoint List Overview 00:03:00 Adding an Item to a List 00:02:00 Adding an Item to a Contact List 00:01:00 Adding an Item to a Calendar 00:02:00 Creating a Recurring Calendar Event 00:02:00 Adding an Item to a Task List 00:03:00 Adding an Item to a Links List 00:02:00 Adding an Announcement 00:03:00 Attaching Content to an Announcement 00:04:00 Editing or Deleting a List Item 00:02:00 Editing or Deleting a Contact 00:02:00 Editing or Deleting a Calendar Event 00:04:00 Editing or Deleting a Task 00:03:00 Editing or Deleting an Announcement 00:02:00 Editing or Deleting a Link 00:01:00 Working with List Settings Adding and Editing Items Using Quick Edit 00:04:00 Sorting and Filtering List Items 00:03:00 Copying and Pasting Excel Info into a List 00:03:00 Exporting List Data into Excel 00:03:00 Creating an Alert for a List Item 00:03:00 Creating an Alert for a List 00:04:00 Enhancing the SharePoint Experience Working with Library or List Views 00:05:00 Creating Public or Personal Standard Views 00:10:00 Using Task Views 00:04:00 Creating a Views 00:04:00 Modifying or Deleting a View 00:04:00 Creating a Grouped View 00:06:00 Creating a Datasheet View 00:03:00 Creating a View to Display Items without Folders 00:03:00 Creating a View to Display Items Checked Out to Me 00:04:00 Sharing Documents and Sites 00:03:00 Coauthoring 00:02:00 Integration with Microsoft Office Integration with Office Online 00:03:00 Checking In or Checking Out Documents via Microsoft Office 00:02:00 Accessing and Uploading Properties from Microsoft Office 00:02:00 Accessing Prior Versions from Microsoft Office 00:02:00 Saving a Document to SharePoint from Microsoft Office 00:03:00 Syncing a Calendar to Outlook 00:02:00 Syncing a Library To Outlook 00:02:00 Integration with Office 365 00:04:00 Personal Profile and Newsfeed Updating Your Profile 00:04:00 Following Sites 00:03:00 OneDrive Overview 00:03:00 Uploading Documents to OneDrive 00:02:00 Sharing Content in OneDrive 00:04:00 Newsfeed Overview 00:06:00 Creating a Blog 00:04:00 Editing and Replying to Blogs 00:03:00 Conclusion Course Recap 00:01:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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