- Full Price
- 919 QR
- You Save
- 870 QR
Fine Print
- Valid from 13 Aug – 13 Oct 2024
- Redemption period: TWO months from the deal’s start date
- ONE-year course access upon activation
- Refunds/cancellations are NOT permitted once the voucher has been redeemed
- One voucher per person
- May buy multiple vouchers as gifts
- At the successful completion of this course, learners may order a soft copy of the Certificate of Completion from Course Gate by paying only £4.99; for a printed hard copy of the certificate, learners have to pay £9.99 (shipping charges apply)
- For information/inquiries, visit: 50 Essential Tips for Excel contact via https://coursegate.co.uk/contact-us-course-gate/
- Internet access and audio required
- Not valid with other offers
- No cash value/No cash back/No refunds
How to Redeem:
- Go to https://coursegate.co.uk/redeem-voucher/
- Fill in the form
- Click SUBMIT
- Start the course
Please see the terms for all deals here
Highlights
50 Essential Microsoft Excel Tips Online Course
Pay QR49 instead of QR919
Take Your Excel Skills to the Next Level! This comprehensive online course equips you with 50 essential tips & tricks to transform your Excel experience, whether you’re a beginner mastering the basics or an experienced user seeking advanced techniques!
Boost your productivity:
- Essential tips: Camera Tool, Advanced Copy-Paste, Navigation shortcuts, and more.
- Streamline your workflow: Learn Absolute Cell References, Importing data from web pages, Status Bar Quick Calculations, and more.
Dive deeper & simplify complex tasks:
- Worksheet Grouping, Slicers, Advanced Filter, and time-saving Shortcut Keys
Enhance data analysis & presentation:
- Explore advanced features like Emailing as PDF, Synchronous Scrolling, Quick Analysis, and Custom Views
Solidify your Excel mastery:
- Master advanced formulas, plotting Average Lines, Excel Array Formulas, and creating Forecast Sheets.
This online class is recognized & accredited by CPD Quality Standards, ensuring the accuracy & reliability of all content, while also adding valuable competencies & qualifications to your profile!
See below for the full course outline!
Fill the world with perfect smiles!
Course Outline:
Introduction
Excel Productivity Tips – Part 1
- Camera Tool
- Add Line Break in Formula Bar
- Advanced Copy-Paste using Office Clipboard
Navigation between Worksheets using Shortcut Keys - Flash Fill
- Add Multiple Rows and Columns Quickly
- Delete Blank Rows
- Multi Level Row and Column Sorting
- Add Sparklines
- Paste Special – Transpose
Excel Productivity Tips – Part 2
- Snap to Grid
- Create Custom Autofill List
- Absolute Cell Reference
- Import Data from a Web page
- Import Data from a Web page
- Move Cell Direction
- Delete Data using Mouse
- Status Bar Quick Calculations
- Link Text Boxes to Cell
- Phone Number and ZIP Code Format
- Speaking Cell
Excel Productivity Tips – Part 3
- Invisible Text
- Worksheet Grouping
- Advanced Transpose
- XLStart Folder
- Use Slicers
- Convert Text to Numbers
- Hiding Workbook Elements
- Useful Shortcut Keys
- Sort data from Left to Right
- Advanced Filter (Complex)
Excel Productivity Tips – Part 4
- Email as PDF
- Synchronous Scrolling
- Quick Analysis of data within Excel
- Fill blank cells with Value
- Hidden Chart Source Data
- Two more Shortcuts
- Add Blank Rows
Custom views in Excel - EMBED Feature
- Adding Country Code in Mobile Numbers
Other Useful Excel Tips
- Plot an Average Line to a Chart
- 3D Referencing
- Extract Unique Values
- Excel Array Formula
- Forecast Sheet
- Add Spin Controls in Excel
- Move Data using Mouse
- Add a new entry in Auto Correct to use across Office Applications
- Find differences between 2 lists
- Find formulas Quickly
Company Profile
Course Gate was developed to make studying more accessible, convenient, and affordable for learning enthusiasts, irrespective of their location. They also aim to offer a variety of online courses of different levels, covering a broad range of subjects, to help people obtain relevant knowledge and skills that apply to the world of employment.
In a relatively short space of time, their company has assisted countless learners and their respective employers, helping them to earn a variety of qualifications by providing expert instructions for all sectors and industries and from all corners of the globe.
Since they started, they haven’t stopped adding to their already huge library of courses daily. For this reason, they are sure that learners will find a course that suits their specific needs and interests.
