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.
401 students enrolled
$20
Take This Course
  • Lectures 41
  • Contents Video: 3 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2014 English

Course 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.

What are the requirements?

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

What am I going to get from this course?

  • 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.

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Work FASTER and Avoid ERRORS at the Same Time
00:44
A short overview of what will be presented in this course.
09:24

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

07:05

Helps you quickly and accurately locate data in large worksheets.

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

03:37

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

06:16

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

02: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.

02:43

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

03:42

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

9 questions

Quiz Description

Section 2: Customize the Ribbon and Quick Access Toolbar
07:44

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

Customize the Ribbon to Your Needs
09:22
Section 3: Make your Workbooks Look Great
09:08

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

04:55

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

2 questions

Quiz Description

Section 4: Sharing Workbooks is Much More Than Sending an Email with an Attachment
06:17

Allows you to check for a mistype or misspelled word!

05:04

Helps describe the data or the worksheet for others.

02:19

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

04:00

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

02:59

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

5 questions

Quiz Description

Section 5: Useful Functions We do Not See Often Enough!
Automate Data Analyzation with Logical Functions
00:40
07:07

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

04:42

Helps you quickly find data based on specific criteria!

04:48

Helps improve the readability of your worksheets.

3 questions

Quiz Description

Section 6: Manage Large and Multiple Workbooks Without Getting Lost
Managing Large Workbooks - Now Hassle Free!
00:28
05:41

Helps make navigating through multi-page workbooks easier!

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

05:05

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

How to Work with Multiple Workbooks
00:30
3 questions

Quiz Description

Section 7: The Advantages of Organizing Data in a Table. Yes, a Table Within Excel!
05:01

Helps organize your data!

03:56

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

02:34

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

05:32

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

06:08

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

Section Summary
00:37
7 questions

Quiz Description

Section 8: Remove Duplicates
04:06

Helps keeps your worksheets organized!

Section 9: Pivot Tables - Analyze your Data Like Never Before!
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
05:44

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

Analyzing Data by Using a Pivot Chart - Adds a New Perspective to the Data
07:19
Section Summary
00:44
2 questions

Quiz Description

Section 10: Automatically Update Data From the Web Like Exchange Rates, Stocks and More
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!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course