712 Courses delivered Online

Discover the crucial role of an Internal Compliance Auditor in ensuring organizational adherence to industry regulations and internal policies. Explore how these professionals conduct meticulous reviews, implement corrective measures, and contribute to a robust compliance framework for sustained business integrity. Elevate your understanding of the key responsibilities and skills required for this pivotal position.

Dive into the intricate world of numbers and data with our comprehensive 'Microsoft Excel & Accounting Training' course. Begin your journey by mastering the foundational elements of Microsoft Office Excel 2016, from the basics of worksheet modifications to the art of data visualisation using charts. As you progress, pivot your attention towards the meticulous realm of accounting. Here, you'll unravel the secrets of the accounting equation, immerse yourself in transaction analyses, and culminate your learning by understanding the complete accounting cycle. Whether you're looking to enhance your data management skills or embark on a career in accounting, this course is your stepping stone to success. Learning Outcomes: Acquire proficiency in utilising Microsoft Excel 2016 for data analysis, visualisation, and workbook management. Understand the core principles of accounting, including the accounting equation and transaction analysis. Demonstrate the ability to prepare financial statements and complete the accounting cycle. Implement advanced Excel features such as PivotTables, PivotCharts, and Lookup Functions. Apply knowledge in real-world scenarios, including fiscal year evaluations and spreadsheet exercises. Why buy this Microsoft Excel & Accounting Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Microsoft Excel & Accounting Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Microsoft Excel & Accounting Training course for? Individuals aiming to bolster their data analysis and management capabilities. Aspiring accountants keen on understanding the fundamentals of the profession. Business owners desiring a deeper grasp of financial statements and accounting cycles. Students pursuing a career in finance or data management. Professionals looking to integrate Excel functionalities into their daily tasks. Career path Data Analyst: Average salary range: £25,000 - £40,000 Annually Accountant: Average salary range: £28,000 - £52,000 Annually Financial Controller: Average salary range: £40,000 - £70,000 Annually Management Accountant: Average salary range: £30,000 - £55,000 Annually Excel Specialist: Average salary range: £22,000 - £35,000 Annually Bookkeeper: Average salary range: £18,000 - £30,000 Annually Prerequisites This Microsoft Excel & Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel & Accounting Training 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum **Microsoft Excel** Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interfact 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:07:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:16:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 **Accounting Training** Professional Bookkeeper Introduction Professional Bookkeeper 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Account 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00

Administrative management focuses on needs of administrative procedures and using the right tools and techniques in the workplace. [course_titile] is originated for you to carry out administrative tasks to a professional standard. The course begins with by explaining the code of conduct as well as setting the tone in the workplace. Operating an office requires exceptional effort and management skills. Initially, this course is intended to prepare you to handle bullying in the workplace, conflict management and different types of conflict that often occur, necessary steps to avoid and overcome conflict, getting along in the workplace effectively as well. You will be able to create a positive work environment through communication and negotiation. In the course, you will get a clear understanding of closing the generation gap, ergonomics injury prevention, and eliminate workplace violence. Following that, you will learn about workplace harassment and things to do if you become a victim of it. Enroll now and get the most out of this course. Learning Outcomes: Identify what a code of conduct is and why a business should have one Identify what goes into a code of conduct Discuss how to implement a code of conduct in the workplace Create a code of conduct for a business Allot a definition about bullying of what it is and what not Realise the cost of bullying either to organisations nor to people Recognise behaviours associated with bullying as well as the factors behind them Learn some means to shut bullying and realise the roles you can play Acquire the knowledge of some routes to handle yourself from bullying Learn what you should do when encountered with bullying Figure out proper solutions to a bullying event (either within or outside the organisation) Be able to assist in creating an anti-bullying policy Become able to help generate an anti-bullying policy Identify how a positive workplace appears Get information and realise the major components suited to produce and sustain a positive work atmosphere Realise the role of an employee to generate your individual activities to manage a positive work environment Understand as a leader the responsibility you have to create and maintain a positive work environment Figure out Discover what type of team player you are and how that relates to your functioning in the team Know the importance of effective workplace relationships in creating and maintaining a positive work environment Know and understand the importance of working as a team and guidelines to good teamwork Discover your personal strengths and weaknesses in working cooperatively Discover your preference for dealing with workplace conflict Allot a definition to ergonomics and the terms it include Recognise from where you can get ergonomics information for your area Locate the ways ergonomics could be incorporated for your workplace Evaluate the environment for ergonomic risks, learn to open ways so as to solve the issues, as well as planning for their application. Recheck along with assessing your ergonomic endeavor Apply the change management technique proficiently Relate the fundamental principles linked to ergonomics Get to know outlining ergonomic practices to sit, stand, lift, carry, push, as well as to pull Make designs for an ergonomic workstation Recognise the crucial ergonomic features of tools as well as machines Interpret the role of the environmental factors for example, (sound, air quality, as well as light) play in ergonomics 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? Complete Workplace Administration 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 Complete Workplace Administration 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 What is it, and why? 00:15:00 What to leave in, what to leave out 00:15:00 What's it all about? 00:15:00 A Random Sample 00:30:00 What to Do When You Make a Mistake 00:15:00 Auditing 00:30:00 Putting it Together 00:15:00 Module : 2 Defining Bullying 00:15:00 Why Bullies Do What They Do 00:15:00 Building a Shield Against Bullies 00:15:00 What to Do If It Happens to You 00:30:00 What to Do If You Witness Bullying 00:15:00 Creating an Anti-Bullying Workplace 00:15:00 The Law on Bullying 00:15:00 Module : 3 Defining Conflict 00:15:00 Types of Conflict 00:15:00 Open Conflict vs. Hidden Conflict 00:15:00 Spontaneous and Reflective Behavior 00:15:00 The Johari Window 00:15:00 Stages of Conflict 01:00:00 Conflict Resolution Style Questionnaire 00:15:00 The Role of Communication in Conflict Resolution 00:30:00 Active Listening Skills 00:15:00 Paraphrasing Skills 00:15:00 Powerful Questions 00:15:00 Body Language 00:15:00 The Conflict/Opportunity Test 00:15:00 Conflict and Its Resolution 00:30:00 Helping Others Through Conflict 00:45:00 Module : 4 What Does a Positive Environment Look Like? 00:30:00 What Can I Do? 00:30:00 Team Player 00:15:00 Effective Workplace Relationships (I) 00:45:00 Effective Workplace Relationships (II) 00:30:00 Module : 5 The Case for Wellness 00:15:00 Building the Foundation 00:30:00 Gathering Support 00:15:00 Gathering Data 00:30:00 Performing a Needs Analysis 00:15:00 Implementing Your Workplace Wellness Program 00:15:00 Reviewing the Plan 00:15:00 Evaluating and Reporting Results 00:15:00 Module : 6 Getting Started 00:30:00 The Role of Ergonomics in Your Workplace 00:15:00 The Ergonomic Assessment Cycle 00:05:00 Identifying and Assessing Ergonomic Hazards 00:30:00 Developing a Plan to Address Ergonomic Issues 00:15:00 Identifying and Implementing Solutions 00:15:00 Obtaining Employee Buy-In 00:15:00 Tips for Successful Implementation 00:15:00 Reviewing Your Ergonomics Program 00:15:00 Basic Ergonomic Principles 00:15:00 Optimal Sitting and Standing 00:15:00 Safe Lifting and Transporting 00:15:00 Ergonomic Workstations 00:15:00 Safe Tool Selection and Use 00:15:00 Creating an Ergonomic Environment 00:30:00 Module : 7 What is Workplace Violence? 00:15:00 Understanding the Behavior Wheel 00:15:00 The Anger Management Process 00:30:00 Communicating Better 00:15:00 Basic Problem Solving Tools 01:00:00 Other Ways of Managing Anger 00:15:00 A Systems Approach 00:15:00 Developing a Policy and Program 00:15:00 Risk Assessment 00:30:00 Hiring Practices 00:15:00 Workplace Practices and Procedures 00:15:00 Security Systems and Personnel 00:15:00 Training Programs 00:15:00 Developing Emergency Response Plans 00:15:00 Program Review 00:15:00 The Immediate Response 00:15:00 Consulting with the Experts 00:15:00 Gathering Additional Information 00:15:00 Re-Evaluating Information 00:15:00 Communicating Incidents and Threats 00:15:00 Interviewing Employees 00:15:00 Risk Level Analysis 00:15:00 Reviewing the Options 00:15:00 Analyzing the Impact 00:15:00 Process Application 00:15:00 Module : 8 Defining Harassment 00:15:00 Defining Sexual Harassment 00:30:00 The Purpose of Training 00:15:00 Creating a Harassment Policy 00:30:00 Nipping it in the Bud 00:15:00 Protecting Yourself 00:15:00 What If It Happens to Me? 00:30:00 What If It's Happening to Someone Else? 00:15:00 Someone Has Filed a Complaint Against Me! 00:30:00 Addressing a Complaint 00:15:00 Handling False Complaints 00:15:00 Mediation 00:45:00 Investigating a Complaint 00:45:00 Making the Decision 00:15:00 Creating Solutions 00:15:00 After It's Over 00:15:00 Skill Application 00:15:00

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? 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 Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 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 Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management 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 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Database Designers Support Engineer Technical Administrator Overview Back up, restore, and patch DBCS database deployments Describe the DBaaS and on-premises Oracle Database architectures Manage database instances Manage UNDO data Move data between databases Implement basic backup and recovery procedures Monitor and tune database performance Tune SQL to improve performance Manage resources with Oracle Database Resource Manager Create pluggable databases (PDBs) Configure the Oracle network environment Administer user security and implement auditing Create and manage tablespaces Manage storage space Create and manage Database as a Cloud Service (DBCS) database deployments Register databases and manage performance with Enterprise Manager Cloud Control The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Exploring Oracle Database Architecture Introducing Oracle Database Relation Database Models Oracle SQL and PL/SQL Oracle Database Server Architecture Connecting to Oracle Databases Oracle Database Tools Oracle-Supplied User Accounts Querying the Oracle Data Dictionary Managing Database Instances Initialization Parameter Files Starting Up Oracle Databases Shutting Down Oracle Databases Opening and Closing PDBs Working with the Automatic Diagnostic Repository (ADR) Querying Dynamic Performance Views Creating PDBs Methods and Tools to Create PDBs Creating PDBs from Seed with SQL*Plus Cloning PDBs with SQL*Plus Unplugging and Pluggin In PDBs with SQL*Plus Dropping PDBs with SQL*Plus Configuring the Oracle Network Environment Oracle Net Services How Listeners Work Configuring Listeners for Dynamic Service Registration Configuring Listeners for Static Service Registration Configuring Local Naming for Connections Testing Oracle Net Connectivity with tnsping Configuring Communication Between Databases Dedicated Versus Shared Server Configurations Administering User Security Creating Users Granting Privileges Creating and Granting Roles Revoking Privileges and Roles Creating and Assigning Profiles Authenticating Users Assigning Quotas to Users Applying the Principal of Least Privilege Creating and Managing Tablespaces How Table Data is Stored Creating Tablespaces in SQL*Plus Altering and Dropping Tablespaces in SQL*Plus Viewing Tablespace Information in SQL*Plus Implementing Oracle Managed Files Moving and Renaming Online Data Files in SQL*Plus Managing Storage Space Oracle Database Space Management Features Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Understanding Deferred Segment Creation Space-Saving Features Managing UNDO Data Undo Data: Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Local Undo Mode Versus Shared Undo Mode Configuring Undo Retention Categories of Undo Moving Data Moving Data: General Architecture Oracle Data Pump: Overview Oracle Data Pump: Benefits Data Pump Export and Import Clients Data Pump Utility: Interfaces and Modes Data Pump Import: Transformations SQL*Loader Overview Loading Methods Backup and Recovery Concepts DBA Responsibilities Categories of Failure Understanding Instance Recovery Understanding Types of Backups Comparing Complete and Incomplete Recovery Oracle Data Protection Solutions Flashback Technology Monitoring and Tuning Database Performance Managing Performance Activities Performance Planning Considerations Database Maintenance Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor Performance Monitoring Performance Tuning Methodology Database Server Statistics and Metrics SQL Tuning SQL Tuning Process Oracle Optimizer Optimizer Statistics SQL Plan Directives Adaptive Execution Plans SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Oracle Database Resource Manager Oracle Database Resource Manager: Overview Resource Manager Elements Using Resource Manager to Allocate Resources Creating a Simple Resource Plan Creating a Complex Resource Plan Using the Active Session Pool Feature Limiting CPU Utilization at the Database Level Limiting CPU Utilization at the Server Level Enterprise Manager Cloud Control Controlling the Enterprise Manager Cloud Control Framework Starting the Enterprise Manager Cloud Control Framework Stopping the Enterprise Manager Cloud Control Framework Introduction to Oracle Database Cloud Service Oracle Cloud: Overview Database Cloud Service Offerings DBCS Architecture Features and Tooling Additional Database Configuration Options Creating DBCS Database Deployments Automated Database Provisioning Creating a Database Deployment How SSH Key Pairs are Used Creating an SSH Key Pair Storage Used for Database Files Managing DBCS Database Deployments Cloud Tooling Accessing Tools and Features from the DBCS Console Managing the Compute Node Associated With a Database Deployment Managing Network Access to DBCS Enabling Access to a Compute Node Port Scaling a Database Deployment Backing Up and Restoring DBCS Database Deployments Backing Up and Recovering Databases on DBCS Backup Destination Choices Backup Configuration Creating an On-Demand Backup Customizing the Backup Configuration Performing Recovery by Using the Console Performing Recovery by Using the dbaascli Utility Patching DBCS Database Deployments Patching DBCS Using the DBCS Console to Manage Patches Using the dbaascli Utility to Manage Patches Creating Master Encryption Keys for PDBs CDB and PDB Master Encryption Keys Determining Whether You Need to Create and Activate and Encryption Key for a PDB Creating and Activating an Encryption Key Tablespace Encryption by Default Tablespace Encryption by Default in DBCS Transparent Data Encryption (TDE) Overview Components of TDE Using TDE Defining the Keystore Location Controlling Tablespace Encryption by Default Managing the Software Keystore and Master Encryption Key Managing the Keystore in CDBs and PDBs Additional course details: Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 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 Oracle Database 12c R2 - Administration Workshop Ed 3 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.

Root Cause Analysis (RCA) is used to analyse the root causes of focus events with both positive and negative outcomes, but it is most commonly used for the analysis of failures and incidents. Causes for such events can be varied in nature, including design processes and techniques, organizational characteristics, human aspects and external events. RCA can be used for investigating the causes of non-conformances in quality (and other) management systems as well as for failure analysis, for example in maintenance or equipment testing.

Follow your dreams by enrolling on the Office Administration Management and Office Skills course today and develop the experience, skills and knowledge you need to enhance your expert development. Office Administration Management and Office Skills will help you arm yourself with the qualities you need to work towards your dream job. Study the Office Administration Management and Office Skills training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Office Administration Management and Office Skills course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Office Administration Management and Office Skills course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Office Administration Management and Office Skills course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Office Administration Management and Office Skills course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Office Administration Management and Office Skills course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Office Administration Management and Office Skills course. The Office Administration Management and Office Skills course is designed by industry experts and is tailored to help you learn new skills with ease.  The Office Administration Management and Office Skills is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Office Administration Management and Office Skills when it suits you. Access the Office Administration Management and Office Skills course modules from any internet-enabled device, including computers, tablets, and smartphones. The Office Administration Management and Office Skills course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Office Administration Management and Office Skills now and start learning instantly! What You Get Out Of Studying Office Administration Management and Office Skills With Janets: Receive a digital Certificate upon successful completion of the Office Administration Management and Office Skills course Get taught by experienced, expert instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Office Administration Management and Office Skills training course is delivered through Janets' online learning platform. Access the Office Administration Management and Office Skills content from any internet-enabled device whenever or wherever you want to. The Office Administration Management and Office Skills course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who Is This Course For: The Office Administration Management and Office Skills is ideal for those who already work in this sector or are an aspiring expert. This Office Administration Management and Office Skills course is designed to enhance your expertise and boost your CV. Learn key skills and gain an expert lesson to prove your newly-acquired knowledge. Requirements: The Office Administration Management and Office Skills is open to all students and has no formal entry requirements. To study the Office Administration Management and Office Skills course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Office Administration Management and Office Skills is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Office Administration Management and Office Skills  and gain an industry-acknowledged lesson that will help you excel in finding your ideal job. Course Content Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Business Writing Module One - Getting Started 00:15:00 Module Two - Working with Words 00:30:00 Module Three - Constructing Sentences 00:25:00 Module Four - Creating Paragraphs 00:25:00 Module Five - Writing Meeting Agendas 00:40:00 Module Six - Writing E-mails 00:25:00 Module Seven - Writing Business Letters 00:25:00 Module Eight - Writing Proposals 00:40:00 Module Nine - Writing Reports 00:30:00 Module Ten - Other Types of Documents 00:45:00 Module Eleven - Proofreading and Finishing 00:30:00 Module Twelve - Wrapping Up 00:15:00 Office Management Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Bookkeeping & Payroll Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Word for Newbies - Activities 00:00:00 Microsoft Office Powerpoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 PowerPoint Essential Activities 00:00:00 Microsoft Office Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Recommended Reading Recommended Reading : Diploma in Office Administration Management and Office Skills Training 00:00:00 Mock Exam Mock Exam- Diploma in Office Administration Management and Office Skills Training 00:30:00 Final Exam Final Exam- Diploma in Office Administration Management and Office Skills Training 00:30:00 Assignment Assignment - Office Administration Management and Office Skills 3 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00

Level 5 QLS Endorsed Course | CPD & CiQ Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

SEO and Digital Marketing Diploma Overview Email marketing, SEO, and social media platforms like Facebook, Twitter, and Pinterest are all covered in this SEO and Digital Marketing Diploma course. This certificate is ideal for individuals who want to succeed in the fast-paced field of SEO and digital marketing. A thorough education in modern marketing techniques is provided by the SEO and Digital Marketing Diploma. Your role-specific knowledge and competence in data analytics, SEO keywords, website auditing, keyword analysis, monetising websites, and plugin installation will be acquired through video lessons, online study materials, suggested reading, and automated assessments. An additional goal of this course is to provide you with real-world knowledge on how to grow an online following on various social media platforms, such as Facebook, YouTube, LinkedIn, and Twitter. Why You Should Choose SEO and Digital Marketing Diploma Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? SEO and Digital Marketing Diploma Diploma is CPD certified and IAO accredited. 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 backgrounds. Requirements Our SEO and Digital Marketing Diploma 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module 01: Introduction Welcome 00:01:00 Module 02: General Tips & Tricks Series How to register your company 00:04:00 How to see Email Sender's Company and Logo in Your Gmail 00:02:00 How to Generate sitemap of a website 00:03:00 How to protect a website from Spam on WordPress 00:02:00 Quick way to identify whether the website is Mobile optimized 00:03:00 How to identify registration data of website 00:01:00 How to identify duplicate content from the web 00:03:00 How to create google alerts 00:03:00 How to find the age of the domin 00:02:00 How to check if the website server is down 00:01:00 How to create text notes thatwill self destruct after being read 00:02:00 How to send google search information to your friends 00:03:00 How to find webhost of any website 00:02:00 Discover new sites that are similar to what you like alredy 00:03:00 How to easily highlight the important parts of a web page 00:01:00 How to share you email online without worrying about spam 00:02:00 How to get compute level answers without searching 00:03:00 The easiest way to setup email reminders 00:03:00 How to find the original URL tht's hiding behind a short URL 00:02:00 How to corrupt a file you shared online 00:01:00 How to create a throwaway email 00:02:00 How to check if your email account has been compromised 00:01:00 Module 03: SEO (Search Engine Optimisation) How to register website on Google search console 00:06:00 How to Optimize your website homepage 00:06:00 SEO - How to add a sitemap on google search 00:07:00 How to shortlist targeted keyword list in google keyword planner 00:08:00 How to set international targeting on google search 00:02:00 How to remove a URL from google search engine 00:03:00 How to identify competitors keyword 00:08:00 How to leverage top sites to get on google search results 00:04:00 Discover powerful data analytics to mesure SEO performance 00:06:00 How to do keyword research 00:11:00 How to write perfect title tags for search engines 00:05:00 How to optimise heading tags, external and internal links 00:08:00 What are backlinks & how to get them 00:06:00 How to write a perfect Meta description 00:06:00 How to enhance speed & performance of your website 00:04:00 Module 04: YouTube Youtube account setup 00:04:00 Account optimization 00:09:00 How to create & setup Youtube channel banner 00:05:00 Youtube channel tags, thumbnails & custom thumbnails 00:08:00 Analyse Youtube keyword research 00:05:00 Youtube SEO techniques 00:07:00 What are Youtube cards & how does it work 00:06:00 How to optimise comments & reply them in bulk 00:03:00 How to grow your channel with competitor Analysis 00:07:00 How to manage multiple YouTube accounts 00:02:00 A simple yet powerful trick to increase your subscribers list 00:03:00 Youtube Paid Advertising 00:13:00 How to monetise your YouTube channel 00:02:00 Module 05: Google Adwords What are Google Ads & how does it work 00:16:00 Account setup 00:04:00 Competitors analysis 00:08:00 Campaign types & how to select the right campaign 00:07:00 Bids & Budgets 00:08:00 How to target the right audience 00:07:00 Google Ads advance campaign settings 00:07:00 Choosing the right keywords 00:05:00 How to write ads that gets more clicks 00:06:00 Module 06: Google Analytics How to install tracking code on your website 00:04:00 How to add filters & remove internal traffic 00:04:00 How to track paid campaigns 00:04:00 How to look and analyse different segment data 00:06:00 How to configure goals in google analysics 00:05:00 How to link google Adwords account 00:03:00 How to manage multiple analytics accounts 00:02:00 How to remove spam traffic 00:04:00 Module 07: Email Marketing Email marketing tools set up ( Mailchimp and Gestresponse) 00:10:00 How to install signup or popup forms on the website 00:17:00 How to collect email address without a wbsite 00:05:00 How to create a 'Hook' to your signup forms 00:08:00 Discover the psychology behind acquiring more leads 00:09:00 Email marketing automation process 00:08:00 Email analytics 00:07:00 Module 08: Linkedln How to increase your connections in no time 00:08:00 Secret of LinkedIn InMails 00:05:00 Discover the best ways to use Linkedin Groups 00:09:00 How to setup a company page on Linkedin 00:04:00 How to increase traffic to your website using Linkedin blog 00:07:00 Module 09: Twitter Twitter Account setup 00:03:00 Knowing Twitter features 00:06:00 Following twitter accounts 00:03:00 Twitter profile optimisation 00:06:00 How to get Twitter followers 00:10:00 Posting first 5 tweets for engagement 00:05:00 Leveraging Hashtags to increase your tweets visibility 00:04:00 What are twitter polls & how do you use them 00:05:00 A powerful trick to acquire customers on twitter 00:03:00 How to get followers retweet your post 00:03:00 How to embed a twitter button to your website or post 00:02:00 Twitter analytics 00:04:00 Module 10: Facebook Set your Facebook page 00:05:00 Facebook Icon, cover image & description 00:06:00 How to get your first page likes 00:08:00 Discover how to increase your page likes 00:02:00 How to manage multiple Facebook page 00:03:00 Facebook comments 00:05:00 Leveraging Facebook groups 00:05:00 Facebook Autoposting 00:04:00 Run a competition 00:06:00 Facebook Ads 00:04:00 How to get best out of Facebook 00:15:00 Facebook pixel & Re-marketing 00:04:00 Module 11: Instagram How to setup a Instagram business profile 00:07:00 Set up Instagram bio & profile image 00:03:00 Leveraging Instagram accounts 00:06:00 A simple way to create free content on Instagram 00:05:00 Secret of hashtags on Instagram 00:04:00 Reposting Instagram App 00:04:00 How to get genuine Instagram followers 00:05:00 Discover how to grow your business through Instagram stories 00:05:00 How to get your posts reposted on Instgram by influncers 00:05:00 Module 12: Mobile App A quick way to do App store marketing research 00:16:00 How to discover the estimate size of your market 00:08:00 Discover the best ways to promote your app 00:15:00 App installs via Facebook Ads 00:16:00 App installs via Google Ads 00:14:00 How to make money from your app 00:08:00 How to optimise your App store listing ? 00:14:00 Discover growth hacking techniques for App downloads 00:09:00 Techniques to get to the top of App store ranking 00:07:00