Free Excel Tutorial - Boost Your Excel Skills: Crash Course w/ Downloadable Files

Description

In this course, you will learn:-

• Use and put 10 of Excel's most powerful intermediate features to work for you.
• With Autosum, you can quickly calculate sums, averages, and high and low numbers.
• Customize the Quick Access Toolbar for one-touch access.
• The Shortcut Menu and Mini Toolbar help you save time.
• Use the Quick Analysis Tool and deploy it (New to Excel 2013)
• With the Fill Handle, you may make datasets and labels.
• With Flash Fill, you may build, deconstruct, and reorganise data (New to Excel 2013)
• Create, alter, and update content in real time. Graphs and charts
• Use the charts that have been recommended (New to Excel 2013)
• To better organise data and lists, use Sorting and Filters.
• Tables can be created, modified, and removed from existing data.

Syllabus:-

• Introduction to the Course

• DOWNLOAD: Course Excel Files

• Autosum

• The Quick Access Toolbar

• The Shortcut Menu & Mini-Toolbar

• The Quick Analysis Tool (New to Excel 2013)

• The Fill Handle

• Half-Way Checkpoint

• Flash Fill (New to Excel 2013)

• Charts & Graphs

• Recommended Charts (New to Excel 2013)

• Sorting & Filters

• Tables