3017 Link courses in Cardiff delivered Online

Description: Sales and selling management are essential especially in the business and corporate setting. Sales skills are the ability to create products and services that are needed for the clients. Selling or marketing is the skill on how to make your products and services marketable. Learning these skills will help you develop your management skills that are essential for the success of your business. Learning how to manage sales, sales analysis, and the techniques for business strategies will help you acquire these skills which we will be provided through this course. Who is the course for? Business or corporate professionals, who work in for the sales and marketing department People who are interested in learning more about sales and selling management 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 you have successfully passed the test, 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 hard copy 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 recognised 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: This Management Course on Sales and Selling is a useful qualification to possess and would be beneficial for the following careers: Businessmen Business Development Officer Entrepreneur Marketing Manager Promotions Expert Sales Specialist Strategist. Managing Sales Sales Management- Part 1 01:00:00 Sales Management- Part 2 01:00:00 Sales Management- Part 3 01:00:00 Sales Management- part 4 01:00:00 Sales Management- Part 5 01:00:00 Sales Management- Part 6 01:00:00 Sales Management- Part 7 01:00:00 Sales Analysis What Is A Sales Funnel? 00:30:00 What is Internet Commerce? 00:30:00 What Can I Sell 00:30:00 ClickBank 00:30:00 Drop Shipping 00:30:00 Affiliate Marketing 00:30:00 The Link Between Products, Key Words and Prospects 00:15:00 The Front-end and Back-end of Sales Funnels 00:30:00 Sales Funnel Success 00:30:00 Sales Funnel Planning 00:30:00 Putting Your Theory to Practice 00:30:00 Content Marketing 00:30:00 Article Marketing 00:30:00 Google's Adwords Program 00:30:00 Marketing Offline 00:30:00 Blogs 00:30:00 Social Media 00:30:00 Auto Responders 00:30:00 The Joint Venture 00:30:00 Measuring Success 00:30:00 Top Sales Funnel Products 00:30:00 Relationship in Sales Focusing on Your Customer 00:15:00 What Influences People in Forming Relationships? 00:30:00 Disclosure 00:15:00 How to Win Friends and Influence People 00:15:00 Communication Skills for Relationship Selling 01:00:00 Non-Verbal Messages 00:30:00 The Handshake 00:30:00 Small Talk 00:15:00 Networking 00:15:00 Sales Technique Fundamental Sales Techniques 01:00:00 Extensive Sales Techniques 01:30:00 Sales Strategies Selling Skills 00:15:00 The Sales Cycle 00:30:00 Framing Success 00:15:00 Setting Goals with SPIRIT! 00:15:00 The Path to Efficiency 00:15:00 Customer Service 00:15:00 Selling More 00:15:00 Selling Price 00:15:00 Mock Exam Mock Exam- Management Course on Sales and Selling 00:30:00 Final Exam Final Exam- Management Course on Sales and Selling 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

An online self-paced introduction to 'space syntax' and a networked understanding of urban space

Become an invaluable asset to your company's future and take charge of its finances almost immediately by learning to use Sage software. Sage 50 Payroll is today's trusted benchmark in money handling, and we can train you to use it without any prior experience. No matter whether you are staring as an accountant in a large company, or having to pay salaries in a private firm, this learning experience can take your career and business to the next level. By taking our intensive course, specifically designed by experts to educate beginners, you'll soon be setting up complex routines and reports involving basic salary details and tax codes. Not only that, but you will also be able to quickly produce and retrieve professional records, useful historical reports, and critical employee information. You will be given everything you'll need to hit the money-managing ground running and make a name for yourself as a person that can solve any payroll difficulties that your organisation may experience. No prior knowledge of Sage or accounting is needed for this learning experience, just the desire to learn. Sage 50 Payroll for Beginners Become skilled with setting up the basics of a payroll infrastructure and link it safely to company accounts Learn all the necessary legislation for business accounting and ensure all necessary administration is performed Gain the ability to change employee details in the company's database effortlessly. Become utterly comfortable with the process of applying key updates and crucial changes to payroll information. Know how to build and maintain pension schemes for all members of the company staff. Exhibit full confidence and skill in the regular housekeeping of an organisation's payroll structure. Have the enviable skill to produce accurate reports concerning any data for finance and employee statistics. Become fully prepared to deal with complex time-driven events like Christmas and the end of the financial year 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 the MCQ assessment, you will qualify for the CPD Certificate from Studyhub, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15. Who is This course for? This course is ideally suited for ambitious individuals who are just starting in finance and administration for a high-performing organisation. It may also be beneficial as a useful introduction to Sage 50 Payroll for established accountants or consultants, or as a recommended step for those looking for associated work in the business sector. Requirements Our Sage 50 Payroll for Beginners 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.  Career Path The education offered by the Sage 50 Payroll for Beginners course will benefit anybody who is just starting to work with the accounting software or is planning to do so. This will help any individual with the following roles: Office Administrators Accountants Payroll Managers HR staff Financial Consultants Course Curriculum Module 1: Payroll Basics Payroll Basics 00:10:00 Module 2: Company Settings Company Settings 00:08:00 Module 3: Legislation Settings Legislation Settings 00:07:00 Module 4: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 5: Pay Elements Pay Elements 00:14:00 Module 6: The Processing Date The Processing Date 00:07:00 Module 7: Adding Existing Employees Adding Existing Employees 00:08:00 Module 8: Adding New Employees Adding New Employees 00:12:00 Module 9: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 10: Entering Payments Entering Payments 00:12:00 Module 11: Pre-Update Reports Pre-Update Reports 00:09:00 Module 12: Updating Records Updating Records 00:09:00 Module 13: e-Submissions Basics e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) Process Payroll (November) 00:16:00 Module 15: Employee Records and Reports Employee Records and Reports 00:13:00 Module 16: Editing Employee Records Editing Employee Records 00:07:00 Module 17: Process Payroll (December) Process Payroll (December) 00:12:00 Module 18: Resetting Payments Resetting Payments 00:05:00 Module 19: Quick SSP Quick SSP 00:09:00 Module 20: An Employee Leaves An Employee Leaves 00:13:00 Module 21: Final Payroll Run Final Payroll Run 00:07:00 Module 22: Reports and Historical Data Reports and Historical Data 00:08:00 Module 23: Year-End Procedures Year-End Procedures 00:09:00 Mock Exam Mock Exam - Payroll 00:20:00 Final Exam Final Exam - Payroll 00:20:00

Free online MS Awareness training session for social prescribing services

This is a 4-day course where students will be exploring sci-fi stories. 🚀 👽 The children will be analysing engaging sci-fi stories and discussing characters, settings and plots. 👽 Students will also create their own imaginative sci-fi settings, and design their own alien! It will be a fantastic opportunity for children to build their confidence and skills in writing, all while having fun! Please note: this course is for 4 days and will take place on the following days: Saturday 21st December at 10am UK / 2pm UAE/ 6pm HK Monday 23rd December at 12pm UK / 4pm UAE/ 8pm HK Tuesday 24th December at 11am UK / 3pm UAE/ 7pm HK Friday 27th December at 10am UK / 2pm UAE/6pm HK If you cannot attend a lesson for any reason, Mollie will record it and send you a link to watch the session via the Zoom cloud. 

Duration 2 Days 12 CPD hours This course is intended for Anyone who works with IBM SPSS Statistics and wants to learn advanced statistical procedures to be able to better answer research questions. Overview Introduction to advanced statistical analysis Group variables: Factor Analysis and Principal Components Analysis Group similar cases: Cluster Analysis Predict categorical targets with Nearest Neighbor Analysis Predict categorical targets with Discriminant Analysis Predict categorical targets with Logistic Regression Predict categorical targets with Decision Trees Introduction to Survival Analysis Introduction to Generalized Linear Models Introduction to Linear Mixed Models This course provides an application-oriented introduction to advanced statistical methods available in IBM SPSS Statistics. Students will review a variety of advanced statistical techniques and discuss situations in which each technique would be used, the assumptions made by each method, how to set up the analysis, and how to interpret the results. This includes a broad range of techniques for predicting variables, as well as methods to cluster variables and cases. Introduction to advanced statistical analysis Taxonomy of models Overview of supervised models Overview of models to create natural groupings Group variables: Factor Analysis and Principal Components Analysis Factor Analysis basics Principal Components basics Assumptions of Factor Analysis Key issues in Factor Analysis Improve the interpretability Use Factor and component scores Group similar cases: Cluster Analysis Cluster Analysis basics Key issues in Cluster Analysis K-Means Cluster Analysis Assumptions of K-Means Cluster Analysis TwoStep Cluster Analysis Assumptions of TwoStep Cluster Analysis Predict categorical targets with Nearest Neighbor Analysis Nearest Neighbor Analysis basics Key issues in Nearest Neighbor Analysis Assess model fit Predict categorical targets with Discriminant Analysis Discriminant Analysis basics The Discriminant Analysis model Core concepts of Discriminant Analysis Classification of cases Assumptions of Discriminant Analysis Validate the solution Predict categorical targets with Logistic Regression Binary Logistic Regression basics The Binary Logistic Regression model Multinomial Logistic Regression basics Assumptions of Logistic Regression procedures Testing hypotheses Predict categorical targets with Decision Trees Decision Trees basics Validate the solution Explore CHAID Explore CRT Comparing Decision Trees methods Introduction to Survival Analysis Survival Analysis basics Kaplan-Meier Analysis Assumptions of Kaplan-Meier Analysis Cox Regression Assumptions of Cox Regression Introduction to Generalized Linear Models Generalized Linear Models basics Available distributions Available link functions Introduction to Linear Mixed Models Linear Mixed Models basics Hierachical Linear Models Modeling strategy Assumptions of Linear Mixed Models Additional course details: Nexus Humans 0G09A IBM Advanced Statistical Analysis Using IBM SPSS Statistics (v25) 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 0G09A IBM Advanced Statistical Analysis Using IBM SPSS Statistics (v25) 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.

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 Learn How To Create a Web App for iPad 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 professional training that employers are looking for in today's workplaces. The Learn How To Create a Web App for iPad Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Learn How To Create a Web App for iPad 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 Learn How To Create a Web App for iPad Course, like every one of Study Hub'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 StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Learn How To Create a Web App for iPad? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Learn How To Create a Web App for iPad 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn How To Create a Web App for iPad 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 skill. Prerequisites This Learn How To Create a Web App for iPad does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn How To Create a Web App for iPad was made by professionals and it is compatible with all PC's, Mac's, 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 bonus, you will be able to pursue multiple occupations. This Learn How To Create a Web App for iPad is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction About the Course 00:01:00 A Few Words before we Begin 00:02:00 Software You'll Need to Follow along 00:02:00 About the Project Files 00:02:00 Starting Your Project 00:01:00 Section 02: Creating the Graphics Creating the Web App-Specific Graphics for iPad 00:06:00 Creating the Content Graphics 00:05:00 Creating the Gallery Images 00:01:00 Section 03: Setting Up the HTML Examining the HTML and CSS Strategy for the Layout 00:03:00 Setting Up the Meta Tags and Icon Link 00:07:00 Setting Up the HTML Containers 00:04:00 Adding Container for iScroll and Google Map 00:03:00 Add Navigation Links and Copyright 00:03:00 Section 04: Add Style & Layout for Homepage and Navigation Add CSS Rules for Style and Layout 00:14:00 Add Homepage Positioning and Animation for Elements 00:06:00 Style the Navigation Links and Copyright 00:04:00 Section 05: Adding the Java Script and (jQuery) Detecting the Orientation of the iPad 00:10:00 Loading Page Contents with AJAX 00:15:00 Detecting the Home Page 00:04:00 Detecting the Contact us Page 00:06:00 Setting and Loading a Default Page on Load 00:05:00 Initializing Google Maps 00:04:00 Activating iScroll 00:05:00 Section 06: Adding Content for the Gallery and Video Pages Adding HTML for the Gallery 00:05:00 Adding CSS Rules for the Gallery 00:05:00 Activating the Gallery Thumbnails 00:10:00 Adding a Graphic and Video 00:05:00 Detecting and Replacing Graphics for Retina Displays 00:05:00 Section 07: Detecting iPads and Stand Alone Status Detecting an iPad 00:07:00 Detecting the Stand-alone Status 00:04:00 Replacing Click Events and Disabling Selections 00:05:00 Section 08: Where to Go from Here Where to Go from Here 00:02:00 Considering Web Apps for Android 00:01:00 Assignment Assignment - Learn How To Create a Web App for iPad 00:00:00

Thinking about learning more understanding the role of data within an organisation? As data becomes an important currency in the world and an enabler for the future, it is imperative that all organisations have a firm understanding of the data available to them and the power it can hold. The BCS Foundation Award in Understanding Data in your Organisation teaches the the terminology, principles, concepts and approaches used within data management, and the overall value of data to an organisation.

Overview This comprehensive course on 3D Humanoid Characters in Unity will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 3D Humanoid Characters in Unity comes with accredited certification from CPD, 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 3D Humanoid Characters in Unity. It is available to all students, of all academic backgrounds. Requirements Our 3D Humanoid Characters in Unity is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 74 lectures • 06:21:00 total length •Welcome: 00:01:00 •Using Autodesk's Character Generator: 00:09:00 •Creating characters with Adobe Fuse: 00:08:00 •Auto-rigging with Adobe Mixamo: 00:03:00 •Applying animation to rigged characters in Mixamo: 00:03:00 •Importing an Autodesk character into Adobe Mixamo: 00:02:00 •Selecting and animating a fantasy character within Mixamo: 00:04:00 •Exploring commercial rigged and animated characters: 00:03:00 •Using Unity Hub to install the Unity Editor: 00:06:00 •Configuring Unity's user interface: 00:04:00 •Importing and setting up an architectural model: 00:07:00 •Importing selected standard assets: 00:05:00 •Rendering lightmap data for static objects: 00:05:00 •Configuring packages: 00:03:00 •Creating Cinemachine virtual cameras: 00:08:00 •Importing a character into Unity: 00:06:00 •Combining texture maps in Photoshop: 00:09:00 •Shaders and render modes for eyes and eyelashes: 00:05:00 •Configuring hair material and texture maps: 00:05:00 •Combining textures with alpha channel using Gimp: 00:05:00 •Exploring an avatar's bones and muscles: 00:05:00 •Referencing a controller in the animator component: 00:07:00 •Controlling the character with scripts and components: 00:07:00 •Altering code to make the character walk by default: 00:06:00 •Altering the script to walk and not run diagonally: 00:05:00 •Set up Cinemachine FreeLook camera: 00:03:00 •Fine-tune free look rigs: 00:07:00 •Replacing animations in controller: 00:07:00 •Integrating a death animation into controller: 00:07:00 •Scripting death by falling: 00:05:00 •Walking upstairs using colliders from hidden ramps: 00:05:00 •Bringing in a new character: 00:04:00 •Designing a third person player game object: 00:06:00 •Connecting FreeLook camera to third person player: 00:03:00 •Swapping out characters within the third person player: 00:03:00 •Using legacy characters: 00:06:00 •Using high quality commercial characters: 00:07:00 •Making character prefabs and overrides: 00:06:00 •Using the Cinemachine collider extension: 00:06:00 •Setting up post-processing and anti-aliasing: 00:04:00 •Configuring post-processing effects: 00:06:00 •Commercial animated stationary characters: 00:08:00 •Custom animated stationary characters: 00:06:00 •Providing seating for an animated character: 00:04:00 •Cropping an animation on humanoid rig: 00:06:00 •Bring in a new character to be driven by Ai: 00:04:00 •Configuring components on Ai character: 00:04:00 •Building and refining the nav mesh: 00:05:00 •Getting agents to climb stairs: 00:03:00 •Creating off-mesh links: 00:03:00 •Making nav mesh obstacles: 00:06:00 •Implementing high-cost areas for the Ai: 00:06:00 •Abstracting NPC for use with other skins & avatars: 00:06:00 •Outlining the goal of the game: 00:03:00 •Getting the NPC to chase the Player: 00:03:00 •Getting a hold of the Player's Animator through code: 00:08:00 •Logging NPC's collision with Player to console: 00:06:00 •Stopping the NPC and killing the Player: 00:07:00 •Offsetting the death animation: 00:03:00 •Allowing NPC to take leap with off-mesh link: 00:07:00 •Adding user interface with canvases and buttons: 00:09:00 •Toggling defeat canvas on when NPC collides with Player: 00:04:00 •Differentiating between victory and defeat in code: 00:09:00 •Refining the NavMesh for fluid Ai movement: 00:03:00 •Building a GameManager class and game object: 00:08:00 •Connecting Restart buttons to setting bool Property true: 00:05:00 •Connecting controller and testing in game: 00:01:00 •Mapping the Fire2 axis to run: 00:07:00 •Mapping the Fire1 axis to crouch: 00:05:00 •Mapping analogue stick to Cinemachine FreeLook camera: 00:05:00 •Fine tuning how analog game stick controls camera: 00:05:00 •Building and playing standalone game: 00:05:00 •Bonus: 00:01:00 •Assignment - 3D Humanoid Characters in Unity: 00:00:00

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports 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? Level 3 Diploma in Microsoft Excel 2016 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 Level 3 Diploma in Microsoft Excel 2016 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. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00