Course Badgei dont have words to explain but my overall experience is going well with you guys.
Office Skills Bundle (6 in 1)
This Office Skills bundle comes with 6 online courses.
Created By
1 STUDENTS ENROLLED
Loading video…
Learning Outcome
- Develop your Excel skills to become a confident user
- Understand the most useful and advanced features of Microsoft Excel
- Demonstrate confidence when presenting
- Discover how to speak professionally over the phone by following our step-by-step guide
- Learn How to Greet Customers Professionally
- Negotiate effectively by mastering the art of bargaining
Course Overview
Mastering essential office skills can significantly improve your professional effectiveness, did you know?
You can upgrade your office skills in this comprehensive Office Skills Package that combines six must-have courses. Here is the list of courses:
- Excel Training: Advanced Tricks & Techniques
- Ultimate Microsoft Excel Course: Beginner to Excel Expert
- Presentation Skills
- Telephone Etiquette
- Customer Care and,
- Negotiation Skills.
This bundle enables you to become an Excel guru, improve your presentation skills, or sharpen your communication and negotiation skills to excel in various office environments. The bundle covers everything from advanced Excel functionality to public speaking, telephone etiquette, customer service, and negotiation skills. Take your career to new heights with our Office Skills Bundle and stand out in the workplace
Course Description
This course is an excellent learning opportunity for those who are passionate about the topic and who are interested in a successful career within the relevant industry. Professionals currently working in this field who wish to brush up on their knowledge and advance their careers may also enrol in this program.
In the Office Skills Bundle (6 in 1) Course, you will find a number of engaging, in-depth modules that will provide you with comprehensive theoretical knowledge that will enable you to succeed in your career. As proof of your completion, you will receive a free e-certificate from Learndrive.
Using computers, tablets, smartphones, and other internet-enabled devices, you can access the course modules at your own pace. Invest in your professional development today and learn skills that will lead to your dream job. Become a career leader by taking this course online.
What Do You Get With The Office Skills Bundle (6 in 1) Course?
- Premium Video Materials in bite-sized format for the most accessible learning experience
- Free e-certificate after completing the course
- Flexible study time and pace
- Instructor-led Course
Course Design
Students can access the course using any internet-connected device through our online learning platform. You may study at your own pace since there are no formal deadlines or teaching schedules.
Certification
The learners who pass the course will receive a Learndrive Certificate as a badge of accomplishment. The e-certificate is free of charge. There is a small fee, however, if you want a hard copy of your certificate.
Who Is This Course For?
The course is right for you if you already work in this industry or want to make the transition. This Office Skills Bundle (6 in 1) Course is designed to enhance your expertise and improve your CV.
Requirements
Students from all backgrounds are welcome to participate in the online training. There are no requirements for participation. The only prerequisite for studying this Office Skills Bundle (6 in 1) Course is an interest in learning and a good grasp of English, mathematics, and computer skills.
Course Instructor
Alan Murray
Alan Murray is an Excel trainer and a Microsoft MVP. His training expertise spans over 20 years, and he has worked with businesses all over the world. In addition to his blog and YouTube channel, Alan is the founder of Computergaga. His YouTube channel has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials on this channel. He is the author of the book entitled “Advanced Excel Success”, in which he provides specific information on how to take your Excel ability to the next level. Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses.
Accreditation
This course is accredited by CPDQE. The demand for professionals to engage in Continuing Professional Development is escalating, irrespective of the industry, career stage, or job function. CPD serves as an impactful mechanism for skill enhancement, maintaining the relevance of academic credentials, and strategically advancing one’s career.
This CPDQE Certified Course will ensure that you have obtained the required CPD trainings for your professional development.
What Students say about us
The courses on the website are well designed, very clear and you can learn a lot of useful skills from them. A very
Enjoying the course at my pace, repeating what I did not understand and learning
Frequently Asked Questions
Everything you need to now about he product billing.
To purchase a course, simply select the course you want, choose your plan from the top right side, and click on the ‘Take this course’ button to initiate the checkout process. You will receive access as soon as the payment is processed.
We accept various payment methods, including credit/debit cards, PayPal, and bank transfer. If you don’t have a card or paypal, contact us for alternative payment methods.
If you’re not satisfied with our course, you can request a refund within 14 days of purchase. We follow a no-questions-asked refund policy, and you will receive a full refund.
Yes, upon successful completion of the course and exam (if applicable), you will receive a free digital certificate that can be downloaded and printed.
Yes, our courses are CPDQE accredited. CPDQE is an independent body that accredits courses and events for continuous professional development, ensuring they meet high-quality standards.
You can verify your certificate by visiting the Learndrive certificate verification page and entering your certification code. This will confirm the authenticity of your certificate.
To redeem your voucher, first visit the voucher redemption page. Enter your personal details and paste the voucher code into the designated field (do not type the code manually). After that, click the “Send” button. You will receive your login details via the email address you provided. Once you have received them, log in to our website and access your course from your dashboard.
Course Curriculum
| Course 01: Ultimate Microsoft Excel Course: Beginner to Excel Expert | |||
| Section 1: Introduction | |||
| Introduction to the Ultimate Excel Course | 00:04:00 | ||
| Section 2: Working with Large Worksheets | |||
| Keeping your Headings Visible as you Scroll | 00:04:00 | ||
| Splitting a Worksheet to Reference Two Different Areas | 00:04:00 | ||
| Hiding and Unhiding Columns | 00:03:00 | ||
| Sorting a Large List – Including a Super Shortcut | 00:07:00 | ||
| Filtering a List – One of the Most Useful Excel Skills | 00:08:00 | ||
| Section 3: 5 Essential Tricks for Printing Spreadsheets | |||
| Scaling a Print to Fit onto Fewer Pages | 00:06:00 | ||
| Repeating your Headers Across Multiple P | 00:04:00 | ||
| Printing a Selected Range and Setting a | 00:05:00 | ||
| Aligning a Print on a Page | 00:03:00 | ||
| Using Page Breaks to Logically Break Up | 00:05:00 | ||
| Section 4: Getting Started with Excel Formulas | |||
| Introduction to Formulas – Writing your First Exc | 00:08:00 | ||
| The Order Of Calculation-BODMAS | 00:04:00 | ||
| Calculating Percentages | 00:08:00 | ||
| Unleash the Power of Excel Functions | 00:09:00 | ||
| Referencing Other Sheets and Workbooks | 00:12:00 | ||
| Calculating Date Difference including Working Day | 00:09:00 | ||
| understand Absolute Cell Addresses | 00:07:00 | ||
| The COUNTIF Function-An Incredibly Useful Function | 00:14:00 | ||
| Section 5: Logical Functions: The Decision Making Formulas of Excel | |||
| IF Function 1 | 00:05:00 | ||
| IF Function 2 | 00:04:00 | ||
| IF Function 3 | 00:05:00 | ||
| Nested IFS | 00:05:00 | ||
| AND and OR Functions | 00:07:00 | ||
| TNo More Nested IFS | 00:05:00 | ||
| The Switch Function | 00:09:00 | ||
| Section 6: Conditional Formatting - Make your Data Come to Life | |||
| Create your First Conditional Fo | 00:07:00 | ||
| Managing Multiple Rules | 00:08:00 | ||
| Highlight Expired And Due Dates | 00:08:00 | ||
| cc | 00:07:00 | ||
| Create a Heat Map | 00:03:00 | ||
| Using Icon Sets | 00:08:00 | ||
| Entire Row | 00:05:00 | ||
| Testing Multiple Conditions | 00:07:00 | ||
| Section 7: Dynamic Array Functions - Formulas Have Changed | |||
| Introduction to dynamic Arrays | 00:12:00 | ||
| The UNIQUE Function | 00:09:00 | ||
| The SORT Function | 00:09:00 | ||
| The SORTBY Function | 00:07:00 | ||
| The FILTER Function | 00:20:00 | ||
| The SEQUENCE Function | 00:11:00 | ||
| Section 8: Lookup Functions - The Powerful VLOOKUP Function and beyond | |||
| The VLOOKUP Function Expl | 00:07:00 | ||
| Using VLOOKUP for a Range | 00:06:00 | ||
| Advanced VLOOKUP | 00:09:00 | ||
| Handling Error Messages | 00:06:00 | ||
| The INDEX and MATCH Comb | 00:07:00 | ||
| INDEX and MATCH | 00:05:00 | ||
| Return Non Adjacent Column | 00:07:00 | ||
| XLOOKUP Function | 00:12:00 | ||
| Multi-Column Lookup | 00:04:00 | ||
| Two-Way Lookup | 00:05:00 | ||
| Section 9: Validating and Protecting Excel Data | |||
| Number Of Characters | 00:03:00 | ||
| Create Date Validation Rules | 00:03:00 | ||
| Drop Down Lists | 00:05:00 | ||
| Dependent Lists | 00:06:00 | ||
| Data Validation Messages | 00:07:00 | ||
| Encrypt a File | 00:03:00 | ||
| Protect Workbook | 00:06:00 | ||
| Protect Worksheet | 00:08:00 | ||
| Section 10: Advanced Formulas for Analysing Data | |||
| Using SUMIF, COUNTIF and AVERAGEIF | 00:08:00 | ||
| Summing the Values between Two Dates | 00:06:00 | ||
| Advanced Sum Formula with SUMPRODUCT | 00:06:00 | ||
| SUMPRODUCT Example 2 | 00:10:00 | ||
| Secret AGGREGATE Function | 00:08:00 | ||
| Advanced AGGREGATE | 00:05:00 | ||
| Section 11: Charts - Simple and Effective Data Presentation | |||
| First-Charts | 00:08:00 | ||
| Chart-Elements | 00:06:00 | ||
| Formatting Charts | 00:07:00 | ||
| Modidy the Charts Axis | 00:08:00 | ||
| Chart Templates | 00:05:00 | ||
| Combo Charts | 00:07:00 | ||
| Chart-Filters | 00:03:00 | ||
| Interactive Charts | 00:08:00 | ||
| Using Cell Values for Chart Labels | 00:05:00 | ||
| Conditional-Formatting with Charts | 00:08:00 | ||
| Sparklines | 00:06:00 | ||
| Section 12: Manipulating Text in Excel | |||
| Splitting Text across Multiple Columns | 00:08:00 | ||
| Concat and Concatenate Functions | 00:07:00 | ||
| The TEXTJOIN Function | 00:05:00 | ||
| Extracting Text from a Cell | 00:10:00 | ||
| MID and FIND Functions | 00:08:00 | ||
| Value Function | 00:04:00 | ||
| Substitute Function | 00:08:00 | ||
| Flash Fill Tool | 00:11:00 | ||
| Section 13: Formatting your Data Ranges as Tables for Easier Management | |||
| Formatting as a Table | 00:04:00 | ||
| Benefits of Using Table | 00:08:00 | ||
| Creating Table Style | 00:05:00 | ||
| Formulas Using a Tables | 00:07:00 | ||
| Back to a Normal Range | 00:02:00 | ||
| Section 14: Master PivotTables for Powerful Analysis and Reporting | |||
| Creating a PivotTable | 00:09:00 | ||
| Values Function | 00:04:00 | ||
| Formatting Values | 00:03:00 | ||
| PivotTable Style | 00:06:00 | ||
| Sorting PivotTable | 00:03:00 | ||
| Grouping Data | 00:05:00 | ||
| Showing Values | 00:06:00 | ||
| Conditional Formatting | 00:04:00 | ||
| Filtering PivotTable Data | 00:04:00 | ||
| Refreshing a PivotTable | 00:05:00 | ||
| Creating a Pivotchart | 00:06:00 | ||
| Slicers | 00:12:00 | ||
| Timeline | 00:03:00 | ||
| Section 15: Getting and Transforming Data with Power Query | |||
| What is Power Query | 00:04:00 | ||
| Merge-Queries-2 | 00:07:00 | ||
| Messy Data | 00:22:00 | ||
| Unpivot | 00:07:00 | ||
| Merge Queries-1 | 00:10:00 | ||
| Combine and Append | 00:11:00 | ||
| Section 16: Working with the Data Model and PowerPivot | |||
| Introduction PowerPivot | 00:07:00 | ||
| Creating Relationships | 00:08:00 | ||
| Creating PivotTable | 00:06:00 | ||
| PowerPivot Adding | 00:02:00 | ||
| Setting Locales | 00:10:00 | ||
| PowerPivot Window | 00:05:00 | ||
| Calculated columns | 00:08:00 | ||
| Measures | 00:11:00 | ||
| Multiple Files From Folder | 00:16:00 | ||
| Importing Data From web | 00:13:00 | ||
| Bonus Materials | |||
| installing-power-query-add-in [Download] | 00:05:00 | ||
| ultimate-excel-course-exercises [Download] | 00:05:00 | ||
| Final Quiz: Ultimate Microsoft Excel Course: Beginner to Excel Expert | |||
| Final Quiz: Ultimate Microsoft Excel Course: Beginner to Excel Expert | 00:10:00 | ||
| Course 02: Excel Training: Advanced Tricks & Techniques | |||
| Section 1: Introduction | |||
| Introduction and What to Expect | 00:03:00 | ||
| Section 2: Neat Tricks to Supercharge your Productivity | |||
| 10 Paste Special Tricks used by the Pros | 00:12:00 | ||
| Excel’s Best kept secret and 3 ways to Use It | 00:07:00 | ||
| The Unsung Hero of Excel for Cleaning Messy Data | 00:12:00 | ||
| Edit Multiple Sheets at the Same Time with Ease | 00:05:00 | ||
| 5 Reasons your Excel Formulas are not Calculating | 00:06:00 | ||
| TOP SECRET – How to Make Sheets VERY Hidden | 00:05:00 | ||
| My Favourite Excel Shortcuts | 00:11:00 | ||
| Section 3: Using Wildcards with Formulas | |||
| Using Wildcards with VLOOKUP | 00:04:00 | ||
| Using wildcards with COUNTIF and SUMIF | 00:03:00 | ||
| Validate that Text is a Specific Number of Characters | 00:04:00 | ||
| Section 4: The Awesome SUMPRODUCT Function - The Swiss Army Knife of Functions | |||
| The Definitive Guide to the SUMPR | 00:08:00 | ||
| Example 1-Count and Sum the Sales | 00:07:00 | ||
| Example 2 – Count the Occurrences | 00:05:00 | ||
| Example 3-Count the Unique Values | 00:04:00 | ||
| Example 4 – Sum the Top 3 Values | 00:03:00 | ||
| Example 5 – Sum the Last 6 Values Only | 00:05:00 | ||
| Section 5: Advanced PivotTable Tricks | |||
| Two Reasons your PivotTable Counts instead of Sums | 00:07:00 | ||
| You Must Do this One Thing | 00:07:00 | ||
| Grouping Dates and Times | 00:10:00 | ||
| Using the GETPIVOTDATA Function to Pull Data from a PivotTable | 00:10:00 | ||
| Going Beyond the Sum-3 More PivotTable Calculations | 00:10:00 | ||
| Calculating the Difference to Previous Years Months Weeks | 00:06:00 | ||
| Create Your Own Calculated Fields | 00:04:00 | ||
| Using Conditional Formatting with PivotTables | 00:07:00 | ||
| Using Conditional Formatting with PivotTables | 00:07:00 | ||
| Five Useful PivotTable Settings | 00:09:00 | ||
| The Power of Slicers | 00:11:00 | ||
| 7 Slicer Settings you Will Want to Change | 00:09:00 | ||
| Section 6: The Hidden Power of the MOD Function | |||
| An Introduction to the MOD Function | 00:02:00 | ||
| Example 1- Extracting the Time from a Date-Time Cell | 00:03:00 | ||
| Example 2 – Prevent the Entry of Odd Numbers in a Range | 00:03:00 | ||
| Example 3- Calculate Total Balls Bowled from Overs in Cricket | 00:04:00 | ||
| Example 4 – Sum Every 3rd Row in a List | 00:07:00 | ||
| Section 7: The Magic of the INDIRECT Function | |||
| Example 1 – INDIRECT with Named Ranges | 00:03:00 | ||
| Ezample 2 – Referencing other sheets with Indirect | 00:05:00 | ||
| Example 3 – Return the Last Value from a Row | 00:05:00 | ||
| Example 4 – INDIRECT with VLOOKUP | 00:03:00 | ||
| Example 5 – Create Dependent Drop Down Lists | 00:04:00 | ||
| Section 8: The Incredible INDEX Function | |||
| Example 1 – Using INDEX and MATCH for an Advanced Lookup | 00:12:00 | ||
| Lecture 48 Example 2 – Create a Picture Lookup | 00:08:00 | ||
| Example 3 – Return the Value from the Last Row | 00:03:00 | ||
| Example 4 – Create a Dynamic Named Range | 00:13:00 | ||
| Example 5 – Sum the Last 6 Values Only | 00:05:00 | ||
| Example 6 – Retrieve a Range from a List of Ranges | 00:06:00 | ||
| Section 9: COUNTIF Function - A Mega Useful Excel Function | |||
| Using Cell Values with COUNTIF | 00:05:00 | ||
| Count values Between Two Dates | 00:03:00 | ||
| Prevent Duplicates in a Range | 00:05:00 | ||
| Compare Two Lists to Identify Missing Items | 00:05:00 | ||
| VLOOKUP for the Last Match in a List | 00:08:00 | ||
| Uniquely Rank Items | 00:05:00 | ||
| Section 10: Introducing Custom Number Formatting | |||
| Combine Text and Numbers in a Cell | 00:04:00 | ||
| Show the Weekday of a Date | 00:03:00 | ||
| Keep the Leading Zeroes of a Value | 00:04:00 | ||
| Display Negative Values in Red | 00:04:00 | ||
| Show Zero Values as Blank Cells | 00:03:00 | ||
| Section 11: Advanced Custom Formatting Examples that Users did not know was Possible | |||
| Display Symbols | 00:08:00 | ||
| Conditional Colour | 00:06:00 | ||
| Setting Thresholds | 00:05:00 | ||
| Section 12: Advanced Chart Tricks for Dynamic Interactive Charts | |||
| The Easiest Way to Create a Dynamic Data | 00:05:00 | ||
| Drop Down Menu to Select a Chart | 00:07:00 | ||
| Get Creative by Building a Dynamic Chart Title | 00:08:00 | ||
| Highlight the Max and Min Values Differently | 00:08:00 | ||
| Create a Scrollable Chart | 00:14:00 | ||
| Use Cell Values for Data Labels to Show | 00:05:00 | ||
| Rolling Chart for the Last 6 Months Only | 00:10:00 | ||
| Visualise Targets v’s Actuals | 00:04:00 | ||
| Using Check boxes to ShowHide Chart Data | 00:06:00 | ||
| Bonus Materials | |||
| advanced-excel-tricks-exercises [Download] | 00:05:00 | ||
| custom-number-format-characters | 00:03:00 | ||
| custom-number-format [Download] | 00:05:00 | ||
| Final Quiz: Excel Training: Advanced Tricks & Techniques | |||
| Final Quiz: Excel Training: Advanced Tricks & Techniques | 00:10:00 | ||
| Course 03: Presentation Skills | |||
| Course Content | |||
| Introduction to the Course – Presentation Skills for Beginners | 00:02:00 | ||
| Tips to Improve Your Presentation Skills | 00:05:00 | ||
| The Secret of Presentation Skills | 00:03:00 | ||
| Never Waste Time Starting a Presentation Again – Presentation Skills | 00:02:00 | ||
| You Can Get the Audience to Do What You Want – Presentation Skills | 00:04:00 | ||
| Never Be Convicted of Death by PowerPoint – Presentation Skills | 00:04:00 | ||
| The Easy Way to Tell Relevant Stories – Presentation Skills | 00:06:00 | ||
| Your Own Free Focus Group – Presentation Skills | 00:04:00 | ||
| The Most Efficient Way to Practice You Presentation Skills – Presentation Skills | 00:03:00 | ||
| Passing the Ultimate Test – Presentation Skills | 00:03:00 | ||
| Now You Have Earned Personal Coaching – Presentation Skills | 00:02:00 | ||
| Conclusion- You are No Longer a Beginner at Presentation Skills – Presentation Skills | 00:02:00 | ||
| Final Quiz: Presentation Skills | |||
| Final Quiz : Presentation Skills | 00:30:00 | ||
| Course 04: Telephone Etiquette | |||
| Module 1: Introduction & Aspects of Telephone Etiquette | |||
| Introduction & Aspects of Telephone Etiquette | 00:08:00 | ||
| Module 2: Talking The Right Way On The Phone | |||
| Talking The Right Way On The Phone | 00:10:00 | ||
| Module 3: How to Eliminate Phone Distractions | |||
| How to Eliminate Phone Distractions | 00:06:00 | ||
| Effects of Destruction | 00:07:00 | ||
| Module 4: Inbound & Outbound Calls | |||
| Inbound & Outbound Calls | 00:08:00 | ||
| Module 5: Dealing With Angry Customers | |||
| Dealing With Angry Customers | 00:07:00 | ||
| Module 6: Voicemail Messages & Interoffice Calls | |||
| Voicemail Messages & Interoffice Calls | 00:08:00 | ||
| Transferring calls and Messages | 00:05:00 | ||
| Module 7: Methodology for Training Employees | |||
| Methodology for Training Employees | 00:09:00 | ||
| Final Quiz: Telephone Etiquette | |||
| Final Quiz: Telephone Etiquette | 00:20:00 | ||
| Course 05: Customer Care | |||
| Module 1: Introduction to Customer Care | |||
| Introduction to Customer Care | 00:09:00 | ||
| Module 2: Providing Great Customer Care Service | |||
| Providing Great Customer Care Service | 00:08:00 | ||
| Module 3: Service Model & Defusing Techniques | |||
| Service Model & Defusing Techniques | 00:05:00 | ||
| Module 4: Customer Management | |||
| Customer Management | 00:08:00 | ||
| Module 5: Building Customer Rapport | |||
| Building Customer Rapport | 00:07:00 | ||
| Module 6: Greeting Customers Professionally | |||
| Greeting Customers Professionally | 00:07:00 | ||
| Final Quiz: Customer Care | |||
| Final Quiz: Customer Care | 00:10:00 | ||
| Course 06: Negotiation Skills | |||
| Module 1 An Understanding of Negotiation | |||
| An Understanding of Negotiation | 00:09:00 | ||
| Module 2 The Preparation Process | |||
| The Preparation Process | 00:09:00 | ||
| Module 3 Building The Foundation | |||
| Building The Foundation | 00:09:00 | ||
| Module 4 Phase One — Exchanging Information | |||
| Phase One — Exchanging Information | 00:06:00 | ||
| Module 5 Phase Two — Bargaining | |||
| Phase Two — Bargaining | 00:05:00 | ||
| Few more of Phase Two | 00:08:00 | ||
| Module 6 Phase Three — Closing | |||
| Phase Three — Closing | 00:07:00 | ||
| Module 7 How To Deal With Difficult Situations | |||
| How To Deal With Difficult Situations | 00:07:00 | ||
| Module 8 Adapting Negotiation By Communication | |||
| Adapting Negotiation By Communication | 00:10:00 | ||
| Handouts | |||
| An Understanding of Negotiation | 00:03:00 | ||
| The Preparation Process | 00:03:00 | ||
| Building The Foundation | 00:03:00 | ||
| Phase One — Exchanging Information | 00:03:00 | ||
| Phase Two — Bargaining | 00:03:00 | ||
| Phase Three — Closing | 00:03:00 | ||
| How To Deal With Difficult Situations | 00:03:00 | ||
| Adapting Negotiation By Communication.pdf | 00:03:00 | ||
| Final Quiz: Negotiation Skills | |||
| Final Quiz: Negotiation Skills | 00:20:00 | ||
Course Reviews
No Reviews found for this course.
