10 Things You May Not Know About Excel – But You Should.
4.4 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
408 students enrolled
Wishlisted Wishlist

Please confirm that you want to add 10 Things You May Not Know About Excel – But You Should. to your Wishlist.

Add to Wishlist

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

Learn useful features and latest tricks for Excel 2010/2013 to create better workbooks in less time.
4.4 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
408 students enrolled
Last updated 8/2015
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Unused or often overlooked Excel features that will saves 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.
View Curriculum
  • SONICs Excel for Beginners Training
  • 1+ year of experience working with Excel

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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
41 Lectures
Work FASTER and Avoid ERRORS at the Same Time
9 Lectures 42:33
A short overview of what will be presented in this course.
Preview 00:44

Specify how a selected cell range should be filled with data!

Preview 09:24

Helps you quickly and accurately locate data in large worksheets.

Use Cell and Range Names to Simplify Creating Formulas

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!

Add Range Names

Editing and deleting cell name ranges can only be done in the NAME MANAGER! This video offers a helping hand.

Edit and Delete Range Names

Reduce errors and increase the readability of your worksheets as the amount of data increases.

Preview 06:16

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.

Watch Formulas That Are Not on the Same Screen and See What Happens!

Allows you to work with complex formulas to see if they are working properly!

How to Verify That Your Complex Formulas Work Properly

Manage how you work with formulas and allow Excel to check for errors in your formulas!

Customize Formula Options to Specify How Formulas Are Calculated and More

Quiz Description

Section Quiz
9 questions
Customize the Ribbon and Quick Access Toolbar
2 Lectures 17:06

Gives you fast and easy access to your most commonly used commands and options.

Save Clicks by Placing Your Most Often Used Commands in the Quick Access Toolbar

Customize the Ribbon to Your Needs
Make your Workbooks Look Great
2 Lectures 14:03

Makes your workbook look beautiful and save time with cell styles!

Apply Cell Styles Instead of Formatting Each Cell on its Own

Allows users to show important information in both graphic and workbook data versions.

Understanding Sparklines Will Add Value to Your Data When Used Wisely!

Quiz Description

Section Quiz
2 questions
Sharing Workbooks is Much More Than Sending an Email with an Attachment
5 Lectures 20:39

Allows you to check for a mistype or misspelled word!

You Use Spell Check in Word - Start Using it in Excel as Well

Helps describe the data or the worksheet for others.

Add Comments to Guide Others Through Your Workbook

Automate the process so that related data is organized and merged into one workbook.

Merge Workbooks From Team Members When You Can!

Useful for summarizing complicated data from many ranges into a single place. This video offers assistance!

Consolidate Data from Multiple Workbooks to Improve Workflow

Helps keep your documents safe and your computer secure and healthy!

Use Trust Center to Avoid Messages Like, "Do you trust this workbook?"

Quiz Description

Section Quiz
5 questions
Useful Functions We do Not See Often Enough!
4 Lectures 17:17
Automate Data Analyzation with Logical Functions

Helps count cells that only contain numbers in a selected range.

Preview 07:07

Helps you quickly find data based on specific criteria!

This is Tricky But Cool! HLookup/VLookup Helps you Find Data Based on Criteria

Helps improve the readability of your worksheets.

Text Manipulations with Concatenate and &

Quiz Description

Section Quiz
3 questions
Manage Large and Multiple Workbooks Without Getting Lost
5 Lectures 19:52
Managing Large Workbooks - Now Hassle Free!

Helps make navigating through multi-page workbooks easier!

Format Worksheet Tabs - Red for Input Sheets, Blue for Output/Reports, or ....?

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.

Manage Worksheets with Ease

Change how workbook content is displayed to make managing larger workbooks easier!

Perfect the View of Worksheets to Make Managing Larger Workbooks Easier!

How to Work with Multiple Workbooks

Quiz Description

Section Quiz
3 questions
The Advantages of Organizing Data in a Table. Yes, a Table Within Excel!
6 Lectures 23:48

Helps organize your data!

The Basics First: Create and Modify Tables

Change the order of data in a row or column to quickly find what you are looking for!

Sort Data in Tables - One of the Advantages of Working with Tables in Excel

Remove from your view, any data that does not meet certain criteria!

Preview 02:34

Allows you to create complex data filters that filter data on a variety of user-defined criteria.

Filter Data with the Advanced Filter - Only Possible with Tables in Excel

Indicates what type of summary calculation you're looking for!

The "Total Row" Helps you Calculate the SUM, Average, and Count with One Click!

Section Summary

Quiz Description

Section Quiz
7 questions
Remove Duplicates
1 Lecture 04:06

Helps keeps your worksheets organized!

Every Large Data Collection Has Duplicates - Learn How to Remove Them
Pivot Tables - Analyze your Data Like Never Before!
6 Lectures 28:48
Analyzing Data with Pivot Tables

Create a Pivot Table - Take the First Steps

Advanced Field Settings - Make Your Pivot Table More Readable

Helpful tool that filters PivotTables and PivotCharts data based on user selections.

Preview 05:44

Analyzing Data by Using a Pivot Chart - Adds a New Perspective to the Data

Section Summary

Quiz Description

Section Quiz
2 questions
Automatically Update Data From the Web Like Exchange Rates, Stocks and More
1 Lecture 05:50

The advantage of using Web Queries, they are updated every time the information on the website is changed, but only when your computer is connected to the internet!

Create a Web Query
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.3 Average rating
385 Reviews
6,385 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.