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
Description: The Secretarial, PA & Office Administration Diploma course is designed for the people who want to exceed their role as a secretary, PA or office administrator. The responsibilities of a secretary, PA or office administrator require several skills. Throughout the course, you will explore all the essential skills for becoming an efficient secretary or PA. Focuses will be given on how to take notes, using right tools, negotiation skill, communication skill, soft skills, time & meeting management, and more. Fundamental lessons regarding how to use Microsoft Office, Excel, Access and Powerpoint will also be presented to you. Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal people who want to start working as a receptionist, office administrator, office manager, administration assistant or secretary Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Secretarial, PA & Office Administration Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Administrator support staff Administrative assistant Office managers Receptionist Office administrator Secretarial Interpersonal Skills Module One - Getting Started 00:30:00 Module Two - Verbal Communication Skills 01:00:00 Module Three - Non-Verbal Communication Skills 01:00:00 Module Four - Making Small Talk and Moving Beyond 01:00:00 Module Five - Moving the Conversation Along 00:30:00 Module Six - Remembering Names 01:00:00 Module Seven - Influencing Skills 01:00:00 Module Eight - Bringing People to Your Side 01:00:00 Module Nine - Sharing Your Opinion 01:00:00 Module Ten - Negotiation Basics 01:00:00 Module Eleven - Making an Impact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Developing Interpersonal Skills Course- Activities 00:00:00 Personal Assistant Module One - Getting Started 00:30:00 Module Two - Working with Your Manager 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Business Writing Module One - Getting Started 00:30:00 Module Two - Working with Words 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Self Esteem & Confidence Building Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 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 Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30: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 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 Microsoft 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 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 Excel for Newbies - Activities 00:00:00 Mock Exam Mock Exam- Secretarial, PA & Office Administration Diploma 00:30:00 Final Exam Final Exam- Secretarial, PA & Office Administration Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Follow your dreams by enrolling on the Office Management and Essential Skills Training course today and develop the experience, skills and knowledge you need to enhance your professional development. Office Management and Essential Skills Training will help you arm yourself with the qualities you need to work towards your dream job. Study the Office Management and Essential Skills Training training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Office Management and Essential Skills Training course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Office Management and Essential Skills Training 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 Management and Essential Skills Training course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Office Management and Essential Skills Training course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Office Management and Essential Skills Training 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 Management and Essential Skills Training course. The Office Management and Essential Skills Training course is designed by industry experts and is tailored to help you learn new skills with ease. The Office Management and Essential Skills Training 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 Management and Essential Skills Training when it suits you. Access the Office Management and Essential Skills Training course modules from any internet-enabled device, including computers, tablets, and smartphones. The Office Management and Essential Skills Training course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Office Management and Essential Skills Training now and start learning instantly! What You Get Out Of Studying Office Management and Essential Skills Training With Janets: Receive a digital Certificate upon successful completion of the Office Management and Essential Skills Training course Get taught by experienced, professional 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 Management and Essential Skills Training training course is delivered through Janets' online learning platform. Access the Office Management and Essential Skills Training content from any internet-enabled device whenever or wherever you want to. The Office Management and Essential Skills Training course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment To successfully complete the Office Management and Essential Skills Training 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 Office Management and Essential Skills Training course. After successfully passing the Office Management and Essential Skills Training course exam, you will be able to apply for a CPD-accredited certificate as proof of your Office Management and Essential Skills Training qualification. Certification All students who successfully complete the Office Management and Essential Skills Training course can instantly download their digital certificate. You can also purchase a hard copy of the Office Management and Essential Skills Training course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Office Management and Essential Skills Training is ideal for those who already work in this sector or are an aspiring professional. This Office Management and Essential Skills Training course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Office Management and Essential Skills Training is open to all students and has no formal entry requirements. To study the Office Management and Essential Skills Training 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 Management and Essential Skills Training 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 Management and Essential Skills Training and gain an industry-recognised qualification 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 : Advanced Diploma in Office Administration 00:00:00 Mock Exam Mock Exam - Office Management and Essential Skills Training 00:30:00 Final Exam Final Exam - Office Management and Essential Skills Training 00:30:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Level 5 QLS Endorsed Course | CPD & CiQ Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access
Reach out to millions through digital marketing Digital Marketing has always been one of those sectors that have constantly changed and adapted to the consumer. Today's consumers are so vastly different compared to the consumers of 5 years ago, that a whole new platform has to be extrapolated for them. In order to market your products today, you need to keep up with the trends and follow what everyone is into at the moment. Given that almost every demographic in the world uses the internet, it is a great idea to market your products online. This course will teach you just that. There is a large portion of the internet that can be used to market products and you will learn most of them here, starting with how digital marketing works. You will understand affiliate marketing, niches, traffic and much more from the first part alone. Following that, you will know the basics of internet marketing, social media marketing, SEO and email marketing; all of which will help you improve your business. If you would really like to know more and become an expert in digital marketing, then hurry and take this course now. 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. Digital Marketing Course 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 a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Digital Marketing Sales and Marketing 00:30:00 How Internet Marketing Works 01:00:00 How To Make Money With Internet Marketing 01:00:00 What is Affiliate Marketing 00:30:00 Competition in Internet Marketing 00:30:00 Researching in Internet Marketing 01:00:00 Desperate Niches 00:30:00 Profitable Niches 00:30:00 Clickbank 00:30:00 What is Traffic? 00:30:00 Traffic vs. Relevance 00:30:00 Article Marketing 01:00:00 Paid forms of Traffic - 1 01:00:00 Paid forms of Traffic - 2 01:00:00 Search Engine Optimization 00:30:00 Search Engine Optimization 2 00:30:00 Best SEO Practice 02:00:00 Blogs - WordPress 01:00:00 Blogs - WordPress II 03:00:00 Email Marketing I 00:30:00 Email Marketing II 01:00:00 Internet Marketing Strategy I 01:00:00 Your own website vs free options online I 00:30:00 Your own website vs free options online II 01:00:00 Social Media What is Social Media FREE 00:18:00 The Growth of Social Media 00:10:00 Conducting Market Analysis 00:16:00 Auditing Social Media 00:26:00 Corporate Culture and Social Media 00:12:00 Social Media Goals vs. Business Goals 00:10:00 Types of Social Media Platforms 00:08:00 The Social Media Policy 00:40:00 Creative Commons 00:21:00 Brand Marketing 00:27:00 Keyword Selection 00:17:00 Content Marketing on Social Media 00:26:00 Content Development 00:23:00 Understanding the Popular Platforms 03:34:00 Traditional Website Advertising 00:37:00 Social Media Documentation and Schedules 00:29:00 Project Management Software 00:39:00 The Community Manager Role 00:26:00 Importance of Voice Consistency 00:30:00 Organizational Customer Servicen 00:28:00 Social Media Triage 00:14:00 Online versus Personal Interactions 00:26:00 Social Media Analytics 00:27:00 Goal Value 00:43:00 Social Media Marketing Introduction 00:30:00 Understanding the Value of Social Media Buzz and What It Can Do For Your Business 01:00:00 Developing a Winning Social Media Marketing Plan 01:00:00 Setup and Manage a Facebook Page That Works 01:00:00 Tweet Your Way to Online Prominence 01:00:00 Build Your Network with LinkedIn 01:00:00 Captivate Your Audience with YouTube 01:00:00 Conclusion 00:15:00 Internet Marketing INTRODUCTION: WHAT IS AFFILIATE MARKETING? 00:30:00 WHY AFFILIATE MARKETING IS AWESOME 00:30:00 FINDING A PROFITABLE NICHE 00:30:00 CHOOSING AN AFFILIATE PRODUCT 00:15:00 THE ADVANTAGES OF CLICK BANK 00:30:00 ANALYZING THE CLICK BANK MARKETPLACE 00:30:00 CREATING YOUR HOP LINK 00:30:00 CREATING A FREE BLOG 01:00:00 PERFORMING EFFECTIVE KEYWORD RESEARCH 00:30:00 CREATING AN OPTIMIZED POST 00:30:00 POSTING TO YOUR BLOG 00:15:00 PROMOTING YOUR BLOG: AN OVERVIEW 00:30:00 PROMOTION: ARTICLE MARKETING 00:30:00 PROMOTION: SOCIAL BOOKMARKING 01:00:00 PROMOTION: BLOG COMMENTING 00:30:00 ADDITIONAL PROMOTION TIPS 00:15:00 CREATING YOUR OWN WEBSITE 01:00:00 Search Engine Optimization What Is Search Engine Optimization? 01:00:00 Search Engines That Use SEO 01:00:00 Using SEO In Website Text 01:00:00 Using SEO For Google Ads 01:00:00 Using SEO For Article Marketing 01:00:00 Using SEO In Press Releases 00:30:00 Using Longtail Keywords 00:30:00 Using Google To Discover The Best Keywords 00:30:00 SEO For Video Ads 00:30:00 SEO In Photos 00:30:00 Blogging With SEO Marketing 01:00:00 Using A SEO Company 01:00:00 SEO Techniques Introduction to SEO 00:30:00 Improve Engagement to Improve Rankings 01:00:00 Make Your Existing Pages Longer 00:30:00 Focus on YouTube SEO 00:30:00 Improve Site Speed 00:30:00 Focus on Topics Instead of Keywords 00:30:00 Build Backlinks 00:15:00 Reporting and Analytics 00:30:00 Technical Optimization 00:30:00 Local SEO and Listings 00:30:00 Guest posting 00:30:00 Effective Seo Tools 01:00:00 Email Marketing Introduction to Email Marketing 00:30:00 Using Email Marketing Software 00:30:00 Building Email Lists by Quantity 00:30:00 Building Email Lists by Quality 00:30:00 Crafting an Email 01:00:00 Analyzing and Tracking Your Email Marketing Strategy 00:30:00 Email Marketing Secrets Introduction 01:00:00 4 Crucial Things You Need To Do To Build your List 01:00:00 Ways To Get Your Opt In Subscribers To Trust You Quickly 01:00:00 Tips To Build A List Of Eager Subscribers 01:00:00 Easy Ways To Grab Your Reader's Attention In Your Subject 01:00:00 Effective Techniques To Get Your Subscribers Begging For More 01:00:00 Can You Really Use Articles To Build Your List? 01:00:00 Things To Consider When Publishing A Newsletter 01:00:00 The 3 Things To Avoid When Emailing Your List 01:00:00 Digital Marketing Strategies Introduction to Internet Marketing and Reputation Management 00:30:00 How to Optimise Your Site for Every Stage of the Buy Cycle 00:30:00 Build Impression on Your Site 00:30:00 Types of Link Building 01:00:00 Importance of Landing Pages 00:30:00 Difference Between Internet Marketing and Online Customer Service 01:00:00 Concept Of Affiliate Programs 01:30:00 About Of Google Analytics 01:00:00 Online Press Releases 00:15:00 How to Get Traffic from Twitter 00:30:00 Importance of Testing E-Mail Messages 00:15:00 What is Viral Marketing 01:00:00 What is EMail Marketing 00:30:00 Difference Between Images and Video 00:15:00 How to Internet Marketing on Facebook 02:00:00 What is Search Engine Optimization(SEO)? 00:30:00 Understanding Search Results 00:15:00 How to Attract Customer on Your Product? 00:15:00 Time Makes Money 00:30:00 How to Test a Landing Page 00:30:00 Best Web Writing 01:00:00 Ways to Use of Humor in You Internet Marketing 00:15:00 Coupon Codes 00:15:00 When to Pull the Plug 00:15:00 Facebook Marketing Basics Introduction to Facebook 00:15:00 Why You Should Care 00:15:00 Setting up a Facebook Page 00:30:00 How to Get More Likes for Your Facebook Page 00:30:00 Facebook Advertising 00:30:00 How Much Does Facebook Advertising Cost? 00:30:00 Marketing on Facebook 01:00:00 Create a Content Calendar 00:15:00 Understanding Edge Rank & the Art of Engagement 00:15:00 Twitter Marketing TWITTER FOR BUSINESS 00:15:00 TOP TWITTER TIPS 00:15:00 TWITTER IS 00:15:00 BUSINESS TERMS 00:15:00 WHY USE TWITTER FOR MARKETING 00:15:00 TWITTER MARKETING BASICS 01:00:00 TWITTER METRICS 00:30:00 YOUR BIO 00:15:00 WHEN TO TWEET 00:15:00 BUILDING YOUR COMMUNITY 00:15:00 GENERATING LEADS 00:15:00 REAL-TIME TWITTER MARKETING 00:15:00 ENGAGEMENT 00:15:00 TWETIQUETTE (TWEETING ETIQUETTE) 00:15:00 Instagram Marketing What is Instagram? 00:15:00 Instagram for Business 00:15:00 Instagram & Community 00:15:00 Google Adwords Benefits of online advertising and AdWords 00:30:00 Choosing a campaign type 00:30:00 Measure your results 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Digital Marketing Complete Course 00:30:00 Final Exam Final Exam- Digital Marketing Complete Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Course Description Get instant knowledge from this bite-sized Internal Audit Skill Part - 2 course. This course is very short and you can complete it within a very short time. In this Internal Audit Skill Part - 2 course you will get fundamental ideas of internal audit, the key understanding of reporting audit outcome, UK internal audit standards and so on. Enrol in this course today and start your instant first step towards learning about audit interviews. Learn faster for instant implementation. Learning Outcome Understand audit interviews Gain in-depth knowledge of the reporting audit outcome Deepen your understanding of UK internal audit standards Learn about a career as an auditor How Much Do Internal Auditors Earn? Senior - £67,000 (Apprx.) Average - £41,000 (Apprx.) Starting - £25,000 (Apprx.) Requirement Our Internal Audit Skill Part - 2 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. Internal Audit Skill Part - 2 Module 01: Audit Interviews 00:18:00 Module 02: Reporting Audit Outcome 00:23:00 Module 03: UK Internal Audit Standards 00:24:00 Module 04: Career as an Auditor 00:17:00 Assignment Assignment - Internal Audit Skill Part - 2 00:00:00
Register on the Accounting and Finance today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as proof of your course completion. The Accounting and Finance is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Accounting and Finance Receive a e-certificate upon successful completion of the course Get taught by experienced, professional 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) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification 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. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Accounting and Finance, 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.
The Charity Accounting Mini Bundle is tailored for those ready to step into the financial and regulatory side of nonprofit and charitable organisations. With a focus on accounting, financial analysis, business management, AML, and problem solving, this bundle is designed to get you hired in a sector where transparency and accountability are everything. If you're eyeing a career where purpose meets performance, this bundle delivers both. Description Charities operate like businesses—but with tighter scrutiny. That’s why roles in this sector increasingly require core competencies in accounting, financial analysis, business management, AML compliance, and problem solving. The Charity Accounting Mini Bundle gives you the credibility you need to stand out in charitable foundations, NGOs, and nonprofit finance departments. Employers in the third sector value candidates who can handle accounting responsibilities with the rigour of business management and the insight of financial analysis. AML procedures are no longer optional—they’re essential. Add in strong problem solving skills, and you're exactly the kind of reliable, detail-driven hire charities are seeking. Positions in nonprofit accounting and financial support don’t wait. With accounting, financial analysis, business management, AML, and problem solving under your belt, you're ready to move from application to appointment. FAQ Who should take this bundle? Anyone aiming to work in charity finance, nonprofit admin, or grant auditing roles. Is AML really that important in the charity sector? Yes—AML ensures donations and financial operations remain compliant and trustworthy. What kinds of roles does this support? Charity accountant, finance assistant, trust officer, nonprofit auditor, compliance coordinator, and donor finance liaison. How does business management tie in with accounting? Charities still need structured budgeting and operations—business management skills are increasingly essential. Is this suitable for someone transitioning from private sector roles? Absolutely—especially with experience in accounting, financial analysis, AML, and problem solving. Why enrol now? Charity roles are rising—but competition is tight. Demonstrate readiness with accounting, financial analysis, business management, AML, and problem solving expertise today.
Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00