Microsoft Office Excel 2010: Basic

We will discuss the Excel environment in this topic within the Microsoft Office Excel 2010 Basic course.

Explore the Excel 2010 window components, including the title bar, quick access toolbar, ribbon and groups, formula bar, worksheet, and status bar.

Learn how to get help in Microsoft Excel in this topic and understand how to access available assistance while using the program.

Learn how to access Excel help, switch between office.com and content from this computer, search topics such as what's new, and locate wrap text in a cell.

Learn worksheet navigation in Excel 2010, including clicking the active cell, using arrow keys, and tab or shift-tab to move, plus ctrl+home and ctrl+end to reach the data.

Navigate large worksheets by dragging the scroll box, use Ctrl+G to go to a cell, and adjust zoom with the status bar slider.

Learn how to enter and edit text and values, calculate data with formulas, insert pictures to enhance spreadsheets, and save and update workbooks.

Enter and edit text and values within a spreadsheet to build and manage your Excel data.

Learn how Excel left-aligns text and right-aligns numbers by default in cells, and how to modify these default alignments when entering data.

Learn to edit cell contents in Excel 2010 using the formula bar, navigate with keys, and multi-select ranges with control for edits.

Enter January, drag the autofill handle to automatically fill the month series from January to December in Excel 2010.

Create formulas in Microsoft Office Excel 2010 by entering an equals sign, referencing cells, and using operators to add, multiply, and average your data.

This demo shows entering cell references with the mouse, starting with an equal sign and using plus signs to total Pamela Carders' sales across quarters 1 through 4.

Learn how to work with pictures to add visual interest to our spreadsheet in Excel.

Add an image to a worksheet by using the insert tab, selecting picture, choosing a file, and inserting it; then resize and format the image with picture tools format tab.

Insert a logo from your file system into the sales file, resize with corner handles to scale or set a precise size, rotate, and place in the upper right corner.

Enter and edit text and values, learn to create and edit formulas, insert pictures, and save and update workbooks.

Demonstrates using the clipboard task pane and Office Clipboard to copy ranges (A3:G3, 5:G9), paste into a new workbook, save the file, and manage multiple clipboard items.

Explore absolute and relative references in Excel, learning how to differentiate and apply them effectively in worksheets.

Learn how to insert a range of cells in Excel 2010, shift existing data down, enter new employee data, copy formulas with the autofill handle, and save the workbook.

Enter a function in Excel by starting with equals sign, then function name and arguments in parentheses, where arguments can be numbers, text, cell addresses, a range, or another function.

Use the mouse to enter a sum function by dragging cell range to add Audreys quarterly sales, auto-insert references and closing parentheses, then ignore the error and save the workbook.

Learn how the average function in Excel computes the arithmetic mean by using an equal sign, the function name, and a cell range or numbers, such as A1 through A8.

Use the min function to scan a list and return the smallest number. Start with =MIN and list the arguments, such as the range 1 through 25.

Use the min function to find the minimum value in a range of cells, identifying the smallest sales figure across quarters and saving time by automation.

Learn how to use the max function in Excel to find the largest value in a range, enter the formula, and copy it across to display max sales per quarter.

Apply the count function to a range to count cells that contain numeric values, ignoring text and blanks, and return the total number of values.

Select the cell or range to format, then right-click and choose format cells to open the dialog. Use the font tab to change fonts and apply formats, then click okay.

Open the format cells dialog box, use the font tab to apply Times New Roman, bold, italics, size 18 with the preview, then set size 12 and save.

Set alignment by selecting a range, then choose center alignment to center text in each cell. Use merge and center to create a label across cells and save the workbook.

Enter raw numbers in a spreadsheet and use the number group to apply formatting that displays values as currency with a dollar sign, comma separators, and two decimal places.

Highlight ranges with conditional formatting in Excel by using the ribbon to apply built-in rules or create a custom condition, such as values greater than 2000, with a yellow background.

Apply conditional formatting with the new formatting rule dialog box to create rule types, set conditions such as values above 7000, and apply a blue background.

Edit and delete conditional formats in a worksheet, and manage rules using the rules manager to adjust colors and borders for top performers. Save and close the workbook.

Explore the cell styles gallery to quickly format both appearance and number formatting, using the self-styled gallery to merge styles or create new ones that match your corporate identity.

Highlight data, format as a table with a blue style, and ensure print-ready formatting. Sort and filter to manage totals, hide fields, and apply table rules in Excel.

Use find and replace in Excel 2010 to locate and swap values by opening the dialog from the Home tab, entering the target text, and choosing replace or replace all.

Adjust margins and page setup to fit more content on a page, choosing portrait or landscape, header/footer space, and centering options, then preview and print with fit-to-page scaling.

Learn to create headers and footers on worksheet page using the insert tab, placing content in the upper left, center, and right. Insert page numbers and current date, then preview.

Learn how to print grid lines and headings in Excel, toggle on-screen elements, and configure print options including grid lines, headings, and print area in page layout and sheet options.

Demonstrates printing a selected range in Excel 2010 by selecting a specific cell range and switching print settings from active sheets to print selection, so only the chosen area prints.

Learn to create basic charts in Excel 2010, including column and pie charts, move them, and format with labels and legends for clear data visualization.

Move a chart to a new sheet named bonus track, zoom it, convert it back to an embedded object on sheet 1 by dragging and dropping, then save the workbook.

Split a worksheet into vertical and horizontal panes to scroll and compare rows side by side within one workbook; changes reflect across panes, then remove the split and save.

Learn how to reveal hidden columns in Excel by selecting surrounding columns, then using the right-click menu or the Home tab's format group to choose unhide.

Learn to manage multiple worksheets in a workbook, insert new sheets, rename, move, copy, and delete sheets using drag-and-drop, keyboard shortcuts, or the format menu.

Select the desired worksheets by holding the control key and clicking the tabs, open the File tab, use Print with the preview to print only the chosen sheets.

Learn how to apply conditional formatting with graphics in Excel 2010, using data bars, icon sets, and color scales to visually analyze data.

Explore the conditional formatting rules manager to view, create, edit, highlight, or delete formatting rules for a worksheet, including data bars.

Explore icon sets as a graphical option in Excel 2010 to visualize values in a rating column using star icons filled according to data.

Insert a screenshot quickly in Excel 2010 by using the illustrations group to insert screenshots, or use screen clipping to capture and place a portion of a window.