10 Things You May Not Know About Excel - But You Should.

Name: 10 Things You May Not Know About Excel - But You Should.
Rating: 4.3 (13 reviews)

Learn useful features and latest tricks for Excel 2010/2013 to create better workbooks in less time.

Created bySONIC Performance Support - E-Learning Experts

Last updated 7/2019

English

What you'll learn

Unused or often overlooked Excel features that will save you time, make less errors, securly share workbooks with other and will make your wookbooks look great.
Work faster with Excel
Make less calculation errors
Make your Excel workbooks look better
Share Workbooks more securely
Analyse data more efficiently with Pivot Tables and Slicers
Establish connections to data sources on the web.
Learn useful functions beyond SUM
Manage Large Workbooks and Multiple Workbooks and don't get lost
Remove duplicates in a list.
Manage lists in a table.

Course content

10 sections • 41 lectures • 3h 14m total length

10 Things You May Not Know About Excel - But You Should!0:44
A short overview of what will be presented in this course.
Autofill Feature - You Think You Know it, But There is More to it!9:24
Specify how a selected cell range should be filled with data!
Use Cell and Range Names to Simplify Creating Formulas7:05
Helps you quickly and accurately locate data in large worksheets.
Add Range Names6:53
Excel allows you to give a clear, concise and descriptive name to a single cell or a range of cells so the information is always readily available!
Edit and Delete Range Names3:37
Editing and deleting cell name ranges can only be done in the NAME MANAGER! This video offers a helping hand.
Use Range Names in Formulas6:16
Reduce errors and increase the readability of your worksheets as the amount of data increases.
Watch Formulas That Are Not on the Same Screen and See What Happens!2:09
Allows you to keep both the cell and the dialog box visible so that you can see the specific and general effects of any changes. This video offers a helping hand.
How to Verify That Your Complex Formulas Work Properly2:43
Allows you to work with complex formulas to see if they are working properly!
Customize Formula Options to Specify How Formulas Are Calculated and More3:42
Manage how you work with formulas and allow Excel to check for errors in your formulas!
Section Quiz

You Use Spell Check in Word - Start Using it in Excel as Well6:17
Allows you to check for a mistype or misspelled word!
Add Comments to Guide Others Through Your Workbook5:04
Helps describe the data or the worksheet for others.
Merge Workbooks From Team Members When You Can!2:19
Automate the process so that related data is organized and merged into one workbook.
Consolidate Data from Multiple Workbooks to Improve Workflow4:00
Useful for summarizing complicated data from many ranges into a single place. This video offers assistance!
Use Trust Center to Avoid Messages Like, "Do you trust this workbook?"2:59
Helps keep your documents safe and your computer secure and healthy!
Section Quiz

Automate Data Analyzation with Logical Functions0:40
Counting Made Easy - Count(), Counta() and Countif()7:07
Helps count cells that only contain numbers in a selected range.
This is Tricky But Cool! HLookup/VLookup Helps you Find Data Based on Criteria4:42
Helps you quickly find data based on specific criteria!
Text Manipulations with Concatenate and &4:48
Helps improve the readability of your worksheets.
Section Quiz

Managing Large Workbooks - Now Hassle Free!0:28
Format Worksheet Tabs - Red for Input Sheets, Blue for Output/Reports, or ....?5:41
Helps make navigating through multi-page workbooks easier!
Manage Worksheets with Ease8:08
Organize your worksheets by moving sheets, insert and remove sheets, hide and unhide worksheets and refer to cells on other worksheets! This video offers a helping hand.
Perfect the View of Worksheets to Make Managing Larger Workbooks Easier!5:05
Change how workbook content is displayed to make managing larger workbooks easier!
How to Work with Multiple Workbooks0:30
Section Quiz

The Basics First: Create and Modify Tables5:01
Helps organize your data!
Sort Data in Tables - One of the Advantages of Working with Tables in Excel3:56
Change the order of data in a row or column to quickly find what you are looking for!
Filter Data with the Auto Filter - It's as Easy as 1-2-3 in Excel!2:34
Remove from your view, any data that does not meet certain criteria!
Filter Data with the Advanced Filter - Only Possible with Tables in Excel5:32
Allows you to create complex data filters that filter data on a variety of user-defined criteria.
The "Total Row" Helps you Calculate the SUM, Average, and Count with One Click!6:08
Indicates what type of summary calculation you're looking for!
Section Summary0:37
Section Quiz

Requirements

SONICs Excel for Beginners Training
1+ year of experience working with Excel

Description

You do not know Excel if you do not master these topics.

If you think you can master Excel, this course is for you. After 25+ years of experience working with spreadsheets, we know what Excel worksheets lack or are often missing. We have compiled the ultimate course, with all the features and functions you need to become a master of Excel.

You do not have to go through all 18 hours of training in our Beginner, Intermediate and Advanced Excel courses. We have captured the essence for you in this course.

Who this course is for:

Those who are above beginner level and learn the nuts and bolts of Excel to really master Excel.
Business Users Of All Levels
Advanced Users

10 Things You May Not Know About Excel - But You Should.

What you'll learn

Explore related topics

Course content

Work FASTER and Avoid ERRORS at the Same Time9 lectures • 43min

Customize the Ribbon and Quick Access Toolbar2 lectures • 17min

Make your Workbooks Look Great2 lectures • 14min

Sharing Workbooks is Much More Than Sending an Email with an Attachment5 lectures • 21min

Useful Functions We do Not See Often Enough!4 lectures • 17min

Manage Large and Multiple Workbooks Without Getting Lost5 lectures • 20min

The Advantages of Organizing Data in a Table. Yes, a Table Within Excel!6 lectures • 24min

Remove Duplicates1 lecture • 4min

Pivot Tables - Analyze your Data Like Never Before!6 lectures • 29min

Automatically Update Data From the Web Like Exchange Rates, Stocks and More1 lecture • 6min

Requirements

Description

Who this course is for: