Learn Microsoft Excel 2010

Fast moving, easy to follow Microsoft Excel 2010 tutorial from the the e-learning experts!
0 reviews
TAUGHT BY
  • ClipTraining LLC Learn what you need, when you need!

    ClipTraining is a leading creator of eLearning for Microsoft Office, Microsoft Windows, and many more business applications. The ClipTraining Library is a continuously growing resource for educating and supporting individuals, K-12 students, and business organizations. Through to-the-point, task-based lessons called Clips, every student is empowered with on-demand knowledge to expand their skills. Having access to our courses is like working with the expert over your shoulder!

WHAT'S INSIDE
  • Lifetime access to 103 lectures and 11 quizzes
  • 4+ hours of high quality content
  • A community of 200+ students learning together!
SHARE

Learn Microsoft Excel 2010

Fast moving, easy to follow Microsoft Excel 2010 tutorial from the the e-learning experts!
0 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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

COURSE DESCRIPTION

In this Microsoft Excel 2010 course, ClipTraining provides a comprehensive instruction starting with the basics and on through the advanced features. 

With over 100 Video Tutorials and more then 4 hours of training; ClipTraining helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional. 

Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, and finishing off with 20 part sections on Advanced Excel Features. 

Along with the task-based, to-the-point videos, you'll receive an excellent downloadable 'ClipStart' PDF with helpful tips to get you started.

Take this course to learn all about Excel 2010 and be on your way to becoming a Microsoft Office pro.

    • Microsoft Excel 2010
    • Over 103 lectures and 4.5 hours of content!
    • After completing this course you'll have the ability to prove your mastery of Microsoft’s standard spreadsheet application. With the skills learned in these easy to follow videos, any user will be fully competent and capable of working in a variety of business settings.
    • Anyone interested in learning Excel 2010 from beginners to advanced users. This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features. These videos are ideal for visual learners.

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Introduction and Auxiliary Materials
  • 1
    Introductory Lecture
    01:43

    In this lecture clip we will provide an introduction to ClipTraining and information on how to best use our training materials.

  • 2
    ClipStart Guide for Excel
    2 pages

    Download this 2 page guide to help get you and your team up and running fast with Excel 2010!

  • SECTION 2:
    The Basics of Workbooks and Worksheets
  • 3
    Getting Started
    02:53

    In this clip, let's take a look around the Excel window, label the  parts, and see how to better navigate the interface.  We'll also see the Backstage view and how to use it.

  • 4
    Exploring Ribbon Tabs
    03:34

    In this clip we will take a close up look at the main tabs and groups on the ribbon.  Group names on the ribbon will cluster similar commands in groups so you can save time looking for a command.  See how screen tips can help you learn about a particular ribbon command.

  • 5
    Working with Backstage View
    02:22

    Do you know another name for the File tab?  It's  called Backstage View.  Get a brief overview of the various commands in this clip.

  • 6
    Understanding Worksheet Navigation
    01:37

    In this clip we will see how to navigate through our worksheets. With the ability to create 255 worksheets in an Excel document, it's important to understand how to sort through them and access them.  Find out how in this lesson.

  • 7
    Adding, Deleting and Renaming Worksheets
    01:49

    In this clip we will discuss how to add, delete or rename worksheets. Be careful when deleting a worksheet.  That data will be permanently gone so make sure you really mean to delete it!

  • 8
    Hiding and Unhiding Worksheets
    01:08

    Don't let sensitive data become visible to others.  See what it takes to hide your worksheets from view and then restore them back when needed.

  • 9
    Moving, Copying or Coloring Worksheets
    03:01

    What does it take to move around the order of worksheets?  This clip explores how to accomplish this in detail.  We'll also see how useful it is to copy them and how to accomplish the copying of a worksheet.  Another useful thing to know is how to change sheet tab colors and this will be covered toward the conclusion of this clip.

  • 10
    Working with Templates
    02:55
    Templates can be a real time saver in setting up your worksheets. The following templates are automatically installed when you start using Excel 2010: Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, and Time Card.

    Many additional templates are available for downloading from Microsoft Office online. See how to use templates in this clip.
  • 11
    Closing Excel
    01:10
    There are a couple of different ways to close Excel after you've finished working in it.  For example you can close just a spreadsheet and leave the application open or you can close the entire application down. This lesson shows this distinction and how to use these methods to close Excel.
  • 12
    Entering Data
    01:30
    So how do you build an Excel worksheet from scratch?  This clip is the starting point for that as you learn how to enter data into a worksheet.  Getting started here with the basics will make sure you have the right foundation moving forward.
  • 13
    Exploring Navigation Shortcuts
    03:25
    Learn how to get around worksheets with keyboard commands like Enter, Tab, Arrow Keys, Page Up /Down, Home key and more! You'll also be introduced to a couple of commands on the Home tab in the Editing group on the Find and Select drop down menu.  Discover how Excel pinpoints various aspects of your worksheet for you in this clip, for example cells that contain formulas.
  • 14
    Inserting Different Data Types
    02:48
    What type of data can be inserted into Excel?  All sorts!  This clip wil show you how to insert different types of data, such as text, numerical and dates.
  • 15
    Modifying Cell Comments
    01:48
    Sometimes when we enter data, we may want to provide an additional explanation in the worksheet to clarify why it is there or clear up some question about it.  Comments are an easy unobtrusive way to accomplish this.  Discover how this can be done in this clip.
  • 16
    Using the Clipboard Pane
    03:43
    This clip shows you a quick way to insert data into multiple cells. See the various objects on the clipboard and how to pick which items you want inserted where.  Sounds tricky? It's not, just watch and learn.  Finally, this lesson closes with a nice explanation of the purpose of the shortcut key Ctrl+Enter in relation to Excel.
  • 17
    Understanding AutoFill
    01:38
    Ready for a timesaver?  Learn about a key tool in Excel – AutoFill.  Watch and learn in this lesson how to quickly fill cells with data automatically.
  • 18
    Creating Series with AutoFill
    02:41
    Forget about typing January, February, March, etc.  Learn how AutoFill can create this series and others like the days of the week, number sequences and dates.  Also see how AutoFill can look at a sequential range of numbers and continue building the sequence for you.  This is one clip you won’t want to miss!
  • 19
    Working with AutoComplete
    01:55

    By now we are all used to search engines automatically suggesting keywords as we type searches.  Not one to be left behind, Microsoft Excel features this same capability.  Watch this clip to see how to use this feature and also take a trip into advanced options to make sure your system is properly utilizing this feature.

  • 20
    The Basics Quiz Part One
    9 questions
  • 21
    The Basics Quiz Part Two
    8 questions
  • SECTION 3:
    Formatting and Conditional Formatting
  • 22
    Exploring the Font Group
    03:16
    No more bland worksheets with default fonts and colors after this clip.  Get the facts on how to quickly customize the look of your worksheet.  You never knew you could be so creative in Excel!  See how to use bold, underline and italics along with a bevy of other font options in this quick clip.
  • 23
    Using the Font Dialog Box
    01:43
    Don't worry, after watching how to utilize the Font dialog box with its preview feature, you'll have all the confidence you need to get the most out of your fonts.  This short lesson will get you quickly up to speed on this feature.
  • 24
    Exploring the Alignment Group
    03:54
    Explore how to precisely position your text; whether in a cell or a group of cells.  One example provided in this lesson is how to use the Merge and Center command. This joins the selected cells into one larger cell and centers the contents in a new cell.  This feature is practical when you need to use labels that span multiple columns.
  • 25
    Using the Alignment Dialog Box
    01:31
    Ever wonder how to make your text appear on an angle in your worksheet?  Wonder no more after watching this brief tutorial clip.  See how to align and orient your text, like if you want it to run on an angle or even vertically.
  • 26
    Understanding the Number Group
    02:57
    On the Home tab on the ribbon is the Number group.  This lesson takes a close look at the specifics regarding the commands located here.  Learn about number styles such as a comma, dollar sign, and other accounting formats along with increase and decrease commands.
  • 27
    Using the Number Dialog Box
    01:16
    Where is the command to open the number dialog box?  Find out in this clip.  Also learn about different numerical categories you can assign to a cell or range such as currency, accounting, date, percentage, fraction and much more.
  • 28
    Adjusting Rows and Columns
    02:59
    Why is it that sometimes Excel puts a lot of ##### in a cell?  Find out what this is and how to get rid of it in this lesson.  Also see how to take advantage of the AutoFit feature when working with data in multiple columns.
  • 29
    Using Hide and Unhide
    01:46
    The art of hiding and unhiding is discussed in this clip.  Where did that row go?  Where did that column go?  Did you hide it?  See how to do this and also discover how to unhide them. 
  • 30
    Formatting a Data Bar
    02:35
    What is Conditional Formatting? Conditional formatting allows you to change the appearance of a cell, depending on certain conditions.  Formatting your spreadsheet in this way allows you to see at a glance relevant information quickly through graphics or colors.  This clip looks at using conditional formatting in both ways.  This will be demonstrated through a data bar.  Check it out!
  • 31
    Configuring Data Bar Rules
    02:23
    This clip focuses on the commands found on the New Formatting Rule dialog box.  This dialog box allows you to configure rule types and then edit the Rule Description.  Sounds hard? – it’s not.  Watch and learn in this clip now.
  • 32
    Formatting with Color Scales
    01:02
    Similar to data bars, color scales graphically present you with the result of your data.  Learn how to add these to your data.  Simple and easy to use, color scales are an easy way to see what the numbers are doing.
  • 33
    Formatting with Icon Sets
    04:36
    This lesson continues to look at conditional formatting and expands on the previous clips by introducing Icon Sets.  Find out how small graphic icons can tell the story of what is happening with your data.
  • 34
    Configuring Highlight Cells Rules
    02:59
    Learn all about applying pre-configured rules for actions in your cells. Values you can learn in this clip to apply are: Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring and Duplicate values.
  • 35
    Working with Top/Bottom Rules
    04:17
    Learn how to quickly benefit from pre-configured  rules that will show you the details such as the Top/Bottom 10%, Items or Average in a series of data.  This lesson shows you how to apply these and then locate these values in your cell range.  An invaluable tool, learn how to use it quickly by watching this clip.
  • 36
    Manage Multiple Conditional Formatting Rules
    02:23
    Why just use one set of rules?  Learn how to benefit from a graphical representation of your selected rules; includes configuring cell data with multiple rules.  Are you making a mess out of it?  No problem, you’ll also see how to clean things up with the 'Clear rules From Selected Cells' command.
  • 37
    Using Cross Sheet Conditional Formatting
    04:49
    In this lesson we'll see how to create cross sheet references.  What are these you ask?  These are cell references to other worksheets in your workbook.  See how you can graphically represent what is happening across one worksheet in a single cell.
  • 38
    Working with Conditional Formatting in Ranges with Errors
    02:27
    Imagine this situation.  You want to apply conditional formatting but your range of data has errors.  No problem!  Watch how Excel deals with this situation and how you can apply conditional formatting to ranges with errors.
  • 39
    Groups, Dialog Boxes, Rows and Columns Quiz
    8 questions
  • 40
    Formatting and Conditional Formatting Quiz
    10 questions
  • SECTION 4:
    Working with Formulas and Functions
  • 41
    Creating Formulas
    04:00
    What is a Formula? In just a few minutes you’ll learn exactly what they are and when to use them.  We'll also discuss operators and we'll see how to enter and edit those formulas.  Here’s a hint:  Formulas that involve adding, subtracting, multiplying and dividing usually start with an = sign. Watch and learn the rest of the formula in this clip.
  • 42
    Understanding Functions
    03:00
    What is a Function? How does it differ from a formula?  Get the facts quickly in this brief tutorial clip. We'll also show you how to insert a function into your worksheet.
  • 43
    Using AutoSum
    01:31
    Learn about this incredibly useful shortcut tool: AutoSum that takes all the guess work out of getting a quick summary of data. Just take a minute and watch this clip.
  • 44
    Exploring Common Functions
    01:41
    In this short clip see how to insert commonly used functions into your cells.  On display in this lesson are Average and Minimum.
  • 45
    Understanding Status Bar Results
    01:17
    This lesson shows off the Status Bar.  From here you can also add features to display like the minimum and maximum values in cells.  Also learn how to see the sum of data through the Status Bar!  Understand how to better utilize this helpful tool by watching this mini lesson.
  • 46
    Exploring the Function Library
    01:33
    The Function Library is located on the Formulas Tab and this group is replete with preset functions.  See how screen tips point the way to the function you need.  Gain a better understanding of this topic by viewing this quick clip.
  • 47
    Using the Insert Functions Command
    03:50
    Discover how to benefit from the Function  Arguments dialog box.  The example provided looks at calculating a loan payment.  See how to do this quick and easy.
  • 48
    Inserting Logical Functions
    03:23
    See how to use logical functions in the context of calculating a sales commission based on performance.  If you watch this lesson, you can follow the example to mimic the results in your own worksheets!
  • 49
    Working with Text Functions
    02:38
    Get ready for a real timesaver as you see  the power of the Proper function located on the Formulas tab.  Forget about messy text throughout your worksheet.  Get it all cleaned up – and fast!
  • 50
    Using Date Functions
    01:49
    Need a way to insert the date or the exact date and time?  Here’s a quick clip on getting this data painlessly into your cells.
  • 51
    Working with Formulas and Functions
    10 questions
  • SECTION 5:
    Sorting and Filtering Data
  • 52
    Exploring Sort and Filter Commands
    01:12
    In this clip you will look at two different types of sorting.

    (1) Ascending/Descending Sorts - See the right way and the wrong way to sort your data and then head over to the Editing group on the Home  tab to put your knowledge to work. 

    (2)Using Table Column Headers - Done through the Sort dialog box, this enables sorting by multiple columns rows, case sensitive sorts and other sort options.
  • 53
    Preparing to Use Custom Sort
    01:35
    This lesson details what is required to make a custom sort.  Specifically, this is contiguous rows and unique headings.  Want to see it in action?  Watch this short video lesson!
  • 54
    Performing a Color Custom Sort
    01:26
    With your data prepared you are now ready for a color sort. So…how do we do a color sort?  Just watch and learn.
  • 55
    Using Multiple Level Custom Sorts
    01:12
    See how to get the most out of the Sort and Filter dropdown in the Editing group on the Home tab.  An example in this clip utilizes the Custom Sort dialog box.  See it in action now.
  • 56
    Exploring Data Filters
    02:44
    Learn how to hide records you are not interested in seeing and only showing records you want to see.  The distinction between filtering and sorting is that sorting rearranges your data whereas filtering gives you an opportunity to hide (not delete) what you don't want to see.  This lesson will show you how to do it
  • 57
    Filtering Multiple Columns
    01:17
    This clip continues with data filters but keys in on filtering multiple columns.  Quick and easy. Watch this lesson and you’ll get the hang of this in a snap!
  • 58
    Working with Subtotals
    04:22
    See how to quickly create subtotals between your groups of data.  Stop doing this manually! This clip will show you how to use automated features on the Data tab to accomplish this. 
  • 59
    New Table Features
    05:20
    Discover how formulas look when used in a table and how to use the Autofilter tool when working in long spreadsheets.  Learn all of this in just a few minutes with this short tutorial lesson.
  • 60
    Using Search Features
    04:16
    See how to turn on the AutoFilter, use the Search feature to quickly filter your data, and how to clear filters and turn off the AutoFilter.
  • 61
    Sorting and Filtering Data
    9 questions
  • SECTION 6:
    Worksheet Protection and Various View Options
  • 62
    Protecting Your Data
    04:34
    Discover how to configure your workbook protection settings in this lesson. This is setup initially on the Save As dialog box on the Tools menu.  Watch this clip to see how to password protect your workbook.
  • 63
    Modifying Workbook Protection Settings
    03:20
    In the previous clip it was demonstrated how to password protect your entire workbook.  This lesson takes protection a step further by also showing you how to password protect individual sheets.  This will prevent unwanted changes to the data in a sheet by specifying what information can be changed.  All of this is done on the Review tab in the Changes group.
  • 64
    Protecting Cells in a Workbook
    02:16
    This clip will teach you how to protect specific cells in your workbook by locking cells.  Attention is given to the Font dialog box and the Protection tab.  The example provided will show you how to lock down a worksheet while leaving open a specific data range for edits.
  • 65
    Protecting a Workbook Window
    01:47
    In this lesson you will learn how to prevent changes to the structure of the workbook such as moving, deleting or adding sheets.  Best of all you’ll learn it all in under 2 minutes!
  • 66
    Understanding Protected View
    01:49
    Protected view is all about keeping your system safe from malicious software commands that may be transferred in an Excel file.  Learn about what Protected View is, what the Security Bar does for us, and how to enable a Protected File.
  • 67
    Requiring Protected View
    01:07
    Take a minute and see how to force an Excel file to open in Protected View.  This is useful in instances where you have a questionable document and you want to make sure it opens in a safe protected environment that can do no harm to your computer.
  • 68
    Exploring Worksheet Views
    02:32
    This lesson takes you over to the View tab and examines the Workbook Views group.  Examples of different views include Normal, Page Layout, Page Break Preview and more.  Watch and learn how to switch between them.
  • 69
    Using Zoom Controls
    01:30
    In a little over a minute you’ll see how to zoom in, zoom out and how to get the most out of the zoom button and Zoom dialog box.  How do we do all that in so short a time?  Click the clip to find out!
  • 70
    Working with Freeze Panes
    01:53
    Here’s a challenge for you: How do you determine the headings of a column in a worksheet with hundreds of rows?  That’s easy... freeze the panes! See how to do exactly that in this video.
  • 71
    Splitting the Worksheet Views
    01:32
    When it comes to comparing data at the top of a large worksheet with the data at the bottom of the worksheet, splitting the worksheet will make it real easy to see both sets of data.  In this clip you'll learn how to do it!
  • 72
    Arranging Worksheet Views
    01:37
    The emphasis of this lesson is the Arrange All button located on the View tab.  This will let you tile all open Excel documents on the screen.  Discover how to best use the Arrange Windows dialog box.
  • 73
    Worksheet Protection and Various View Options
    11 questions
  • SECTION 7:
    Working with Illustrations and Charts
  • 74
    Using Illustrations
    03:11
    Get ready to add some life to your worksheets by adding illustrations to them.  See how to add pictures, resize them and add shapes of all kinds to your worksheet.  Quick and easy – you’ll love it!
  • 75
    Formatting Pictures
    04:06
    Take advantage of Excel’s powerful photo editing features made available on the Picture Tools Format contextual tab.  Sure it’s a mouthful, but you’ll be singing its praises once you watch this clip and learn how to get the most of Quick Styles, Line Colors and a ton of preset graphic configurations for your pictures.
  • 76
    Formatting Shapes
    04:49
    Who knew shapes could come in such a variety of... well... shapes and sizes?!  Learn how to customize them and truly make your shapes unique in this video clip. Continuing on from the last clip, this lesson looks at the Drawing Tools Format contextual tab.  See how to modify and graphically enhance your shapes.  From shape fill to outline to 3D effects there are plenty of choices to create fantastic results.
  • 77
    Adding SmartArt into Worksheets
    04:23
    SmartArt graphics add color, shape, and emphasis to your text and data. It's easy to try out SmartArt graphics such as an organization chart, a time line or cycle. You can preview styles before choosing one, so you don't have to apply styles over and over again to find the one you want. And after you apply a style you can customize it with colors, animation, effects such as shadows, bevels, and glows, and more.  This lesson demonstrates how to create and modify an organizational chart through SmartArt.
  • 78
    Adding Pictures in SmartArt
    03:14
    Here we see how to create a SmartArt diagram, find a style that allows pictures, and how to insert pictures into the SmartArt diagram.  Learn how to do all of this in just a few minutes by watching this video lesson. 
  • 79
    Exploring Charts
    03:39
    Charts are a nice way to express your data results in a visually appealing manner. For example, a pie chart may show the results of data in a simpler form than simply a long row of data.  This clip shows off pie and bar charts and also provides some simple explanations of chart terminology.
  • 80
    Create a Simple Chart
    02:48
    So what will it be, Line chart or Pie chart? Can’t decide?  No problem!  This short tutorial lesson teaches you in just a couple minutes how to build either one of them.
  • 81
    Customizing Text in Charts
    02:24
    Rather than just accept the default text style, this lesson shows you how to completely customize your chart title and labels.  In this lesson, the Font dialog box is demonstrated and explained.
  • 82
    Formatting Chart Components
    01:49
    Picking up where we left on in the last lesson, this clip explores chart formatting and how to modify chart colors and background.  Also demonstrated and explained is the Format Data Point dialog box and several of its commands.
  • 83
    Working with Illustrations and Charts
    9 questions
  • SECTION 8:
    Printing, Proofing and More
  • 84
    Customizing Print Options
    03:26
  • 85
    Scaling Page Dimensions
    01:44
    When preparing for printing, it may be necessary to rescale the document to a specific paper width and height.  This lesson shows you how to do that by using the Page Layout tab on the ribbon.  See it in action now by watching this quick clip!
  • 86
    Modifying Gridlines and Headlines
    00:54
    Learn how to turn off gridlines and headings.  The gridlines are the lines between the rows and columns in the sheet to make editing and reading easier.  Note: These lines will not print unless Print is also checked in the Sheet options dialog box.
  • 87
    Creating Headers and Footers
    04:16
    A simple but sometimes overlooked feature is shown in nice detail as both header and footer modification options are discussed and demonstrated.
  • 88
    Printing Titles
    02:11
    This lesson will show you how to add print titles to a spreadsheet so your headings print on every page, without having to create those headings more than once.  See how this can be done by watching this 2 minute clip.
  • 89
    Using Proofing Tools
    03:44
    The proofing tools provided in Excel are Spell Check, Thesaurus and the Translate Tool.  Check out all these tools in action in this quick video lesson.
  • 90
    Printing, Proofing and More
    6 questions
  • SECTION 9:
    Advanced Excel Features
  • 91
    Renaming a Cell
    01:30
    See how easy it is to create names for your cells and learn why you might need to do this
  • 92
    Renaming Cell Ranges
    01:10
    If you want to learn how to select a range of cells and then use the column heading as the name then take a minute to watch this clip.
  • 93
    Using Name Manager
    01:30
    Once you become adept at working with named cells and ranges, you may want to consider using the Name Manager to tidy up your names.  This short clip will show you how to modify these names using the Name Manager.
  • 94
    Working with Absolute References
    02:58
    This helpful feature will make it easier to deal with situations when AutoFill does not enter the values you anticipated.
  • 95
    Using a Named Cell within a Formula
    01:34
    As simple as can be: Discover how to use named cells in formulas.  This lesson demonstrates how to do this building off a named cell created in a previous lesson.
  • 96
    Understanding PivotTables
    02:27
    The Pivot Table is powerful and efficient feature of Microsoft Excel 2010.  With it you can summarize a table’s data by its different fields (the table’s columns), and utilize this to generate critical data associated with the table.  It only sounds complicated.  Watch this short lesson to see how it’s done.
  • 97
    Create a Simple PivotTable
    03:03
    The key to creating a PivotTable is clicking into the data.  That is one of the important steps to creating a simple PivotTable.  This clip will show you the entire process of creating a simple PivotTable.  3 minutes of your time well spent in this one clip!
  • 98
    Update Your PivotTable
    03:36
    Once your PivotTable is created, if you have changes or updates to make you don't have to start from the beginning.  You can update and adjust existing tables to create what you need.  This clip will show you how it's done!
  • 99
    Understanding the Slicer Tool
    04:20
    Jumping off of the joy of PivotTables from previous lessons we can look at a new tool in Excel 2010 called Slicer that helps to really enhance the way a PivotTable works for us.  Take a look in this clip!
  • 100
    Formatting the Slicer Tool
    00:56
    You can change the look of your slices with some simple color formatting.  Learn how in this sub-minute clip!
  • 101
    Customizing PivotCharts
    02:00
    Learn how to create a PivotChart, how to put it on its own page and how to work with and adjust the chart and play with field buttons.
  • 102
    Creating Sparklines
    02:10
    Sparklines are a new feature in Excel 2010 and they help to provide a new visual representation of the data.  You can show a line, column or win/loss type of sparkline chart.  Learn how easy it is to use sparklines in this 2 minute clip!
  • 103
    Modifying Sparklines
    01:52
    Once you have a sparkline included in your worksheet you might want to make some design adjustments.  See how in this clip!
  • 104
    Inserting Sparklines from Data Ranges
    01:14
    You can use data ranges to make a sparkline chart.  In this quick clip we'll show you how to do it!
  • 105
    Saving to Excel WebApp
    02:13
    Need to collaborate on Excel files with others?  This clip will show you how to save and send your files through Windows Live SkyDrive.
  • 106
    Logging in to Excel WebApp
    01:19
    Learn how to locate and log in to Windows Live SkyDrive in this quick clip!
  • 107
    Modifying Excel WebApp Documents
    02:44
    Working with Excel WebApp can be done through SharePoint 2010 or through Windows Live.  In this clip, watch what you can do through Excel WebApp.
  • 108
    Viewing an Excel WebApp Document Version History
    01:11
    Need to see the different versions of your documents in Excel WebApp?  This clip will quickly show you how to do this!
  • 109
    Exploring Excel WebApp Menu Features
    01:18
    Take a quick tour of the different menu options within Excel WebApp!
  • 110
    Advanced Excel Features Quiz Part One
    10 questions
  • 111
    Advanced Excel Features Quiz Part Two
    11 questions

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students
  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: