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 ...
Show more
- Description
- Curriculum
- FAQ
- Reviews
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
Who should attend?
The programme is aimed at all individuals that are upskilling themselves and improving computer proficiency.
What are the objectives of the course?
The primary objective of this course is to learn so extremely useful tricks to use with Excel
Please, login to leave a review
30-Day Money-Back Guarantee
Course details
Duration
5 hours
Video
5 hours
Level
Intermediate
Full lifetime access
Access on mobile and TV
Popular courses
