10 Things You May Not Know About Excel – But You Should.
4.3 (8 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.
406 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.3 (8 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.
406 students enrolled
Last updated 8/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
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 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
Expand All 41 Lectures Collapse All 41 Lectures 03:14:02
+
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
07:05

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
06:53

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
03:37

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!
02:09

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

How to Verify That Your Complex Formulas Work Properly
02:43

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
03:42

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
07:44

Customize the Ribbon to Your Needs
09:22
+
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
09:08

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

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

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
06:17

Helps describe the data or the worksheet for others.

Add Comments to Guide Others Through Your Workbook
05:04

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

Merge Workbooks From Team Members When You Can!
02:19

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

Consolidate Data from Multiple Workbooks to Improve Workflow
04:00

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

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

Quiz Description

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

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
04:42

Helps improve the readability of your worksheets.

Text Manipulations with Concatenate and &
04:48

Quiz Description

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

Helps make navigating through multi-page workbooks easier!

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

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
08:08

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

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

How to Work with Multiple Workbooks
00:30

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
05:01

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
03:56

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
05:32

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

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

Section Summary
00:37

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
04:06
+
Pivot Tables - Analyze your Data Like Never Before!
6 Lectures 28:48
Analyzing Data with Pivot Tables
00:29

Create a Pivot Table - Take the First Steps
07:19

Advanced Field Settings - Make Your Pivot Table More Readable
07:13

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
07:19

Section Summary
00:44

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
05:50
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.1 Average rating
273 Reviews
4,883 Students
45 Courses

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.