MS Excel Top Tips - Upgrade your Excel Skill to next Level

Course

Online

£ 20 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Microsoft Excel is the most widely used spreadsheet program being used by users across the World. While this program is being widely used by millions of users, still full capability of this program is not known to majority of regular users. There are countless features and shortcuts are available within Excel which can help users to save precious time.In this course I tried to cover such tips which I use on regular basis during my day to day work. I personally found these features very useful and helped me to be more productive.I have tried to make all these features available in same place, so that it can help others also to be more productive while using MS Excel. Hopefully this will be helpful.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

In this course, you will learn 50 MS Excel related tips, which can help you to take your Excel knowledge to next level. These tips will also help you to save good amount of time during your day to day work

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Import
  • Ms Office
  • Web
  • Camera
  • Flash
  • Office IT
  • Excel
  • Excel for Accounting
  • Microsoft Excel

Course programme

Welcome 1 lecture 01:49 Introduction preview Introduction to the course Welcome 1 lecture 01:49 Introduction preview Introduction to the course Introduction preview Introduction to the course Introduction preview Introduction to the course Introduction preview Introduction to the course Introduction preview Introduction to the course Introduction to the course Introduction to the course Excel Productivity Tips - Part 1 10 lectures 28:07 Tip #1: Camera Tool preview Tip #2: Add Line Break in Formula Bar Tip #3: Advanced Copy-Paste using Office Clipboard Tip #4: Navigation between Worksheets using Shortcut Keys Tip #5: Flash Fill Tip #6: Add Multiple Rows and Columns Quickly Tip #7: Delete Blank Rows Tip #8: Multi Level Row and Column Sorting Tip #9: Add Sparklines Tip #10: Paste Special - Transpose Excel Productivity Tips - Part 1 10 lectures 28:07 Tip #1: Camera Tool preview Tip #2: Add Line Break in Formula Bar Tip #3: Advanced Copy-Paste using Office Clipboard Tip #4: Navigation between Worksheets using Shortcut Keys Tip #5: Flash Fill Tip #6: Add Multiple Rows and Columns Quickly Tip #7: Delete Blank Rows Tip #8: Multi Level Row and Column Sorting Tip #9: Add Sparklines Tip #10: Paste Special - Transpose Tip #1: Camera Tool preview Tip #1: Camera Tool preview Tip #1: Camera Tool preview Tip #1: Camera Tool preview Tip #2: Add Line Break in Formula Bar Tip #2: Add Line Break in Formula Bar Tip #2: Add Line Break in Formula Bar Tip #2: Add Line Break in Formula Bar Tip #3: Advanced Copy-Paste using Office Clipboard Tip #3: Advanced Copy-Paste using Office Clipboard Tip #3: Advanced Copy-Paste using Office Clipboard Tip #3: Advanced Copy-Paste using Office Clipboard Tip #4: Navigation between Worksheets using Shortcut Keys Tip #4: Navigation between Worksheets using Shortcut Keys Tip #4: Navigation between Worksheets using Shortcut Keys Tip #4: Navigation between Worksheets using Shortcut Keys Tip #5: Flash Fill Tip #5: Flash Fill Tip #5: Flash Fill Tip #5: Flash Fill Tip #6: Add Multiple Rows and Columns Quickly Tip #6: Add Multiple Rows and Columns Quickly Tip #6: Add Multiple Rows and Columns Quickly Tip #6: Add Multiple Rows and Columns Quickly Tip #7: Delete Blank Rows Tip #7: Delete Blank Rows Tip #7: Delete Blank Rows Tip #7: Delete Blank Rows Tip #8: Multi Level Row and Column Sorting Tip #8: Multi Level Row and Column Sorting Tip #8: Multi Level Row and Column Sorting Tip #8: Multi Level Row and Column Sorting Tip #9: Add Sparklines Tip #9: Add Sparklines Tip #9: Add Sparklines Tip #9: Add Sparklines Tip #10: Paste Special - Transpose Tip #10: Paste Special - Transpose Tip #10: Paste Special - Transpose Tip #10: Paste Special - Transpose Excel Productivity Tips - Part 2 10 lectures 35:45 Tip #11: Snap to Grid Tip #12: Create Custom Autofill List Tip #13: Absolute Cell Reference Tip #14: Import Data from Web page preview Tip #15: Move Cell Direction Tip #16: Delete Data using Mouse Tip #17: Status Bar Quick Calculations Tip #18: Link Text Boxes to Cell Tip #19: Phone Number and ZIP Code Format Tip #20: Speaking Cell Excel Productivity Tips - Part 2 10 lectures 35:45 Tip #11: Snap to Grid Tip #12: Create Custom Autofill List Tip #13: Absolute Cell Reference Tip #14: Import Data from Web page preview Tip #15: Move Cell Direction Tip #16: Delete Data using Mouse Tip #17: Status Bar Quick Calculations Tip #18: Link Text Boxes to Cell Tip #19: Phone Number and ZIP Code Format Tip #20: Speaking Cell Tip #11: Snap to Grid Tip #11: Snap to Grid Tip #11: Snap to Grid Tip #11: Snap to Grid Tip #12: Create Custom Autofill List Tip #12: Create Custom Autofill List Tip #12: Create Custom Autofill List Tip #12: Create Custom Autofill List Tip #13: Absolute Cell Reference Tip #13: Absolute Cell Reference Tip #13: Absolute Cell Reference Tip #13: Absolute Cell Reference Tip #14: Import Data from Web page preview Tip #14: Import Data from Web page preview Tip #14: Import Data from Web page preview Tip #14: Import Data from Web page preview Tip #15: Move Cell Direction Tip #15: Move Cell Direction Tip #15: Move Cell Direction Tip #15: Move Cell Direction Tip #16: Delete Data using Mouse Tip #16: Delete Data using Mouse Tip #16: Delete Data using Mouse Tip #16: Delete Data using Mouse Tip #17: Status Bar Quick Calculations Tip #17: Status Bar Quick Calculations Tip #17: Status Bar Quick Calculations Tip #17: Status Bar Quick Calculations Tip #18: Link Text Boxes to Cell Tip #18: Link Text Boxes to Cell Tip #18: Link Text Boxes to Cell Tip #18: Link Text Boxes to Cell Tip #19: Phone Number and ZIP Code Format Tip #19: Phone Number and ZIP Code Format Tip #19: Phone Number and ZIP Code Format Tip #19: Phone Number and ZIP Code Format Tip #20: Speaking Cell Tip #20: Speaking Cell Tip #20: Speaking Cell Tip #20: Speaking Cell Excel Productivity Tips - Part 3 10 lectures 41:11 Tip #21: Invisible Text preview Tip #22: Worksheet Grouping Tip #23: Advanced Transpose Tip #24: XLStart Folder Tip #25: Use Slicers Tip #26: Convert Text to Numbers Tip #27: Hiding Workbook Elements Tip #28: Useful Shortcut Keys Tip #29: Sort data from Left to Right Tip #30: Advanced Filter (Complex) Excel Productivity Tips - Part 3 ong Tip #44: Excel Array Formula Tip #44: Excel Array Formula Tip #45: Forecast Sheet Tip #45: Forecast Sheet Tip #45: Forecast Sheet ...

Additional information

Excel users with some level of working knowledge Excel users who wants to learn time saving tips to improve productivity I have recorded this course using Office 365. However majority of tips will work on other older versions also You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

MS Excel Top Tips - Upgrade your Excel Skill to next Level

£ 20 + VAT