2693 Office Skills & Productivity courses in Nottingham delivered On Demand

Learn to build an HR Dashboard using Excel with our comprehensive course. From data introduction to designing index and tabs, analyze employee data effectively using pivot tables and charts. Ideal for HR professionals and analysts looking to create insightful dashboards for HR metrics and analysis.

Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Microsoft Office 2016 Excel Beginner to Advanced Course Description At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate 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.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Receptionist Office Admin Data entry Officer Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

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

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.

Are you ready to embark on an enlightening journey of wisdom with the Data Analytics & Database Development Using SQL bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analytics & Database Development Using SQL. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Data Analytics Course 2: SQL Database Basics for Everyone Course 3: SQL for Data Science, Data Analytics and Data Visualization Course 4: Microsoft Access Databases Forms and Reports Course 5: Microsoft SQL Server Development for Everyone! Course 6: Python Programming from Scratch with My SQL Database Course 7: Google Data Studio: Data Analytics Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analytics & Database Development Using SQL bundle illuminate your path to wisdom. The Data Analytics & Database Development Using SQL bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across five carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analytics & Database Development Using SQL package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analytics & Database Development Using SQL bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analytics & Database Development Using SQL community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analytics & Database Development Using SQL Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analytics & Database Development Using SQL bundle. Establish robust bases across each course nestled within the Data Analytics & Database Development Using SQL bundle. Decipher intricate concepts through the articulate content of the Data Analytics & Database Development Using SQL bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analytics & Database Development Using SQL bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analytics & Database Development Using SQL bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analytics & Database Development Using SQL bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analytics & Database Development Using SQL bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analytics & Database Development Using SQL bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analytics & Database Development Using SQL journey and let knowledge guide you towards a brighter future. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analytics & Database Development Using SQL Bundle. Career path Armed with the Data Analytics & Database Development Using SQL bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analytics & Database Development Using SQL bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Step confidently into a rewarding UK career with our transformative "Python Bootcamp: JavaScript, HTML & CSS Coding" bundle. This bundle covers everything from honing your Python proficiency to crafting interactive web designs with HTML and CSS and developing dynamic applications using JavaScript. Uncover the secrets of Python's application in data science, machine learning, and neural networks. Establish a strong foundation in C# coding and exploring networking, GUI development, XML handling, and more. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: The Complete Python 3 Course: Beginner to Advanced! Course 02: JavaScript for Everyone Course 03: HTML and CSS Coding: Beginner to Advanced Course 04: Basic C# Coding Course 05: Python Data Science with Numpy, Pandas and Matplotlib Course 06: Deep Learning & Neural Networks Python - Keras Course 07: Complete Python Machine Learning & Data Science Fundamentals Course 08: Python Programming Bible | Networking, GUI, Email, XML, CGI Our comprehensive Python Bootcamp: JavaScript, HTML & CSS Coding bundle ensure you're well-prepared for diverse tech challenges. Elevate your UK career prospects with hands-on learning and real-world applications. Embrace the "Python Bootcamp: JavaScript, HTML & CSS Coding" bundle for an all-encompassing skill set bound to make you a standout in the dynamic UK job landscape. Learning Outcomes Progress from beginner to advanced Python proficiency. Craft dynamic websites using HTML and CSS. Develop user-friendly web applications with JavaScript. Analyze data using Numpy, Pandas, and Matplotlib. Explore neural networks with Python's Keras. Gain practical machine learning expertise. Unleash your potential with our comprehensive Python Bootcamp: JavaScript, HTML & CSS Coding bundle that promises to transform your career trajectory. In the rapidly evolving tech landscape, Python proficiency stands as a cornerstone of success. From web development to data analysis and machine learning, Python is the language that opens doors to countless opportunities. Our Python Bootcamp: JavaScript, HTML & CSS Coding bundle ensures you learn and master Python, securing your place at the forefront of innovation. Harness the expertise of excellent instructors who unravel the complexities of Python in a relatable and engaging manner. Dive into dynamic web design, crafting seamless interfaces with HTML and CSS, and building interactive web applications using JavaScript.Take the plunge into deep learning, understanding the intricacies of neural networks through Python's Keras library. As you progress, embrace the fundamental principles of machine learning, propelling your career to new heights. The time to seize the moment is now. The "Python Bootcamp: JavaScript, HTML & CSS Coding" bundle equips you with indispensable skills, empowering you to stand out in a competitive job market. Whether a newcomer or a seasoned professional, this Python Bootcamp: JavaScript, HTML & CSS Coding bundle ensures you're ready to conquer challenges and grasp opportunities. Embrace the power of Python today, and let it shape a future of endless possibilities. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Beginners to advanced learners. HTML, CSS, and JavaScript skills. Master Python programming. Numpy, Pandas, and data science. Diverse tech skill acquisition. Deep learning and machine learning Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Web Developer: £25,000 - £50,000 Python Programmer: £30,000 - £60,000 Data Analyst: £25,000 - £45,000 Front-End Developer: £25,000 - £50,000 UI/UX Designer: £30,000 - £50,000 Machine Learning Engineer: £40,000 - £70,000 Full-Stack Developer: £35,000 - £60,000 Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the Management Consultant bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Management Consultant. Delve into eight immersive CPD Accredited courses, each a standalone course: Management Skills for New Managers Essentials of Becoming a Manager and Managing Teams Business Management Business Plan HR Management Course Office Administration Operations Management Corporate & Strategic Communication Skills for Managers Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Management Consultant bundle illuminate your path to wisdom. The Management Consultant bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Management Consultant package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Management Consultant bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Management Consultant community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Management Consultant bundle. Establish robust bases across each course nestled within the Management Consultant bundle. Decipher intricate concepts through the articulate content of the Management Consultant bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Management Consultant bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Management Consultant bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Management Consultant bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Management Consultant bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Management Consultant bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Management Consultant journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Management Consultant bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Management Consultant bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Master the art of hybrid team management with our comprehensive course. Learn effective techniques for transitioning, team building, and driving high performance in a hybrid work environment. Elevate your leadership skills and optimize your team’s effectiveness in today’s dynamic work landscape.

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.