50 Tips to Upgrade your Excel Skill

Description

This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder.

You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.

There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds.

Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace.

Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.

7 sections • 52 lectures • 02:57:00 total length

•Welcome: 00:02:00

•Camera Tool: 00:05:00

•Add Line Break in Formula Bar: 00:03:00

•Advanced Copy-Paste using Office Clipboard: 00:03:00

•Navigation between Worksheets using Shortcut Keys: 00:01:00

•Flash Fill: 00:02:00

•Add Multiple Rows and Columns Quickly: 00:02:00

•Delete Blank Rows: 00:03:00

•Multi Level Row and Column Sorting: 00:04:00

•Add Sparklines: 00:03:00

•Paste Special - Transpose: 00:03:00

•Snap to Grid: 00:03:00

•Create Custom Auto fill List: 00:06:00

•Absolute Cell Reference: 00:03:00

•Import Data from Web page: 00:04:00

•Move Cell Direction: 00:03:00

•Delete Data using Mouse: 00:02:00

•Status Bar Quick Calculations: 00:03:00

•Link Text Boxes to Cell: 00:04:00

•Phone Number and ZIP Code Format: 00:04:00

•Speaking Cell: 00:05:00

•Invisible Text: 00:03:00

•Worksheet Grouping: 00:04:00

•Advanced Transpose: 00:04:00

•XLStart Folder: 00:03:00

•Use Slicers: 00:05:00

•Convert Text to Numbers: 00:03:00

•Hiding Workbook Elements: 00:02:00

•Useful Shortcut Keys: 00:03:00

•Sort data from Left to Right: 00:03:00

•Advanced Filter (Complex): 00:11:00

•Email as PDF: 00:02:00

•Synchronous Scrolling: 00:03:00

•Quick Analysis of data within Excel: 00:02:00

•Fill blank cells with Value: 00:03:00

•Hidden Chart Source Data: 00:03:00

•Two more Shortcuts: 00:03:00

•Add Blank Rows: 00:03:00

•Custom views in Excel: 00:06:00

•EMBED Feature: 00:04:00

•Adding Country code in Mobile Numbers: 00:04:00

•Plot an Average Line to a Chart: 00:04:00

•3D Referencing: 00:04:00

•Extract Unique Values: 00:03:00

•Excel Array Formula: 00:04:00

•Forecast Sheet: 00:04:00

•Add Spin Controls in Excel: 00:05:00

•Move Data using Mouse: 00:01:00

•Add new entry in Auto Correct to use across Office Applications: 00:05:00

•Find Differences between Two Lists: 00:02:00

•Find formulas Quickly: 00:02:00

•Thank You: 00:01:00