Microsoft Office Excel 2010: Basic

Master spreadsheet terminology and navigate the spreadsheet environment in Excel, learn parts of the screen, how to get help, and various ways to navigate through the spreadsheet.

Explore essential spreadsheet terminology and learn core concepts for efficient Excel 2010 basic use in practice.

Explore the basic structure of Excel workbooks, worksheets, and cells. Identify columns, rows, and the active cell, and distinguish numbers from text labels.

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.

Discover how to preview button actions on the Excel 2010 ribbon by rolling over icons to see screen tips that explain what each button does.

Explore Excel window components, including the title bar and ribbon tabs (File, Home, Insert, Page Layout) with their groups, and inspect the formula bar, active cell, 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.

Access Excel help by clicking the question mark or pressing the help button, opening the help window connected to Office.com for article lookup and topic searches.

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.

Explore various ways to navigate a worksheet in Microsoft Office Excel 2010 basic, building essential navigation skills for efficient data work.

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 a large spreadsheet by using the scroll arrows on the right to move the view one row or column at a time without changing the active cell.

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

Explore navigating a worksheet by moving the active cell with arrow keys, using the name box and go-to dialog, and scrolling with scroll bars and the zoom controls.

Learn to navigate a spreadsheet, review essential spreadsheet terminology, and access help resources to reinforce your basic Excel skills.

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.

Create a new blank workbook in Excel, enter text and values in cells, and press Enter to commit. Use the Tab key to move right and observe the formula bar.

Select a cell to edit text or values, or use the formula bar and press enter to apply changes, with inline editing available by double-clicking the cell.

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

Explore the auto fill feature in Excel: start a value, drag the fill handle in the lower-right corner, and Excel automatically extends a series such as Monday, Tuesday, or quarters.

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

Control pivot table detail levels by collapsing and expanding fields in the design tab to switch between detailed data and high-level summaries.

Learn to enter and edit formulas in Excel 2010 basics. Develop fundamental skills in creating and modifying formulas to perform accurate calculations.

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

Discover the core Excel operators and how to use them in formulas, including addition, subtraction, multiplication, division, percentage, and exponent.

Create a basic Excel formula to sum quarterly sales for three employees using cell references. See the total update automatically as inputs change, with the formula in the formula bar.

Learn how to enter formulas in Excel by selecting the active cell, typing an equals sign, entering the formula, and pressing enter to display results in the same cell.

Enter formulas in Excel by using the mouse to click cells after starting with an equals sign, which automatically inserts references and reduces typing errors, then press enter to complete.

Master the order of operations in Excel, applying the precedence of percentages, exponents, multiplication and division, then addition and subtraction, with parentheses to control calculation sequence.

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.

Edit a formula in Excel by using the formula bar to add a missing cell reference (G7), then press Enter to update the results.

Explore the order of operations in Excel by building a formula that uses cell references, parentheses, and operators, and verify results by adjusting the order to ensure correct profit calculations.

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 picture to add visual interest to a spreadsheet, placing the outlanders spices logo at the top instead of plain text.

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.

Learn how to save and update your workbooks in Excel 2010 basic course. Master saving methods and updating workbook data.

Save a workbook by using the file tab and save as, name the file (spaces allowed), choose a save location, and select the format from the save as type dropdown.

Create a new workbook with control n, save with the quick access toolbar, rename the default book 4 to my new file, then close.

Save a file as an Excel 97-2003 workbook using Save As to ensure compatibility with older tools, preserving formatting, structure, and formulas.

Save a worksheet as a portable document format file via the file tab, save as, and selecting the ptf option, enabling distribution to anyone without Excel.

Learn to save a worksheet as a pdf from the Excel file menu, choose pdf as the format, enable open file after publishing, and view the result in Adobe Reader.

This demo shows how to edit and update a workbook, including changing a value and adding text, then save changes with Ctrl+S or the quick access toolbar before closing.

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

Learn to move and copy data and formulas, compare absolute and relative cell references, and insert or delete data in ranges, rows, and columns.

Move and copy data in Microsoft Office Excel 2010, focusing on basic data manipulation techniques.

Learn to move data across cells, worksheets, and workbooks using cut and paste with Ctrl+X and Ctrl+V, leveraging the clipboard to place data in a new location.

Learn to move data in a worksheet by cutting with the clipboard or ctrl+x, paste to a new cell, and save changes.

Copy data in Excel by selecting the data, using copy (Ctrl+C) to add it to the clipboard, then paste (Ctrl+V) at the destination while leaving the original intact.

Copy data in a worksheet using the clipboard, paste it into another cell, and use paste options to paste content or formatting only.

Move data in Excel by dragging: select the cell, hover until the four-headed arrow appears, then drag to the target cell to relocate data without the clipboard.

Select the source cell, drag to the destination with ctrl to copy the data, then release to finish.

Learn to move and copy data in Excel by drag-and-drop with the mouse. Use the control key to copy when dragging, bypassing the clipboard, and save your workbook.

Explore how the Office Clipboard extends Excel’s copy and paste by storing up to 24 items across all Office apps, enabling multi-item pasting between Excel, Word, and PowerPoint.

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.

Learn how to move and copy formulas in Excel 2010, mastering the basic techniques to manage your calculations.

Master relative references in Excel 2010 by understanding how references stay tied to their location when copying formulas, and how they automatically adjust as you move data.

Move a formula in Excel using cut-and-paste or drag, and observe that cell references may not adjust when relocated, so place the formula in the intended column.

Copy a formula down a column in Excel 2010 using the copy button; observe how relative references adjust for each row when adding first through fourth quarter sales.

See how to use the autofill handle to copy a formula across cells, automatically adjusting references for the new row, without using the clipboard.

Copy labels and formulas, then apply paste special to paste as values, number formatting, transpose, or keep source formatting, and finally paste as a link to enable updates.

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

Observe the limitations of relative references in Excel by building a commission calculation in bonus sales, showing how autofill flips references and causes errors, then undo and save the workbook.

Excel uses relative references most of the time, but absolute references keep a formula from changing when you copy it. Use a dollar sign to lock parts of the reference.

Explore how relative references change when copied, contrast with absolute references that never move, and use dollar signs to create mixed references where the column or row remains fixed.

Learn to apply absolute references in Excel, using F4 to toggle the row portion to stay fixed during autofill, so the commission rate remains correct for each row.

Learn how to insert and delete cell ranges, rows, and entire columns in Excel 2010.

Learn to insert a range in excel 2010 by selecting cells, choosing insert, and using the insert dialog to shift existing cells right or down, or insert rows or columns.

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.

Learn how to insert rows or columns in Excel 2010, automatically shifting existing data and using right-click or the insert options to add sheet rows or columns.

Insert entire rows in Excel 2010 by selecting rows, using the right-click insert, then input new data, copy formulas with autofill, and save the worksheet.

Delete a range of cells by highlighting it, then choosing delete from the ribbon or right-clicking and selecting delete. Specify how to shift the remaining cells and click OK.

Delete a range of cells in Excel 2010, choose how to handle surrounding data, and shift cells up; compare this with deleting an entire row, then save changes.

Move and copy data and formulas in Excel, compare absolute and relative references, and insert or delete rows, columns, and ranges.

Explore how to enter functions and use auto sum, and learn about common functions such as min, max, counting, and count a.

Learn how to enter functions in Microsoft Office Excel 2010 basic, using pre-defined formulas. Focus on entering functions, i.e., pre-defined formulas.

Discover how Excel's preloaded functions perform specific calculations using a consistent syntax: start with an equal sign, then the function name, and comma-separated arguments.

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.

Learn how to reference a range of cells in Excel by using a start and end address separated by a colon, such as A1:A4.

Learn how Excel's trace error button, a green triangle to the left of the formula results, visually flags potential formula errors.

Identify and fix syntax errors in Excel formulas, such as missing parentheses, using the automatic correction dialog or by manually adjusting the formula.

Enter sum in Excel 2010 by typing =sum to trigger type-ahead options, select the range with a colon, and close parentheses; watch error indicator and expect updates when values change.

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.

Enter a function in the formula bar using equals and sum to total Julie's sales from c8 to f8, then confirm with enter or the checkmark.

Learn to insert functions in Excel 2010 by using the insert function (fx) dialog, select a category, choose a function, and follow the guided argument prompts.

Learn to insert the sum function in Excel 2010 using the insert function dialog box and the fx button, then select the range with the mouse and save the workbook.

Explore the AutoSum feature in Excel 2010 to quickly sum data in a spreadsheet, using the dedicated button for fast, accurate totals.

Use the AutoSum button to automatically enter the sum function and its arguments. Excel guesses the range to add, usually the numbers above the active cell.

Master the auto sum feature in Excel 2010 by quickly summing a range with the auto sum button and checkmark, and explore functions like average and max.

Explore other common functions in Excel 2010, including min, max, count, and counta, to analyze data quickly and accurately.

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.

Demonstrates calculating average sales in Excel 2010 using the average function, selecting ranges like C5 to C9, and applying the formula across quarters with autofill.

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 the max function returns the largest number from a range in Excel, using an equal sign and a case-insensitive name, e.g., max of 1 through 80 yields 25.

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.

Explore how count and counta work in Excel 2010 basic course: count counts numeric cells and ignores blanks, while counta counts non-blank cells including text, demonstrated with practical range examples.

Learn how to enter predefined formulas, use the auto sum function, and apply common functions such as min, max, and count in Microsoft Excel 2010 basic.

Learn to format text, apply row and column formats, adjust numbers, and use conditional formatting, format painter, auto fill, and find and replace for neat formatting.

Explore text formatting in Microsoft Office Excel 2010 basic, learning how to format text for clear, professional spreadsheets.

Explore the font group on the ribbon to adjust font style and size, apply basic formatting, and use the dialog box launcher for precise options.

Format text in a worksheet in this demo by applying bold and italics, changing font size from 10 to 16, and previewing fonts in the font group before saving.

Select a noncontiguous range in Excel by choosing the first cell or range, holding the control key, and adding additional cells or ranges for formatting.

Learn to format noncontiguous cells in Excel 2010 by selecting G4 and A11 with the control key, then applying bold to both ranges. Save the workbook after de-selecting the selections.

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.

Master row and column formatting in Excel 2010, applying essential formatting techniques to organize and present data clearly.

Resize columns and rows in Microsoft Excel 2010 by dragging borders, double-clicking for automatic sizing, or right-clicking to set exact width in points, ensuring data displays correctly.

Learn to change column width and row height in Excel by dragging borders, using auto fit, and setting a fixed width for multiple columns, then save the workbook.

Select row 6 in the ribbon's font group, click the color bucket, and choose pale green to fill the row. Repeat for row 16, then save the worksheet.

Highlight a range of cells, merge them into one large cell, center the data with the merge and center feature, then adjust the alignment to other options.

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.

Select cells to apply borders, choose bottom border or remove all borders, and draw a custom border by selecting color and style and dragging on the sheet.

Learn to apply borders to cell ranges in Excel 2010, using the border dropdown for thick bottom borders and the more borders dialog to create a custom bottom border style.

Master drawing borders in Excel 2010 by using the border drawing pencil, selecting a line style and color, then dragging with the mouse to apply borders.

Learn to use the border drawing pencil in Excel 2010 to hand-draw borders around cells, selecting a thick line style from the font group and dragging to apply.

learn how to use the paste special dialog box to control pasted content—formulas, values, formatting, comments, and validation—and apply skip blanks or transpose to reshape data.

Format numbers in Microsoft Office Excel 2010 to display values clearly and consistently. Explore core number formatting topics within the basic course.

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.

Demonstrates formatting numbers in Excel 2010 using the number group: apply U.S. currency, adjust decimals, use best-fit columns, and convert a decimal to a percent.

Learn how to format numbers in Excel using the format cells dialog box on the number tab. Explore decimal places, positive and negative formats, and date formatting options.

Explore the number tab in Excel 2010, use the NOW function to display date and time, then format as a date-only style via the number format cells box and save.

Explore conditional formatting as an option to format text based on a condition in your spreadsheet.

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.

Create, modify, and delete rules in the rules manager to apply conditional formatting to g7 through g10, using top two values to color blue or yellow and stop processing.

Create conditional formats in Excel 2010 by selecting ranges, applying rules for values under 4000 and over 7000, and using top-bottom rules to highlight the top two items.

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 additional formatting options in Excel 2010, including auto fill, the format painter, and find and replace to achieve interesting formatting.

Use the format painter to copy a cell's formatting to another cell or range, saving time while preserving content. Clear formats to remove only formatting, leaving data intact.

Learn to copy cell formatting with the format painter in Excel, transferring formatting from a source cell to targets and ranges, including conditional formatting.

See how to use Excel 2010's auto fill to copy formatting only, using the auto fill options after dragging the handle to apply the formatting without changing the text.

Learn to apply predefined cell styles in Excel by selecting a cell or range, opening the styles gallery on the ribbon, and choosing a style with live preview before applying.

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.

Format a table quickly by applying predesigned table styles in Excel, using the format as table gallery and the design tab to customize and finalize the table.

Apply the Title cell style from the home ribbon's styles group to the merged area to create centered, blue title text, with the option to switch to another style later.

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.

Using find and replace, change formatting across a worksheet by matching exact text and applying bold and italics, demonstrating replace all to update 13 occurrences and saving the workbook.

Learn text formatting basics, including formatting rows, columns, and numbers, and explore conditional formatting, format painter, autofill, and find and replace.

Prepare and preview your worksheet for printing, and perform spellchecking. Adjust page setup options such as changing page orientation and adding headers and footers, then print.

Prepare your worksheet for printing by spellchecking and previewing to ensure accuracy and proper layout.

Learn how to use Excel 2010's spell checker to identify and correct misspellings, add names to a personal dictionary, and navigate the spelling dialog from the Review tab.

Learn to run a spell check on an Excel 2010 worksheet using the Review tab, review spelling suggestions, and apply changes or ignore errors across the entire sheet.

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.

Learn to find and replace text in Excel, swapping 'Melissa James' with 'Lee Jones' and applying formatting, using replace all for mass updates.

Preview printing in Excel using the page layout view and button, showing the worksheet as it would print and page 1 of 2 in the status bar.

Preview your worksheet before printing to verify layout using the print preview, adjust margins with the margins toggle, and navigate pages (page 1 of 2). Save and close the file.

Explore page setup options for the worksheet, including headers and footers, and switch orientation from portrait to landscape.

Control print scaling in Excel 2010. Use the bottom print options to choose no scaling, fit all columns on one page, or fill sheet on one page.

Demonstrates setting page orientation and scaling in Excel, switching from portrait to landscape, and fitting the sheet on one page via File and Page Layout options.

Set custom margins in Excel using the page setup dialog box margins tab to adjust top, bottom, left, and right margins, center content, and preview with print preview before printing.

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.

Insert headers and footers to add top and bottom information to printed spreadsheets via the insert tab and page layout view. Place content in left, center, or right sections.

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.

Insert and format headers and footers in Excel 2010 with the design tools to add page numbers and date. Include time, file path, sheet name, first page and odd/even options.

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.

Learn how to print your Excel 2010 worksheet on paper, as covered in this basic topic.

Explore page setup options to control print areas and repeat top and left titles. Preview layouts, print grid lines, and adjust grayscale or draft quality for error display on pages.

Print your worksheet by selecting the file tab and choosing print, or press Ctrl+P to open the print dialog, then pick a printer and adjust orientation, margins, and scaling before clicking print.

Select a range on the worksheet, open the file tab and choose print, then in settings choose print selection to print only the highlighted area.

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.

Prepare to print a worksheet by spellchecking, previewing, and configuring page setup options such as orientation, margins, headers, and footers, then print.

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.

Learn how to create basic charts in Excel 2010, including column and pie charts, and move charts from a sheet or embed them as objects.

Create charts in Excel by selecting headings and data, choosing a chart type and subtype, and using the chart tools to format, customize, and move the chart on your worksheet.

Create a 3D column chart from selected data in a 2010 sales workbook, use chart tools to add a title, and observe how changing a data value updates the chart.

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.

Identify chart elements and their names in a simple column chart, including data series, individual data points, legend, x axis categories, and y axis values.

Explore chart elements in Excel 2010, including data series, axes, legend, and chart title, by inspecting interactive columns and tooltips for quarter-by-quarter values.

Create and edit a pie chart in Excel 2010 by selecting noncontiguous data, inserting a 3d pie chart, resizing it, and adjusting values to total 100 percent.

Format charts in Excel 2010 to alter their appearance and style, applying formatting options to customize the look of your charts.

Learn to switch chart types in Excel using the change chart type option in the design tab, choosing from a gallery of column and pie charts.

Apply chart types and chart styles in Excel by selecting a chart, using the design tab to change from column to bar, and choosing a bar style.

Add axis labels to Excel charts by selecting the chart, opening the layout tab, and choosing axis titles for the x or y axis, then enter the title.

Modify a bar chart by selecting data series, changing fill colors, adding data labels, and configuring axis titles and legend positions for clearer visualization.

Explore chart basics, create charts, move them, and format them by adding labels or legends.

View large worksheets and lock row and column headers, and split the worksheet. Print large worksheets with page breaks and print titles, and work with multi-sheet workbooks.

Learn how to view large worksheets in Excel 2010 basic by locking row and column headers and splitting the worksheet.

Learn to freeze rows or columns by selecting the cell below or to the right, then use the View tab and Freeze Panes to keep headers visible as you scroll.

Arrange windows to compare two spreadsheets side by side, scroll each document separately, and copy or paste data between them. Open new windows and adjust zoom for effective reporting.

Learn to lock rows and columns in Excel 2010 using freeze panes, by selecting cell B6 and using the view tab to keep headings visible while scrolling.

Open a new window to duplicate the same file and arrange windows side by side. Scroll independently and note that changes in one update the other.

Learn how to split a worksheet into panes in Excel 2010 basic, enabling independent scrolling and side by side viewing for easier data comparison.

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.

Hide an entire column or row by selecting the header and right-clicking to choose hide. Use this to create side-by-side layouts or hide sensitive data from display in Excel.

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.

Identify hidden columns in a spreadsheet by noting missing column labels, and learn to unhide them by selecting the columns, right-clicking, and choosing unhide.

Learn to hide and unhide columns and worksheets in Excel 2010 by using the home tab, selecting ranges, and right-clicking to hide or unhide data.

Minimize the ribbon in Excel to maximize spreadsheet space by right-clicking the ribbon and choosing minimize the ribbon; toggle to reveal on tab selection, or uncheck to restore.

Learn to print large worksheets in Excel 2010 by setting print titles and creating page breaks.

Set print titles to repeat the top row on every page. Open the page layout tab, choose print titles, enter the title range, and click ok.

Set print titles in Excel by repeating top rows and left columns via the page layout tab; ensure headings appear on every page during print preview.

Explore page break preview in Excel 2010, showing dashed lines for automatic page breaks and solid lines for manual page breaks.

Adjust and manage page breaks in Excel 2010 by using page break preview, moving manual breaks, inserting new breaks, removing breaks, and resetting to automatic breaks.

Insert different even and odd headers and footers and add page numbers for double-sided documents. Ensure evens appear on the right and odds on the left.

Learn to work with workbooks that contain multiple worksheets, beyond the default three, and manage and navigate several sheets effectively.

Navigate between multiple worksheets in Excel 2010 by clicking sheet tabs or using the arrows in the lower left corner, including first and last sheet, in the sales history workbook.

Learn how to rename worksheet tabs in Excel 2010 to create descriptive names by double clicking the sheet tab, right-clicking to rename, or using the Home tab format.

Right-click a worksheet tab to open the shortcut menu, choose tab color from the palette, and apply a color such as yellow to make certain sheets stand out.

Learn to name worksheets and color code tabs in a large Excel workbook by double-clicking to rename, selecting multiple tabs with Ctrl, and applying consistent colors for quick navigation.

Learn to add worksheets in Excel 2010 by using the insert button near the tabs, or Shift+F11, or the Home tab, cells group, insert sheet.

Move worksheets in an Excel workbook by dragging the tab or using format to move or copy sheet, and choose the destination or create a copy with the control key.

Delete a worksheet in a multi-worksheet workbook by right-clicking the sheet tab and selecting delete from the cells group on the ribbon, or using the delete dropdown arrow.

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.

Preview and print multiple worksheets in Excel 2010 by selecting the desired sheets with the control key, then choosing file print to print only those sheets.

View and work with large worksheets by locking headers and splitting sheets. Print large worksheets using page breaks and print titles, and manage multiple worksheets in one workbook.

Explore conditional formatting with graphics, including data bars, icon sets, and color scales, and learn to insert and modify smart art graphics.

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

Apply data bars to create a bar chart effect within a table, showing each cell's value relative to others in the same range.

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

Apply data bars via conditional formatting on the sales per quarter sheet, then adjust the minimum to 4000 and maximum to 17000 for proportional bars.

Apply color scales in Excel 2010 to format cells by value, using a continuum of colors that can be shades of one color or multiple colors.

Apply color scales via conditional formatting to format cells from green to red, with yellow for middle values, using the color scale submenu.

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

Apply conditional formatting icon sets to create star visuals, hide numbers, and set thresholds (10000, 5000, <1000) to show solid, half, and empty stars for total sales.

Learn how to use SmartArt graphics to visualize ideas in Microsoft Office Excel 2010. Gain practical steps to create and apply SmartArt for clear diagrams.

Explore how to insert and customize SmartArt graphics in Excel 2010. Learn to choose categories, emphasize data relationships or flow charts, and add visuals to your spreadsheet.

Insert a smart art graphic in Excel 2010 by creating a blank worksheet, using the insert tab, illustrations, cycle category, and the first graphic, then modify it as needed.

Insert a smart art graphic into a spreadsheet, then apply quick style and bevel effects to circles and arrows for a polished, ready-to-use diagram.

Modify a SmartArt cycle in Excel 2010 by changing layout, applying styles and colors, deleting components, renaming steps to design, create, and test, and adjusting individual shapes.

Capture screenshots from various ex-SO products to reuse them in reports and for other purposes later on.

Learn how to insert a screenshot into Excel 2010 by maximizing the window, selecting the screenshot from the insert tab's illustrations group, and placing it at the insertion point.

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.

Clip a portion of another window by activating it, switching to Excel, and using insert screen clipping to drag and capture, then insert image at insertion point in the worksheet.

Modify a screenshot in Excel by selecting a portion, dragging it, and using picture tools to adjust color, blend, apply artistic effects, or create a subtle watermark.

Master conditional formatting with graphics such as data bars, icon sets, and color scales, and learn to insert and modify smart art graphics.

Navigate Excel 2010 basics, enter and edit data, format worksheets, use formulas including the sum function, format for presentation, print workbooks, create charts, and manage large workbooks.