1291 Courses delivered Online

Enhance your accounting skills and proficiency in Microsoft Excel with our Accounts Clerk and MS Excel Training course. Learn the fundamentals of bookkeeping, accounting principles, and Excel functions. Ideal for aspiring accounts clerks and professionals seeking to improve their Excel proficiency for efficient data management and analysis.

From beginner to expert, this course will help you advance your career using Microsoft Excel skills.

A special focus will be put on advanced MS Excel tips and tricks for career advancement in this course.

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? 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 Sales Analysis in Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales Analysis in 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 Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum Course Curriculum 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 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 Welcome to the Course 00:03:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 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 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 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

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special SharePoint Site Owner Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The SharePoint Site Owner Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This SharePoint Site Owner Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This SharePoint Site Owner Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this SharePoint Site Owner? 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 SharePoint Site Owner there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SharePoint Site Owner course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill.   Prerequisites This SharePoint Site Owner does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SharePoint Site Owner 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 SharePoint Site Owner is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum SharePoint Site Owner Module 01: Microsoft SharePoint overview 00:09:00 Module 02: Screen tour 00:10:00 Module 03: Adding logos and colours to your site 00:01:00 Module 04: Adding users 00:06:00 Module 05: Adding groups 00:08:00 Module 06: Adding apps to your site 00:03:00 Module 07: Setting up your links 00:14:00 Module 08: Adding and changing pages 00:04:00 Module 09: Setting up your document libraries 00:06:00 Module 10: Uploading and downloading documents 00:06:00 Assignment Assignment - SharePoint Site Owner 00:00:00

Embark on a transformative journey into the heart of collaborative digital workplaces with our dynamic course, 'Learn the Fundamentals of Microsoft SharePoint.' Unveil the power of SharePoint as you traverse through meticulously crafted lessons, each a key to unlocking the full potential of this versatile platform. From creating seamless team sites to integrating with Microsoft Teams, this course is your gateway to mastering SharePoint's intricacies. Dive into the world of web part customization, site management, and effective collaboration, ensuring that every minute spent in this course adds a valuable layer to your skill set. Whether you're a budding professional or a seasoned enthusiast, join us in demystifying SharePoint and reshaping the way you collaborate and manage content. Learning Outcomes Gain a comprehensive understanding of SharePoint's core features and functionalities. Master the art of creating and customizing team sites, fostering efficient collaboration. Explore advanced concepts like web part addition, layout editing, and section customization. Learn to seamlessly integrate Microsoft Teams with SharePoint for enhanced communication. Acquire the skills to manage site access, create news posts, and utilize SharePoint as a communication hub. Why choose this Learn the Fundamentals of Microsoft SharePoint 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 Learn the Fundamentals of Microsoft SharePoint course for? Professionals aiming to enhance their digital collaboration skills. Individuals seeking a comprehensive grasp of Microsoft SharePoint fundamentals. Team leaders looking to optimize team sites and streamline content management. Project managers wanting to leverage SharePoint for efficient project collaboration. Anyone interested in harnessing the power of Microsoft Teams and SharePoint integration. Career path SharePoint Administrator: £30,000 - £50,000 Digital Collaboration Specialist: £35,000 - £55,000 Project Manager (SharePoint): £40,000 - £60,000 IT Support Specialist: £25,000 - £45,000 Business Analyst (Collaboration Tools): £35,000 - £55,000 Information Architect: £45,000 - £70,000 Prerequisites This Learn the Fundamentals of Microsoft SharePoint does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn the Fundamentals of Microsoft SharePoint 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 Learn The Fundamentals Of Microsoft PowerPoint Lesson 01: What is Sharepoint? 00:02:00 Lesson 02: The SharePoint LookBook 00:02:00 Lesson 03: Getting Sharepoint and home page overview 00:02:00 Lesson 04: Create a new team site 00:03:00 Lesson 05: Team site home page 00:02:00 Lesson 06: Uploading files 00:03:00 Lesson 07: Creating a New List 00:06:00 Lesson 08: Adding web parts 00:04:00 Lesson 09: Reorganising and customising web parts 00:02:00 Lesson 10: Republish the team site 00:01:00 Lesson 11: Add members to the team site 00:02:00 Lesson 12: Microsoft Teams & SharePoint integration 00:06:00 Lesson 13: Create a new communication site 00:02:00 Lesson 14: Add countdown timer web part 00:03:00 Lesson 15: Edit web part layouts 00:02:00 Lesson 16: Edit sections 00:03:00 Lesson 17: Add Youtube web part 00:01:00 Lesson 18: Change page look and edit top navigation 00:03:00 Lesson 19: Create a News post 00:03:00 Lesson 20: Manage Site Access 00:01:00

Learn Excel for Business Accounting with our comprehensive course. From basic worksheet creation to advanced functions like pivot tables, charts, and data analysis, master Excel's features for efficient accounting tasks. Ideal for business professionals and students looking to enhance their Excel skills for financial management.

Register on the Advanced Diploma in Microsoft Excel today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced Diploma in Microsoft Excel is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced Diploma in Microsoft Excel Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced Diploma in Microsoft Excel, 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.