3616 Office Skills & Productivity courses

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Build your communication skills to boost the productivity of office administration. Learn Business Etiquette, Organisational Skills, Effective Planning and Scheduling.

Gain advanced administrative, secretarial, and PA skills with our Level 5 course. Enhance your professional capabilities and excel in a dynamic work environment.

Do you know what the key skills graduate employers look for? Most employers often emphasise on industry-standard skills

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Course Overview Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you've come to the right place! Our easy-to-follow Workplace Productivity Hacks will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept - from the fundamental to the more advanced aspects of the course.  Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future. Learning Outcomes Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge. Entry Requirement This course is available to all learners of all academic backgrounds.Learners should be aged 16 or over to undertake the qualification.Some basic understanding of the English language and numeracy. 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. Will I receive a certificate of completion? After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Career path Workplace Productivity Hacks is a useful qualification to possess and would be beneficial for any related profession or industry. Course Curriculum Module 01: Ways to Improve Workplace Productivity Ways to Improve Workplace Productivity 00:41:00 Module 02: Organisational Skills to Improve Productivity Organisational Skills to Improve Productivity 00:21:00 Module 03: Productive Communication Skills in the Workplace Productive Communication Skills in the Workplace 00:29:00 Module 04: Time Management Time Management 00:41:00 Module 05: Conflict Management Conflict Management 00:16:00 Module 06: Health, Safety and Wellness in the Workplace Health, Safety and Wellness in the Workplace 00:29:00 Module 07: Managing Stress and Coping Anxiety in the Workplace Managing Stress and Coping Anxiety in the Workplace 00:28:00

Microsoft Excel® in Depth (In-Person) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth (Virtual) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables