- Lesson 1 - Introduction to Excel 2010 Training
-
Welcome to Excel 2010 with Bill Kulterman. In this course we will be covering many of the great features of Excel 2010, including data manipulation, formatting, worksheets, printing, and charts.
- Lesson 2 - Entering Data
-
In this lesson users will be shown how to quickly and efficiently enter data in Excel 2010 by making use of numerous keyboard shortcuts and Ribbon usage.
- Entering and Selecting Data
- Lesson 3 - Moving Data
-
In this lesson we will be looking at how users can manipulate data using the Cut, Copy, and Paste commands within an Excel spreadsheet.
- Lesson 4 - Rows & Columns
-
In this lesson we will go over how an Excel spreadsheet is laid out and the best ways to display your data.
- Lesson 5 - Auto Fill
-
In this lesson we will be showing users the wonderful Excel 2010 feature known as Auto Fill. Using the Auto Fill handle, users will be able to quickly populate pertinent data within a spreadsheet with a simple point and click.
- Using the Fill Handle
- Fill Options
- Lesson 6 - Worksheets
-
Here we will be showing users how to navigate, rename and freeze Excel spreadsheets with multiple worksheets. Freeze panes are a great feature that will help users sort through data from rows and columns.
- Rename Sheets
- Freeze Panes
- Moving and Copying Sheets
- Lesson 7 - Saving a File
-
In this lesson we will be showing viewers who are new to Excel just what the difference between just saving a file and saving a file with certain specifications, such as save location and file extension.
- Save/Save-As
- File Formats
- Lesson 8 - The Interface
-
In this lesson we will be giving a broad overview of all the great things you can do with interface of Excel 2010, including customizing the Ribbon, and learning to navigate the Backstage view. Both of these additions to the Excel 2007/2010 versions have made customizing Excel to fit your needs truly easy.
- The Ribbon
- Dialogue Box
- Mini Toolbar
- Backstage View
- The Quick Access Toolbar
- Lesson 9 - Number Formatting
-
In this lesson we will be showing more features of the Ribbon within Excel 2010. Some of these features include formatting data within an Excel spreadsheet to reflect dates, times, percentages even custom settings.
- Currency/Accounting Styles
- Percentage Format
- Date Formats
- Special Formats
- Custom Formats
- Lesson 10 - Formatting Fonts
-
In this lesson we will be taking a look at the different ways you can customize the look of the text within an Excel spreadsheet to look polished and professional.
- Lesson 11 - Alignment
-
Take your text formatting to a whole new level with some of the great features in Excel 2010, including adjusting the wrap text to customize the length of your sentences and adjusting the orientation of text to really make it stand out.
- Merge and Center
- Orientation
- Alignment
- Wrap Text
- Line Break
- Lesson 12 - Conditional Formatting
-
For the users who need to visually represent data within Excel and really need to make that data stand out, this is the lesson for you. We will be going over how to separate data according to top percentage rules as well as creating color-coded data bar graphs.
- Conditional Formatting Menu
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Lesson 13 - Page Layout
-
Users wanting to take control of how they view and print their Excel documents will be amazed at the various ways we will show them how to zoom, re-orientate, and print selectable areas of the page.
- Zoom
- Margins
- Orientation
- Print Area
- Print Titles
- Lesson 14 - Printing Worksheets
-
Taking a deeper look at Excel's printing options, we will be able to adjust every aspect of our worksheets to our liking and print with ease.
- Print Preview
- Scale to Fit
- Page Breaks
- Printing Options
- Lesson 15 - Introduction to Formulas
-
In this lesson we will be going over the order of operations and how formulas are used within Excel. After harnessing the power of formulas in Excel, you will be able to produce worksheets with multiple calculations with minimal effort.
- Formula Rules
- Order of Operations
- Examples
- Building a Formula in Excel
- Value vs. Reference
- Lesson 16 - Total Values Simply
-
One of the most common tasks for users in Excel is to add together numbers in a spreadsheet. With AutoSum users will be able to find the sum, max, min, and count of any range of cells within a worksheet with a simple click of a button, saving a great deal of time.
- Using AutoSum
- AutoSum Selection
- Average
- Max/Min
- Count Numbers
- The Auto Calculator
- Lesson 17 - Relative, Absolute, & Named References
-
If you find yourself using formulas often in Excel, you'll really enjoy this lesson on Relative and Absolute references. Being able to choose where and how your formulas calculate cells, you'll be able to find any data with any formula on a spreadsheet.
- Relative Reference
- Absolute Reference
- 3d Reference
- Naming Ranges
- Grouping Worksheets
- Lesson 18 - Logical Functions
-
One of Excel's most useful features is that it allows users to create custom formulas to perform calculations on their data. By combining IF and AND statements, users can create a nearly infinite array of functions.
- The IF Function
- The Nested IF Function
- Using the IF and AND Functions
- Lesson 19 - Lookup Functions
-
The VLOOKUP and HLOOKUP functions are handy ones to know when you want Excel to lookup a value in one place and insert that value into another place. Another great addition to the function toolbox for any Excel user.
- VLOOKUP Function
- HLOOKUP Function
- Lesson 20 - Combine and Separate Text
-
Here's a quick look at a good way to concatenate text in Excel, to get the most bang for your buck when you have a small amount of room to show text. Also, Bill will be showing how you can easily convert text in a cell into columns.
- Concatenate Text
- Convert Text to Columns
- Lesson 21 - View Separate Data Simultaneously
-
Have you ever been working on multiple worksheets or workbooks and wondered if there was a better way than tabbing through each one? Well, in this lesson Bill shows you how to split up the screen with multiple workbooks or worksheets with Workspaces.
- Split Screen
- Workspaces with Multiple Workbooks
- Workspaces with Multiple Worksheets
- Lesson 22 - Sorting
-
With a click of the mouse, you can quick sort an entire spreadsheet to get totals. Bill shows you how to set up your own custom sort to organize a bevy of information with ease.
- Quick Sort
- Custom Sort
- Subtotals
- Lesson 23 - Filtering
-
By knowing how to use all the filters in Excel, you can sort through a large sum of data, and locate that specific amount of data you were looking for. In this lesson Bill shows you how to sort by numbers, dates, text and even custom filters.
- Auto Filter
- Number Custom Filter
- Date/Time Custom Filter
- Text Custom Filter
- Advanced Filter
- Lesson 24 - Define Data as a Table
-
In this lesson Bill shows the user how to format and convert a table in an Excel spreadsheet to better define data.
- Defining Data as a Table
- Adding a Total Row
- Expanding a Table
- Formatting a Table
- Convert a Table to a Range
- Lesson 25 - Introduction to Charts
-
In this less Bill goes over the many types of charts and what exactly makes up a chart in Excel. Charts are great for representing data visually, to help better interpret data at a glance.
- What is a Chart?
- Chart Components
- Chart Types
- Lesson 26 - Create a Column Chart
-
Data in Excel is a perfect medium for creating a multitude of charts. In this lesson, Bill will be showing the user how to create a Column Chart in Excel and how to fit to your needs perfectly with an array of options.
- Insert a Column Chart
- Choose a Chart Types
- Change the Range of Data
- Chart Design Options
- Chart Layout Options
- Chart Formatting Options
- Lesson 27 - Create a Line Chart
-
Data in Excel is a perfect medium for creating a multitude of charts. In this lesson, Bill will be showing the user how to create a Line Chart in Excel and how to fit to your needs perfectly with an array of options.
- Insert a Line Chart
- Choose the Chart Type
- Change the Data Range
- Chart Design Options
- Chart Layout Options
- Chart Formatting Options
- Lesson 28 - Create a Pie Chart
-
Data in Excel is a perfect medium for creating a multitude of charts. In this lesson, Bill will be showing the user how to create a Pie Chart in Excel and how to fit to your needs perfectly with an array of options.
- Insert a Pie Chart
- Choose the Chart Type
- Chart Design Options
- Chart Layout Options
- Chart Formatting Options
- Lesson 29 - Using Sparklines
-
Sparklines are a great new feature added to Excel 2010. In this lesson, Bill shows the user what a Sparkline is, and how to easily implement them into your worksheet to have quick and easy Sparkline charts.
- Line Chart
- Sparkline Options
- Column Chart
- Win/Lose Chart
- Formatting
- Lesson 30 - Introduction to PivotTables
-
PivotTables are a great new addition to the 2007/2010 additions of Excel. Users can easily sort through large amounts of data by ""pivoting"" column headers and produce meaningful information.
- Lesson 31 - Creating a PivotTable
-
In this lesson, Bill shows the user how to actually create PivotTables within a exercise file. We also get into filtering row and column labels to better suit your data searching needs, and finally go through many of the style options you can have with your PivotTables.
- Report Filter
- Values
- Row and Column Labels
- Styles
- Style Options
-
- Lesson 32 - More Fun With PivotTables
-
Now that we know the basics of PivotTables, we can dive deeper into some of the more advanced features within a PivotTable, including sorting, calculating, and using the Slicer, which is a neat tool built into the PivotTable with allows the users to filter data with a click of a button.
- PivotTable Options
- Sorting a PivotTable
- Calculated Fields
- Show Values As
- Slicer
- Show Report Pages
- Lesson 33 - Create a PivotChart
-
Along the same lines of PivotTables, PivotCharts are used to visually represent data within a PivotTable. Here, Bill will be showing the user how to insert a PivotChart into a worksheet, manipulate the data, and use many of the PivotChart tools, including the Slicer tool.
- Insert a PivotChart
- Manipulate the Fields
- Field Buttons
- PivotChart Tools
- Slicer
- Create a PivotChart from a PivotTable
- Lesson 34 - Next Steps
-
Now that you’ve watched the course, you might find yourself asking “what’s next?” In this lesson, we’ll learn about other ways to practice what we’ve learned and where to go if we get stuck along the way.
- Excel 2010 Training Overview