717 Courses

Gain a professional qualification that will help you take your secretarial and administrative career to the next level with the Company Secretary Training Course. In this course you will learn; professional communication, time management and administrative skills, while also delivering on business processes. The Company Secretary Training Course cover; businesses operational skills, administrative skills along with improving your soft skills in the process. Your Learning Goals: Learn how to organise your working day and documentation Develop time-management skills to make your day more efficient Learn how to handle special tasks set by your manager Develop your communication skills Learn how to provide quality customer service Understand how to prioritise work Learn how to use Microsoft Office tools effectively Understand the importance of business writing and documentation. Who is this Course for? Company Secretary Training Course is 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. 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. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Company Secretary Training Course - Updated Version Module 01: Introduction to Office Administration 00:15:00 Module 02: Skills of an Effective Administrator 00:17:00 Module 03: Business Etiquette 00:20:00 Module 04: Business Telephone Skills 00:20:00 Module 05: Representing Your Boss and Company 00:37:00 Module 06: Mail Services and Shipping 00:28:00 Module 07: Travel Arrangements 00:26:00 Module 08: Organising Meeting and Conferences 00:29:00 Module 09: Time Management 00:36:00 Module 10: Record Keeping and Filing Systems 00:29:00 Module 11: Business Writing Skills 00:42:00 Module 12: Organisational Skills 00:27:00 Module 13: Communication Skills 00:28:00 Module 14: Customer Service 00:17:00 Module 15: Effective Planning and Scheduling 00:52:00 Module 16: Invoicing/Petty Cash 00:28:00 Company Secretary Training Course - Old Version Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 00:05:00 Module Three - Getting Organized (II) 00:05:00 Module Four - Managing Time 00:05:00 Module Five - Getting It All Done On Time 00:05:00 Module Six - Special Tasks 00:05:00 Module Seven - Verbal Communication Skills 00:05:00 Module Eight - Non-Verbal Communication Skills 00:05:00 Module Nine - Empowering Yourself 00:05:00 Module Ten - The Team of Two 00:05:00 Module Eleven - Taking Care of Yourself 00:05:00 Module Twelve - Wrapping Up 00:05:00 Administrative Management Module One - Getting Started 00:05:00 Module Two - Why Your Office Needs Administrative Procedures 00:05:00 Module Three - Gathering the Right Tools 00:05:00 Module Four - Identifying Procedures to Include 00:05:00 Module Five - Top Five Procedures to Record 00:05:00 Module Six - What to Include in Your Binder (I) 00:05:00 Module Seven - What to Include in Your Binder (II) 00:05:00 Module Eight - Organizing Your Binder 00:05:00 Module Nine - What Not to Include in the Procedure Guide 00:05:00 Module Ten - Share Office Procedure Guide 00:05:00 Module Eleven - Successfully Executing the Guide 00:05:00 Module Twelve - Wrapping Up 00:05:00 Organisational Skills Module One - Getting Started 00:05:00 Module Two - Remove the Clutter 00:05:00 Module Three - Prioritize 00:05:00 Module Four - Scheduling Your Time 00:05:00 Module Five - To Do Lists 00:05:00 Module Six - Paper and Paperless Storage 00:05:00 Module Seven - Organization in Your Work Area 00:05:00 Module Eight - Tools to Fight Procrastination 00:05:00 Module Nine - Organizing Your Inbox 00:05:00 Module Ten - Avoid the Causes of Disorganization 00:05:00 Module Eleven - Discipline is the Key to Stay Organized 00:05:00 Module Twelve - Wrapping Up 00:05: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 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 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 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In today's dynamic digital landscape, proficiency in core software can significantly elevate one's professional profile, especially in Microsoft Office products. 'Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!' is not just a course title; it's a promise of swift mastery. Dive deep into the essentials of Microsoft Word, explore the art of compelling presentations with PowerPoint, and streamline your communication with Outlook. Moreover, as a bonus, familiarise yourself with quick keyboard shortcuts for Microsoft Excel. This immersive course paves the way for a more organised, effective, and efficient workflow in the office space. A seamless blend of theory and application ensures learners extract maximum value within a concise timeframe. The meticulously crafted curriculum elucidates intricate functionalities in an easy-to-comprehend manner, ensuring every attendee emerges confident in utilising the trio of tools to their fullest potential. As the digital age marches forward, possessing a strong foundation in MS Office is no longer optional but a necessity. Imagine enhancing your daily tasks, from document drafting to scheduling, by tapping into the power of these indispensable Microsoft tools. This course lays the golden brick road for you, guiding you towards professional mastery and heightened productivity, all within a brisk 90 minutes. The future is digital, and this course ensures you're caught up. So, what makes you wait too long? Enrol today and golden brick towards professional mastery. Learning Outcomes: Acquire in-depth knowledge of Microsoft Word's fundamental features for effective document creation. Master the design and delivery of impactful presentations via Microsoft PowerPoint. Navigate and optimise Microsoft Outlook for efficient email management and scheduling. Discover essential keyboard shortcuts to enhance Microsoft Excel's user experience. Enhance productivity by integrating the key tools of MS Office into daily tasks. Comprehend the interconnectivity and complementary nature of MS Office applications. Harness the potential of MS Office to streamline and elevate professional undertakings. Why buy this Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! is suitable for: Beginners keen on acquainting themselves with the fundamentals of MS Office. Office workers striving for efficiency and streamlined workflows. Students aiming to hone their report and presentation capabilities. Entrepreneurs seeking to optimise business correspondence and documentation. Digital enthusiasts eager to upgrade their software toolkit. Prerequisites This Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! 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 Office Administrator: £18,000 - £25,000 Per Annum Executive Assistant: £25,000 - £40,000 Per Annum Data Analyst: £30,000 - £50,000 Per Annum Project Manager: £40,000 - £60,000 Per Annum Marketing Executive: £22,000 - £30,000 Per Annum IT Support Specialist: £20,000 - £35,000 Per Annum Course Curriculum Introduction INTRO FINAL 00:01:00 Microsoft Word Essentials New Word Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft PowerPoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups in PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in PowerPoint 00:02:00 Closing and Reopening in PowerPoint 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00

The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF 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 Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00

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

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

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Good leadership and management are essential for creating a productive work team. This Leadership and Management course will teach you all the skills and knowledge you need to develop your leadership style and abilities. Whether you're a line manager, coach, or entrepreneur, you will learn valuable strategies and techniques that will help you to create an unbeatable workforce, manage conflict, motivate teams, and ensure that each member is working to their full potential.  This course includes case studies and practical exercises that can be applied to a wide range of professions, covering different leadership models and theories. It covers a number of topics in relation to management, from talent acquisition to providing feedback. You'll also develop your proficiency in key Microsoft Office packages. By the end of this course, you'll not only be equipped with the skills to take your management to the next level, but will also have an excellent understanding of corporate responsibility and ethics, which will every senior member of staff must know. Learning Outcomes: Understand the fundamental differences between leadership and management Familiarise with different leadership theories and leadership models Learn techniques for motivating employees and providing constructive feedback Deepen your understanding of the talent management process Know how to deal with office politics effectively and manage workplace conflict Build your proficiency in Microsoft Office's leading packages Develop your understanding of corporate responsibility and ethics Gain valuable team-building skills to create an unbeatable workforce 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 Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this Course for? This course is ideal for anyone in a management or leadership role who wants to develop their skill set and leadership style to manage teams more effectively. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis. Career Path On successful completion, learners will have a range of skills required to lead teams and individuals effectively, which apply to any management role. These skills are ideal for anyone pursuing any of the following professions: Business Owner Entrepreneur Line Manager Head of Department Project Manager Teacher Tutor Coach Mentor

Unlocking Google Ranking is a comprehensive course designed to empower learners with the knowledge and skills required to master the art of Google My Business and secure top positions in the Google Map Pack. In the age of digital dominance, the significance of Google My Business cannot be overstated, making this course an indispensable asset for anyone seeking to elevate their local business. Dive into this creative and immersive learning journey, and let the world of Google ranking unfold before your eyes. The course starts with an enticing introduction, painting a vivid picture of what lies ahead. As you delve deeper, you'll realize why Microsoft Office is an essential tool in mastering Google My Business. Through meticulously designed lectures, you'll understand the intricacies of setting up your Google My Business page, determining your service distance, selecting the perfect business category, and crafting an enticing business introduction. The course also takes you on a captivating journey into the world of image tagging and insights analysis within Google My Business, helping you optimize your profile to reach that coveted 100% completeness. Unlocking Google Ranking also explores the critical role of reviews in local business success, and it uncovers the secrets to effectively managing and generating reviews. As you progress, you'll appreciate how Microsoft Office can be a game-changer in this domain. The course culminates by guiding you towards mastering the art of ranking in the top three positions in the Google Map Pack, paving the way for unparalleled success in local SEO. Learning Outcomes: Master the setup of Google My Business pages, maximizing their potential for local business growth. Gain an in-depth understanding of the importance of reviews and how to manage and generate them effectively. Unlock the power of Microsoft Office for optimizing your Google My Business profile. Learn the secrets of local SEO and how to secure top positions in the Google Map Pack. Achieve a complete Google My Business profile with 100% optimization, increasing your visibility and attracting more customers. Course Description: Unlocking Google Ranking is a dynamic course that takes you on an educational journey through Google My Business, reviews management, and local SEO. With Microsoft Office as your trusty companion, you'll navigate through a meticulously crafted curriculum, ensuring that you don't miss a single step in your quest to conquer the digital landscape. Who Is This Course For? Small business owners looking to enhance their online presence and attract local customers. Marketing professionals seeking to sharpen their local SEO skills. Entrepreneurs and startups aiming to establish a strong digital footprint. E-commerce businesses desiring better visibility in local search results. Digital marketing enthusiasts eager to explore the world of Google ranking. Certification If you are a newbie to managing a WordPress website, then congratulations! You are here at the right track with us because we are going to introduce you one of the most basic knowledge when owning a WordPress page: how to find your site the best WordPress Hosting service. This process is often overlooked by most of the website owners. But it can be considered the most important key point to bring your site to stand out of the crowd. A great hosting service could help you to improve SEO and increase sales as well. Career path Digital Marketing Manager: £30,000 - £50,000 per annum SEO Specialist: £25,000 - £45,000 per annum Small Business Owner: Earnings vary based on business success Marketing Coordinator: £20,000 - £35,000 per annum E-commerce Manager: £25,000 - £50,000 per annum Freelance SEO Consultant: Hourly rates range from £20 to £100 Course Content Section 1: Introduction To The Course Lecture 1 What To Expect In This Course Lecture 2 Why Having Google My Business is Critical For Every Local Business Section 2: Getting Started With Google My Business Lecture 3 Intro To Google My Business Lecture 4 An Example Google My Business Page Setup Lecture 5 Setting Your Service Distance & Address Lecture 6 Selecting The Best Business Category Lecture 7 Creating a Good Introduction For Your Page Lecture 8 Tagging Photos Inside Of Google My Business or Using Picasa Lecture 9 Bulk Tagging Photos With a Location Lecture 10 Viewing Insights About Your Business Lecture 11 A Completed Google My Business Profile - Getting to 100% Section 3: Getting Reviews For Your Business Lecture 12 Why Reviews Are So Important Lecture 13 Responding To Reviews Lecture 14 Grade.us Lecture 15 The Review Handout Generator Section 4: Ranking In The Top 3 Positions in the Google Map Pack Lecture 16 Where To Go From Here - Learning About Local SEO

A course by Xpert Learning RequirementsA computer or mobile device with an internet connectionA basic understanding of Microsoft Office applicationsA willingness to learn and grow Audience Business Professionals Administrative assistants Project managers Team leaders Office managers Business owners Anyone who wants to advance their career in the workplace Audience Business Professionals Administrative assistants Project managers Team leaders Office managers Business owners Anyone who wants to advance their career in the workplace

The Microsoft Excel course is designed to teach you everything you need to know about Excel from scratch. This comprehensive, instructor-guided training will help you gain a thorough understanding of Excel’s essential features and functions, enabling you to kickstart your career or enhance your current skills. Whether you are just starting out or looking to build on your knowledge, this course will equip you with the most in-demand skills required in today's competitive job market.