1089 Administrative Assistant courses

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

Description:  Microsoft Office includes Access, Excel, Outlook, Power Point, Publisher and Word. The most widely used version is the desktop version. These versions are available on different operating systems. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Office. You will know the different components and parts of Microsoft Office that you need to learn to be able to utilise the programs. You will realise that you will not be able to work without it since it is very user-friendly and helpful in your career. Who is the course for? New staff or professionals who want to learn about the Microsoft Office Essentials People who have an interest in the basics and features of Microsoft Office Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy 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 recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Office Essentials course is a useful qualification to possess and would be beneficial for any type of professions or careers like: Account Manager Administrative Assistant Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Supervisor Top Executive. 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 Word for Newbies - 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 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 Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Outlook for Beginners 00:00:00 Microsoft Publisher Module One - Getting Started 00:30:00 Module Two - Opening Publisher 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Working with Pictures 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Fonts 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Working with Pages 01:00:00 Module Eleven - Publishing Your Work 01:00:00 Module Twelve - Wrapping Up 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office Essentials 00:30:00 Final Exam Final Exam- Microsoft Office Essentials 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Embark on a Mathematical Odyssey: Build Your Math Fundamentals Welcome to a transformative journey through the enchanting realm of numbers and calculations with our Build Your Math Fundamentals course. Dive deep into the core of mathematical understanding as we unravel the mysteries of integers, factors, fractions, and more. The journey begins with the exploration of directed numbers and meanders through the intricacies of BODMAS, rational numbers, percentages, and beyond. Each module is a stepping stone, laying the foundation for a solid understanding of math fundamentals. No longer view math as a challenge; embrace it as a fascinating adventure with real-world applications. Whether you're a novice eager to conquer the basics or someone looking to refresh their mathematical prowess, this course is your key to unlocking the magic of numbers. Learning Outcomes Master the concept of integers, including directed numbers and their applications. Explore the world of factors, multiples, and their significance in mathematical calculations. Gain proficiency in working with fractions and understand their role in real-world scenarios. Apply the BODMAS rule for simplification with confidence and precision. Navigate through decimal numbers, rational numbers, percentages, and advanced topics like scientific notation. Why choose this Build Your Math Fundamentals course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Build Your Math Fundamentals course for? Students seeking to strengthen their foundational math skills. Professionals wanting to enhance their quantitative abilities. Parents supporting their children in math studies. Job seekers preparing for numerical assessments. Anyone looking to build a solid mathematical foundation for future learning. Career path Data Entry Clerk: £18,000 - £25,000 Administrative Assistant: £20,000 - £28,000 Retail Sales Associate: £18,000 - £22,000 Customer Service Representative: £18,000 - £25,000 Junior Accountant: £22,000 - £30,000 Banking Associate: £20,000 - £28,000 Prerequisites This Build Your Math Fundamentals does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Build Your Math Fundamentals 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 Integers ( Directed Numbers) Introduction 00:02:00 Number system 00:09:00 Integers and ordering of integers 00:07:00 Addition and Subtractions of Integers 00:10:00 Operations on Integers 00:06:00 Multiplication and Division of Integers 00:07:00 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Complete knowledge about factors and multiples 00:07:00 Divisibility tests for 2,3,4,5,6 00:07:00 Divisibility rules 7,8,9,10,11 00:11:00 Prime Factorization 00:13:00 Highest common factor HCF 00:13:00 Word problems based on HCF 00:12:00 Least common multiple LCM 00:16:00 Relation between lcm and HCF 00:04:00 Fractions Classification of Fractions 00:04:00 Convert mixed to improper and improper to mixed fractions 00:03:00 Equivalent Fractions 00:04:00 Comparing Fractions after converting to like fractions 00:09:00 Reducing a fraction to lowest term 00:04:00 Addition and subtraction OF fractions 00:08:00 Multiplication and division of fractions 00:11:00 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Bodmas and rules to remove brackets 00:03:00 simplify expressions using BODMAS rules 00:05:00 simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Decimal numbers in relation to fractions 00:08:00 Like and unlike Decimals 00:05:00 Ordering of Decimal numbers 00:10:00 Addition and subtraction of Decimal 00:07:00 Multiplication of Decimal 00:03:00 Division of Decimal 00:08:00 Rational Numbers Rational number 00:02:00 Representation of Rational Numbers on Number line 00:05:00 Determining which fraction is terminating or non-terminating 00:07:00 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Rounding to whole number 00:06:00 Rounding to required number of decimals (1 d.p. ) 00:05:00 Rounding to significant digits 00:07:00 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Estimation 00:05:00 Scientific Notation 00:07:00 Operation on numbers when they are in scientific notation 00:06:00 Percentage Percentage to fraction and fraction to percentage 00:06:00 Percentage of a quantity and conversation to decimal 00:06:00 Expressing one quantity as percentage of another quantity 00:06:00 Finding increase decrease percent 00:05:00 Uses of Percentages-Word Problems 00:09:00 Ratio and Proportion Ratio- How to express as simple ratio 00:09:00 How to compare Ratios 00:04:00 Word problems on finding ratios 00:07:00 To divide a given quantity into a given Ratio 00:11:00 Proportion 00:04:00 Practice problems on Proportion 00:06:00 Continued proportion 00:06:00 Unitary Method and its Applications Direct Variation (or proportion) 00:04:00 Problems based on Direct proportion 00:10:00 Inverse Variation (or proportion) 00:10:00 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Basics - Profit and Loss 00:04:00 More practice problems on Profit _ Loss 00:06:00 Selling price formula and Problems 00:04:00 Cost price formula and Problems 00:03:00 Higher problems on Profit and Loss 00:08:00 Basics - Discount 00:05:00 Practice problems on Discount 00:04:00 Tax 00:06:00

Level 2 Microsoft Office Essentials

Duration 5 Days 30 CPD hours This course is intended for A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows. Prerequisites Experience as an IT professional or student Working knowledge of Microsoft Power Platform and its key components Knowledge of Microsoft Dataverse (or general data modeling) and security concepts 1 - Describe the business value of the Microsoft Power Platform Explore Microsoft Power Platform Describe the business value of the Power Platform Explore connectors and Microsoft Dataverse Describe how Power Platform works with Microsoft 365 apps and services Explore how Power Platform works with Microsoft Teams Describe how Power Platform works with Microsoft Dynamics 365 apps Describe how Power Platform solutions consume Microsoft Azure services Explore how Microsoft Power Platform apps work together Use Artificial Intelligence to increase productivity 2 - Core components of Power Pages Get started with Power Pages Core tools and components of Power Pages Overview of Power Pages security Overview of Power Pages extensibility 3 - Explore Power Pages templates Site design templates Scenario-based templates Dynamics 365 Power Pages site templates 4 - Explore Power Pages design studio Work with pages Page components Site styling and templates 5 - Explore Power Pages design studio data and security features Data workspace in Power Pages design studio Power Pages security features 6 - Introduction to Power Pages administration Power Pages administrative tools Set up workspace in Power Pages design studio 7 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 8 - Get data with Power BI Desktop Overview of Power BI Desktop Explore Power BI Desktop Connect to data sources Get data from Excel Transform data to include in a report Combine data from multiple sources Clean data to include in a report 9 - Model data in Power BI How to manage your data relationships Create calculated columns Optimize data models Create measures Create calculated tables Explore time-based data 10 - Use visuals in Power BI Create and customize simple visualizations Create slicers Map visualizations Matrices and tables Create scatter, waterfall, and funnel charts Modify colors in charts and visuals Page layout and formatting 11 - Explore data in Power BI Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Display visuals and tiles in full screen Edit tile details and add widgets Get more space on your dashboard 12 - Publish and share in Power BI Publish Power BI Desktop reports Print and export dashboards and reports Introducing Power BI Mobile Create workspaces in Power BI Build apps Use apps Integrate OneDrive for Business with Power BI Publish to web 13 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 14 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 15 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 16 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method 17 - Create tables in Dataverse Table characteristics Table relationships Dataverse logic and security Dataverse auditing Dual-write vs. virtual tables 18 - Manage tables in Dataverse Identify tables and table types in Dataverse Create a custom table Enable attachments within a table Licensing requirements for each table type 19 - Create and manage columns within a table in Dataverse Define columns in Microsoft Dataverse Column types in Microsoft Dataverse Add a column to a table Create a primary name column Restrictions that apply to columns in a table Create an auto numbering column Create an alternate key 20 - Create a relationship between tables in Dataverse Relate one or more tables - Introduction Relationship types that are available in Microsoft Dataverse Create a one-to-many relationship between tables Create a many-to-many relationship between tables Edit or delete relationships 21 - Working with choices in Dataverse Define choice column Standard choices column 22 - Get started with security roles in Dataverse Understand environment roles Adding or disabling an environment user Understand security concepts in Dataverse Understand user security roles and security role defaults Check the roles that a user belongs to Configure Dataverse teams for security Configure Dataverse group teams for security 23 - Use administration options for Dataverse Use Microsoft Power Platform Admin Center portal Tenant storage capacity Advanced Customization options in Power Apps Portal Enable and disable auditing 24 - Manage Dynamics 365 model-driven app settings and security Configure role-based security Manage teams and business units Explore settings and customizations 25 - Introduction to Microsoft Power Platform security and governance Identify Microsoft Power Platform environments Data Loss Prevention policies Microsoft Power Platform Center of Excellence Starter Kit 26 - Get started with model-driven apps in Power Apps Introducing model-driven apps Components of model-driven apps Design model-driven apps Incorporate business process flows 27 - Configure forms, charts, and dashboards in model-driven apps Forms overview Form elements Configure multiple forms Use specialized form components Configure views overview Configure grids Create and edit views Configure charts overview Dashboards overview Use interactive streams and tiles 28 - Get started with Power Apps canvas apps Power Apps building blocks Ways to build Power Apps Power Apps related technologies Additional Power Apps related technologies Designing a Power Apps app 29 - Connect to other data in a Power Apps canvas app Overview of the different data sources Work with action-based data sources Power Automate is a companion to Power Apps 30 - How to build the UI in a canvas app in Power Apps Use themes to quickly change the appearance of your app Branding a control Icons Images Personalization Using the tablet or phone form factors 31 - Manage apps in Power Apps Power Apps review 32 - Build your first app with Power Apps and Dataverse for Teams Create your first app with the hero template Customize your app with Power Apps Studio Publish your app Install template apps 33 - Access Dataverse in Power Pages websites Use lists to display multiple Dataverse records Use forms to interact with Dataverse data 34 - Authentication and user management in Power Pages Power Pages authentication settings User registration in Power Pages Authentication management for Power Pages users Power Pages authentication providers 35 - Power Pages maintenance and troubleshooting Power Pages website maintenance Power Pages website troubleshooting 36 - Define and create business rules in Dataverse Define business rules - Introduction Define the components of a business rule Create a business rule 37 - Get started with Power Automate Introducing Power Automate Troubleshoot flows 38 - Use the Admin center to manage environments and data policies in Power Automate Administer flows Export and import flows Learn how to distribute button flows 39 - Use Dataverse triggers and actions in Power Automate Dataverse triggers Query data Create, update, delete, and relate actions 40 - Extend Dataverse with Power Automate Set up a flow and configure its trigger Email Dataverse record Add to-do items Test and run your flow 41 - Introduction to expressions in Power Automate Get started with expressions Notes make things easier Types of functions Write complex expressions 42 - Build your first Power Automate for desktop flow Set up the environment Explore Power Automate for desktop Create your first Power Automate for desktop flow Record Power Automate for desktop actions Edit and test recorded actions 43 - Run a Power Automate for desktop flow in unattended mode Set up an unattended desktop flow Create a new cloud flow that calls an existing flow in unattended mode Perform a test run Best practices 44 - Optimize your business process with process advisor Get familiar with process advisor Create your first recording Edit recordings and group actions Analyze recordings and interpret results Automation recommendations 45 - Get started with Microsoft Copilot Studio bots Get started working with environments Create bots and work with the Microsoft Copilot Studio interface Create topics Test bots Publish bots and analyze performance 46 - Enhance Microsoft Copilot Studio bots Use Power Automate to add actions Transfer conversations to agents by using Omnichannel for Customer Service Create topics for existing support content Analyze bot performance 47 - Manage topics in Microsoft Copilot Studio Work with bot topics Branch a topic Create topics for existing support content Work with system fallback topics Manage topics 48 - Manage Power Virtual Agents Environments in Microsoft Copilot Studio Bot topics permissions Bot entities and flow permissions Monitor and diagnose Administer and manage Export and import bots Authentication 49 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 50 - Get data with Power BI Desktop Overview of Power BI Desktop Explore Power BI Desktop Connect to data sources Get data from Excel Transform data to include in a report Combine data from multiple sources Clean data to include in a report 51 - Model data in Power BI How to manage your data relationships Create calculated columns Optimize data models Create measures Create calculated tables Explore time-based data 52 - Use visuals in Power BI Create and customize simple visualizations Create slicers Map visualizations Matrices and tables Create scatter, waterfall, and funnel charts Modify colors in charts and visuals Page layout and formatting 53 - Explore data in Power BI Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Display visuals and tiles in full screen Edit tile details and add widgets Get more space on your dashboard 54 - Publish and share in Power BI Publish Power BI Desktop reports Print and export dashboards and reports Introducing Power BI Mobile Create workspaces in Power BI Build apps Use apps Integrate OneDrive for Business with Power BI Publish to web 55 - Manage solutions in Power Apps and Power Automate Add and remove apps, flows, and entities in a solution Edit a solution-aware app, flow, and table Build and deploy a complex solution with flows, apps, and entities Automate solution management 56 - Load/export data and create data views in Dataverse View data in a table Create or edit views of data in a table Load data into a table Export data from a table Add, update, or delete data in a table by using Excel Import data using Power Query Generate a new dataflow from an Excel Template Dataflow and Azure integration 57 - Get started with AI Builder Choose an AI capability Create your first model Ways to use your models 58 - Manage models in AI Builder Model lifecycle Manage model versions Share your models 59 - Use AI Builder in Power Automate AI Builder in Power Automate saves time Advanced usage of AI Builder in Power Automate 60 - Functional Consultant skills Create entity relationship diagrams Create and document mock-ups Document functional requirements and artifacts Complete fit-gap analysis Discuss stakeholder management responsibilities Understand industry accelerators Define Application Lifecycle Management Participate in testing Evaluate options Define connectors Understand Power Apps component framework 61 - Solution Architect series: Plan application lifecycle management for Power Platform Key considerations for ALM Solutions Configuration and reference data Release process ALM with Azure DevOps

Embark on a journey to master Microsoft Excel with our 'Excel Essentials for Office Administrators' course. Designed to transform beginners into proficient users, this comprehensive course is divided into two main sections: Excel Beginner and Excel Intermediate. In the initial phase, learners are introduced to the Excel interface, where they explore and identify its various elements. This is followed by practical activities such as creating basic worksheets, using the help system, and crafting formulas. As the course progresses, participants will delve into more advanced features like manipulating data, applying styles and formats, and managing worksheets. The intermediate section elevates your skills further, covering a wide range of topics from applying range names and specialized functions to creating sophisticated charts and PivotTables. Learning Outcomes Gain proficiency in navigating and utilizing the Excel interface. Develop the ability to create and manage complex worksheets effectively. Master a variety of Excel functions and formulas for diverse data processing needs. Learn advanced data management techniques including sorting, filtering, and using PivotTables. Acquire skills in visual data presentation and customization of Excel workbooks. Why choose this Excel Essentials for Office Administrators course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel Essentials for Office Administrators course for? Office administrators and secretaries seeking to enhance their Excel skills. Professionals in various sectors requiring proficiency in Excel for data management. Students and individuals interested in learning Excel from a beginner to an intermediate level. Business owners needing to manage business data more efficiently. Anyone aiming to improve their productivity and data analysis skills through Excel. Career path Data Analyst: £25,000 - £50,000 Administrative Assistant: £18,000 - £30,000 Office Manager: £22,000 - £40,000 Business Analyst: £30,000 - £60,000 Financial Analyst: £28,000 - £55,000 Project Coordinator: £24,000 - £45,000 Prerequisites This Excel Essentials for Office Administrators does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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 Excel Beginner Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Excel Intermediate Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00

The 'Diploma in Legal Administration - Legal Secretary (Level 3)' course provides comprehensive training on legal systems, contract law, criminal law, family law, and other essential skills required for a legal secretary role. Participants will learn about various legal aspects and gain expertise in professional writing, document management, and conflict resolution. Learning Outcomes: Understand the fundamental principles of English law and legal systems. Gain knowledge of contract law, tort law, criminal law, family law, and property law. Develop skills in document preparation, proofreading, and editing for legal documents. Learn effective meeting management and minute-taking techniques. Acquire data management and record-keeping skills necessary for a legal secretary role. Explore other essential skills, such as conflict resolution, human rights, and criminal psychology. Why buy this Diploma in Legal Administration - Legal Secretary (Level 3)? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Diploma in Legal Administration - Legal Secretary (Level 3) there will be an automated MCQ test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring legal secretaries seeking to enter the legal profession. Existing legal secretaries looking to enhance their knowledge and skills. Individuals interested in the legal field and seeking a career as a legal secretary. Prerequisites This Diploma in Legal Administration - Legal Secretary (Level 3) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in Legal Administration - Legal Secretary (Level 3) 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 Legal Secretary Legal Assistant Paralegal Administrative Assistant in legal departments Law Firm Support Staff Course Curriculum ***Updated Version*** Module 01: Introduction to Legal Secretary Introduction to Legal Secretary 00:22:00 Module 02: English Law & Legal Systems English Law & Legal Systems 00:33:00 Module 03: Law of Contract & Law of Tort Law of Contract & Law of Tort 00:28:00 Module 04: Wills, Probate, Estate Law Wills, Probate, Estate Law 00:15:00 Module 05: Property Law & Conveyancing Practice Property Law & Conveyancing Practice 00:19:00 Module 06: Criminal Law Criminal Law 00:24:00 Module 07: Understanding Criminal Psychology Understanding Criminal Psychology 00:31:00 Module 08: Contract & Business Law Contract & Business Law 00:54:00 Module 09: Family Law and Insurance Practice Family Law and Insurance Practice 00:24:00 Module 10: Conflict and Conflict Resolution Conflict and Conflict Resolution 00:18:00 Module 11: Professional Writings and Documents Professional Writings and Documents 00:27:00 Module 12: Document Proofreading and Editing Document Proofreading and Editing 00:19:00 Module 13: Meeting Management & Minute Taking Meeting Management & Minute Taking 01:06:00 Module 14: Data Management and Record-Keeping Data Management and Record-Keeping 00:13:00 Module 15: Other Essential Skills for Secretarial Role Other Essential Skills for Secretarial Role 00:19:00 Module 16: Human Rights Human Rights 00:12:00 ***Old Version*** Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:18:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 Taking Minutes in an Interactive Meeting 00:15:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:05:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Other Secretarial Roles And Responsibilities Working with Your Manager 01:00:00 Administrative Soft Skills 01:00:00 Effective Time Management 01:00:00 Tools of the Trade 01:00:00 Being an Effective Gatekeeper 00:15:00 Organizational Skills 00:15:00 Confidentiality Guidelines 00:15:00 Special Tasks 00:15:00 Customer Service Role Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Telephone Etiquette Aspects of Phone Etiquette 01:00:00 Using Proper Phone Language 01:00:00 Eliminate Phone Distractions 01:00:00 Inbound Calls 01:00:00 Outbound Calls 01:00:00 Handling Rude or Angry Callers 01:00:00 Handling Interoffice Calls 01:00:00 Methods of Training Employees 01:00:00 Correcting Poor Telephone Etiquette 01:00:00 Organizing Work Using MS Word Opening 01:00:00 Working with the Interface 01:00:00 Your First Document 01:00:00 Basic Editing Tasks 01:00:00 Basic Formatting Tasks 01:00:00 Formatting Paragraphs 01:00:00 Advanced Formatting Tasks 01:00:00 Working with Styles 01:00:00 Formatting the Page 01:00:00 Sharing Your Document 01:00:00 Proof Reading Introduction to Proofreading 00:15:00 What does a Proofreader do? 00:15:00 Proofreading 00:15:00 Proofreading Symbols 00:15:00 Proofreading on Paper & Screen 00:15:00 Strategies to Check for Specific Errors 00:15:00 Editing & Proofreading Strategies 00:15:00 Proofreading an Essay 00:15:00 Mock Exam Mock Exam - Legal Secretary 00:30:00 Final Exam Final Exam - Legal Secretary 00:30:00

Gain full proficiency in Microsoft Office and add a brand new qualification to your CV! The Microsoft Office course is the ultimate training bundle package for Microsoft Office, taking you from beginner to expert in no time. You will learn how to perform a wide range of administrative tasks which will equip you with the most in-demand skills needed to work in an office-based role. This course is a step-by-step instructor-guided course, taking you through key procedures, best practices and shortcuts. Master Microsoft Office in only one week and take your career to the next level! Learning Outcomes Attain mastery in navigating and utilising Excel 2016 for computations, formatting, and workbook management. Develop advanced word processing abilities in Word 2016, from basic formatting to publishing. Craft engaging presentations in PowerPoint 2016, integrating various media and graphics. Gain expertise in data management through Access 2016, including data modification and report generation. Enhance overall productivity by understanding and implementing Microsoft Office's efficient features. Why choose this Microsoft Office course? 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 Office course 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 Office course for? Individuals aiming to bolster their digital productivity skills. Professionals looking to advance their documentation and presentation prowess. Data enthusiasts wanting to harness Excel's computational capabilities. Students seeking comprehensive knowledge in Microsoft tools. Administrative staff aiming for streamlined data management. Career path Data Analyst: £25,000 - £40,000 Administrative Assistant: £18,000 - £28,000 Presentation Designer: £23,000 - £35,000 Document Controller: £22,000 - £38,000 Office Manager: £25,000 - £45,000 Database Administrator: £30,000 - £50,000 Prerequisites This Microsoft Office course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Office course 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 Excel 2016 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 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:05:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2016 (Beginner) 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Create a Table 00:09:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access1 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00

Step into the captivating world of Functional Skills Maths Level 2, a course that transcends mere numbers. It's not just about equations; it's about empowering you to conquer challenges and infuse confidence into your every step. Imagine a world where percentages aren't daunting but doors opening to financial empowerment.    Functional Skills Maths Level 2 equips learners with essential mathematical competencies. This course addresses real-world challenges, empowering individuals to navigate daily life, business, and further education with confidence. Proficiency in BODMAS, decimals, ratios, and more provides tangible benefits, fostering problem-solving and decision-making skills. Students gain a competitive edge in personal and professional spheres, improving their prospects and contributing to a numerically literate society.   By mastering concepts like percentages and unitary methods, learners enhance their financial acumen, crucial for managing personal finances or pursuing business ventures. This course is a gateway to unlocking opportunities, and fostering a deeper understanding of mathematical applications in diverse contexts. The practical skills acquired are invaluable for achieving academic success, career advancement, and overall personal development.   Learning Outcomes Apply rules of BODMAS for accurate mathematical simplification. Demonstrate proficiency in working with integers and directed numbers. Master calculations involving decimals, percentages, and scientific notation. Analyse and solve problems related to profit, loss, discount, and tax. Utilise unitary methods in practical applications and problem-solving scenarios. Understand and apply concepts of ratio, proportion, and fractions effectively. Successfully estimate and approximate numerical values in real-world situations. Comprehend the principles of factors, multiples, and their mathematical relationships. Apply mathematical skills to solve mock and final exam questions effectively.   Who is this Award in Functional Skills Maths at QLS Level 2 Course For? Individuals seeking practical math skills for daily life. Students aiming for academic success and confidence in mathematics. Professionals looking to enhance their financial literacy. Entrepreneurs and business enthusiasts want sound mathematical foundations. Anyone wanting to improve problem-solving abilities through practical math.   Why Choose This Award in Functional Skills Maths at QLS Level 2 Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success.   Career Path Administrative roles: Administrative Assistant (£18,000 - £25,000 per year) Retail positions: Retail Manager (£20,000 - £45,000 per year) Finance sector: Junior Accountant (£20,000 - £30,000 per year) Business ownership: Small Business Owner (Earnings vary widely) Further studies: Access to higher-level math courses for specialised careers.   Prerequisites This Functional Skills Maths - Level 2 is open to all, irrespective of prior qualifications. Enrolling is simple, and the course, created by experts, functions seamlessly on PCs, Macs, tablets, and smartphones. With accessibility from any location with a reliable internet connection, this course provides convenient learning options.   Certification After finishing the course content, you'll encounter a written assignment test. Upon successful completion, you can acquire a PDF certificate for a fee of £4.99. If you prefer a physical copy, you can order an original hard copy for an extra £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 £75 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 Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 1 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51 To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount.mp4 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Mock Exam Mock Exam - Award in Functional Skills Maths at QLS Level 2 00:20:00 Final Exam Final Exam - Award in Functional Skills Maths at QLS Level 2 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Description: The Office Admin and Legal Secretary Diploma course teaches you the techniques and skills for managing an Office as Office Admin or managing the role of a legal secretary. You will learn administration management skills, organisational skills and essential office management skills. The course also covers the skills required for a legal secretary such as fundamental concepts of the legal office, billing, preparing legal documents, contracts, torts, real estate, family law, business law, telephone etiquette, meeting management and minute management and more 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 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 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: Office Admin and Legal Secretary 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 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 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 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 Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:30:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:15:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Minute Taking tips 00:30:00 Other Secretarial Roles and Responsibilities Working with Your Manager 01:00:00 Administrative Soft Skills 01:00:00 Effective Time Management 01:00:00 Tools of the Trade 01:00:00 Being an Effective Gatekeeper 00:15:00 Organizational Skills 00:15:00 Confidentiality Guidelines 00:15:00 Special Tasks 00:15:00 Legal Office Administration Ethical Considerations 00:10:00 The Basics 00:04:00 Client Relations 00:05:00 Dealing With Mail 00:05:00 File Management 00:03:00 Use Of Technology 00:06:00 Skills that Every Legal Secretary Should Have 00:06:00 What is Litigation 00:04:00 Delivery of Documents 00:04:00 Motions Prior to and During Trial 00:07:00 The Basics 00:04:00 The Essential Elements 00:03:00 Remedies for Breach of Contract 00:04:00 Customer Service Role Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Telephone Etiquette Aspects of Phone Etiquette 01:00:00 Using Proper Phone Language 01:00:00 Eliminate Phone Distractions 01:00:00 Inbound Calls 01:00:00 Outbound Calls 01:00:00 Handling Rude or Angry Callers 01:00:00 Handling Interoffice Calls 01:00:00 Methods of Training Employees 01:00:00 Correcting Poor Telephone Etiquette 01:00:00 Organizing Work Using MS Word Opening 01:00:00 Working with the Interface 01:00:00 Your First Document 01:00:00 Basic Editing Tasks 01:00:00 Basic Formatting Tasks 01:00:00 Formatting Paragraphs 00:01:00 Advanced Formatting Tasks 01:00:00 Working with Styles 01:00:00 Formatting the Page 01:00:00 Sharing Your Document 01:00:00 Proof Reading Introduction to Proofreading 00:15:00 What does a Proofreader do? 00:15:00 Proofreading 00:15:00 Proofreading Symbols 00:15:00 Proofreading on Paper & Screen 00:15:00 Strategies to Check for Specific Errors 00:15:00 Editing & Proofreading Strategies 00:15:00 Proofreading an Essay 00:15:00 Mock Exam Mock Exam- Office Admin and Legal Secretary Diploma 00:30:00 Final Exam Final Exam- Office Admin and Legal Secretary Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00