Have a question?
Message sent Close

Excel: Useful Tips and Tricks

Excel is one of the best programs available for data modeling, statistics and financial calculations. Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs. This course will provide you with the right tips and tricks that will not only speed up your use of Excel, but also give some valuable insights into problem solving.

63 students enrolled

Microsoft Excel is the industry leading spreadsheet program used for data calculations, analysis, visualisation and much more; it also has many external programming features.  Excel is one of the best programs available for data modeling, statistics and financial calculations. Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs. This course will provide you with the right tips and tricks that will not only speed up your use of Excel, but also give some valuable insights into problem solving.

Tip 1 – Switch Between Excel Spreadsheets Only

Tip 2 – Use Ctrl Enter to Fill an Entire Range

Tip 3 – Copy Formula on Clipboard to Use Later

Tip 4 – Finding and Removing Blanks

Tip 5 – Snap Objects to Cell Borders

Tip 6 – Sort According to a Custom List

Tip 7 – Enter Bullets in Excel

Tip 8 – Autofill Growth Trend

Tip 9 – Join Contents in 2 or More Cells

Tip 10 – IFERROR Function

Tip 11 – Enable Data Entry only when the Previous Cell is Filled

Tip 12 – Random Numbers

Tip 13 – Excel Camera

Tip 14 – Conditional Validation or Dependent Drop-Down List

Tip 15 – Flash Fill

The programme is aimed at all individuals that are upskilling themselves and improving computer proficiency.
The primary objective of this course is to learn so extremely useful tricks to use with Excel

Be the first to add a review.

Please, login to leave a review
30-Day Money-Back Guarantee

Includes

5 hours
Full lifetime access
Access on mobile and TV

Contact your Instructor