Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MoreMicrosoft Excel 2010 Course Beginners/ Intermediate Training
Rating: 4.5 out of 54.5(2,387 ratings)
69,322 students
Microsoft Excel 2010 Course Beginners/ Intermediate Training
Learn to Invoke the Power of Microsoft Excel in easy to follow stages
Created byInfinite Skills
Last updated 1/2017
English
English
What you'll learn
- Learn Microsoft Excel 2010 from a professional trainer from your own desk.
- 126 lectures (9.5 hours of content) teaching you from the basic to the advanced of this powerful program
- Suitable for beginners to advanced users. ideal for users who learn faster when shown.
- Visual training method, offering users increased retention and accelerated learning.
- Breaks even the most complex applications down into simplistic steps.
Explore related topics
Course content
16 sections • 126 lectures • 9h 16m total length
- Working Files - Download These First0:01
- 0101 Overview Of Excel 20106:16
This Excel 2010 Training Course is just one of many courses that are created by InfinteSkills. More titles are visible on the InfiniteSkills Website. Click for More Information
- 0102 The New File Menu In Excel 20105:09
- 0103 Exploring The Excel Workbook2:25
Explore how a workbook contains unlimited worksheets with text, numbers, dates, formulas, and formatting, and master the fixed dimensions of 16,384 columns and 1,048,576 rows.
- 0104 What Will I Be Able To Do At The End Of This Course3:53
Start from a blank spreadsheet and build functional sheets with text, numbers, dates, formatting, formulas, charts, live web data, sorting, filtering, and share online.
- 0105 Customizing The Quick Access Toolbar2:52
- 0106 Working With The Ribbons3:46
Explore the Excel 2010 Ribbon interface, including the Home Ribbon, Insert Ribbon, Page Layout Ribbon, Formula Ribbon, Data Ribbon, Review Ribbon, View Ribbon, and Developer Ribbon, for faster access.
- 0107 Using The Files Included With This Course0:33
Access all course files in the working folder, including two images used in the inserting images lesson and the alphabetically listed files from text manipulation onward.
- 0201 Creating A New Workbook1:36
- 0202 Saving A Workbook2:25
- 0203 Saving In Other Formats3:04
Learn how to save workbooks in formats beyond Excel 2010, using the Save As dialog (F12) to export to xlsx, 97–2003, csv, text, pdf, and XPS, with compatibility considerations.
- 0204 Open A Existing Workbook1:45
Open an existing Excel 2010 workbook using Ctrl+O, File > Open, or File > Recent to locate and open files from the default location or recent items.
- 0205 Navigating An Excel Workbook5:17
Navigate an Excel workbook quickly using keyboard shortcuts like Ctrl+Home, Ctrl+End, and Alt+Page Up/Down. Move between cells, rows, columns, and sheets, and learn end mode to jump to data boundaries.
- 0301 Entering Text And Numbers3:00
Enter text and numbers in Excel by selecting a cell, typing values, and confirming with enter or tab. Observe left alignment for text and right alignment for numbers.
- 0302 Entering Numbers As Text3:47
Learn to force Excel to treat numbers as text to preserve leading zeros, using an apostrophe or preformatted text cells, for identifiers like zip codes or phone numbers.
- 0303 Inputting Dates And Times4:03
Master entering and formatting dates and times in Excel 2010, including default date formats, slash or hyphen inputs, two-digit year handling, and time with colons.
- 0304 Editing The Contents Of A Cell2:08
- 0305 Using Copy And Paste6:47
Learn to copy and paste in Excel 2010, using the clipboard and multi clipboard, drag and drop, and shortcuts like Ctrl+C and Ctrl+V with orientation preserved.
- 0306 The FILL Handle7:05
- 0307 Using Undo And Redo3:03
Learn how to use undo and redo in Excel 2010, including the shortcut keys Ctrl+Z and Ctrl+Y, the drop-down history, and how saving preserves history for later undo.
- 0308 Shortcuts For Selecting Cells5:12
Learn to select cells, rows, columns, and the whole sheet in Excel using mouse actions and keyboard shortcuts, including shift, ctrl, and spacebar, for efficient formatting and editing.
- 0309 Inserting Cells , Columns And Rows5:17
- 0310 Deleting Cells , Columns And Rows3:21
- 0311 Changing Column Widths And Row Heights4:06
Adjust column widths and row heights by dragging between headers and using auto-fit to the widest entry. Use the home ribbon to set sizes for multiple columns.
- 0312 Hiding And Unhiding A Column Or Row5:09
- 0313 Searching For Values In A Worksheet 5:34
- 0401 Formatting And Naming Of Worksheet Tabs3:41
Learn to rename and format worksheet tabs in Excel 2010, using double-click or right-click renaming, 1–32 character limits, allowed punctuation, and tab color coding for organization.
- 0402 Moving Worksheets Within And Between Workbooks4:49
Master moving and copying worksheets in Excel 2010, using drag-and-drop or right-click move or copy between workbooks, and resolve name conflicts by creating duplicates.
- 0403 Copying Worksheets Within Workbooks3:17
Copy sheets within a workbook by dragging with the control key or by right-clicking and choosing create a copy, preserving column widths and formatting for safe duplication.
- 0404 Inserting And Deleting Worksheets3:33
Learn how to insert and delete worksheets in Excel 2010, placing new sheets to the left or end, using the home ribbon or keyboard shortcuts, and confirming deletions.
- 0405 Viewing More Than One Workbook4:34
Open and view two workbooks simultaneously. Switch between them with Ctrl+F6 or Ctrl+Tab, and arrange them with tiled, horizontal, vertical, or cascade layouts.
- 0406 Hiding And Unhiding Worksheets2:02
Learn how to hide and unhide worksheets in Excel 2010, using the sheet tab or the format ribbon, and recover accidentally hidden sheets.
- 0501 Using The Print Area Command To Control What Excel Prints4:03
- 0502 Setting Page Margins And Page Orientation3:29
- 0503 Creating A Header And Footer4:48
Learn to add headers and footers in Excel 2010 using page layout, with custom headers and footers in left, center, and right sections, including page numbers, date, and file path.
- 0504 Using Page Break View2:55
Master page break preview in Excel to adjust page breaks by dragging blue lines, optimize print preview layouts, and reduce number of pages while returning to normal view for editing.
- 0505 Setting Print Titles For Large Worksheets3:01
Learn to set print titles in large worksheets by repeating top row headings across every page using the page layout's print titles feature, with multiple rows and optional left-hand columns.
- 0506 Printing Gridlines Column Row Headings And Other Related Options2:48
- 0507 Enabling The New Page Layout View3:30
Enable the page layout view in Excel 2010 to edit headers and footers in three sections, insert fields like page numbers and date, and preview via print preview.
- 0508 Running The Spell Checker3:23
- 0509 Print Preview And Printing The Whole Or Part Of The Worksheet4:03
Explore Excel 2010 print options with the print preview box, choosing printer, page size, orientation, margins, and whether to print active sheets, a whole workbook, or a selection.
- 0601 Modifying Typeface , Font Size And Colors6:12
Master font formatting in Excel by changing typeface, font size, and color for selected cells. Apply bold, italic, underline, strike-through, and optional superscript or subscript to emphasize data.
- 0602 Merging Cells2:45
- 0603 Applying Number Formats4:04
Highlight cells to format numbers in Excel, applying currency, accounting, comma, and percentage styles, adjust decimals, and explore the number format options from general to currency and accounting.
- 0604 Aligning Cell Contents2:02
Learn to align Excel 2010 cell contents with horizontal options (left, center, right) and vertical options (bottom, middle, top) for polished presentation.
- 0605 Changing The Text Direction In A Cell3:38
Learn to change the text direction in a cell by rotating text with orientation options, including counter-clockwise, clockwise, vertical, or rotate up and down, refine angles with the alignment dialog.
- 0606 Adding Borders To Cells And Ranges4:43
Apply borders to cells and ranges to print, not just grid lines. Use the border tool to select styles, colors, and sides, and explore more borders for precise control.
- 0607 Applying A Date Format To A Cell Or Range5:15
Apply and customize date formats in Excel using short, long, or custom formats with m's, d's, and y's; learn that dates are stored as serial numbers behind the scenes.
- 0608 Use Of The Format Painter4:29
- 0609 Clearing Cell Contents And : Or Formatting2:50
Master clearing cell contents without losing formatting, learn when to use delete vs clear contents, and restore default formatting with the format painter in Excel 2010.
- 0701 Getting Started With Basic Math Formula Addition5:23
- 0702 Getting Started With Basic Math Formula Subtraction3:20
Learn how to perform subtraction in Excel 2010 using the equals sign and cell references, including multi-cell formulas, color-coded inputs, and dynamic updates when inputs change.
- 0703 Getting Started With Basic Math Formula Multiplication2:45
Learn basic multiplication formulas in Excel using the equals sign and the asterisk, referencing cells G1 and G2. See how changing feed cells updates results automatically across the multiplication sheet.
- 0704 Getting Started With Basic Math Formula Division4:22
- 0705 Getting Started With Basic Math Formula Operand2:36
Learn how to use the operand to raise one cell to another power in Excel, with equals syntax and examples like A1^A2 and G1^G2, plus how results update.
- 0706 Order Of Operations With BODMAS3:14
Discover how Excel uses the BODMAS order of operations, prioritizing brackets, then division and multiplication, then addition and subtraction, to evaluate formulas like A1 + A2 times A3.
- 0707 Introduction To Excel Formulas SUM7:46
Master Excel formulas by using the sum function and ranges to add rows, columns, or rectangles, from b2 to b8 to the grand total, with autoSUM.
- 0708 Copying Formulas And Functions6:55
Copy formulas and functions in Excel, and use paste, fill handle, and autosum to quickly extend calculations while understanding how relative references adjust and avoid #REF errors.
- 0709 Displaying Formulae On A Worksheet2:59
- 0710 Some Useful Functions For Counting4:06
Explore useful counting functions in Excel, including count, counta, countblank, countif, and countifs, and learn how to count numbers, non-numeric cells, and blanks to troubleshoot data.
- 0711 Some Useful Functions For Averages4:02
Learn how to compute mean, mode, and median in Excel 2010 using the average function and related tools, with a banana data set and practical examples.
- 0712 Some Useful Functions For Highest And Lowest3:15
Learn to use the min and max functions to identify the lowest and highest values in a range, apply them across rows and columns in Excel.
- 0713 Absolute Referencing Requirements5:37
Learn to use absolute referencing in Excel to keep certain cell references fixed when copying formulas. Use $ signs or F4 to lock rows and columns.
- 0714 Formulas Across Worksheets7:46
Create cross-sheet formulas to summarize weekly fruit totals by linking cells from week sheets into a summary sheet, using equals, sheet names, and paste link to update automatically.
- 0715 Functions Across Worksheets4:44
Master cross-worksheet calculations in Excel 2010 by using sum and average across sheets, preserving source values and understanding sheet references.
- 0716 3D Referencing6:58
- 0717 Making Use Of Named Cells And Ranges9:24
Define named cells and ranges to shorten formulas and enable references across sheets. Use name tool or name box, set workbook scope, and apply names in sum, average, or count.
- 0801 Enhancing Worksheets Using Themes2:40
- 0802 Working With Comments4:45
Learn how to add, edit, and delete comments in Excel 2010, using the review ribbon to attach notes to cells, resize fixed comments, and control indicators.
- 0803 Creating Your Own Auto Fill List5:45
Create and manage autofill lists in Excel using the fill handle, including months and days, and extend to custom lists by importing, editing, and deleting entries.
- 0804 Turning Your Data Into A Table For Formatting5:32
Learn to turn a data range into a formatted Excel table, apply styles and header options, resize or convert back to range, and leverage built-in filters for analysis.
- 0901 Using Protection On A Worksheet3:35
- 0902 Protecting Part Of A Worksheet To Facilitate Data Entry3:59
Learn how to protect a worksheet while leaving data-entry holes by unlocking specific cells, applying sheet protection, and ensuring formulas and structure stay intact.
- 0903 Controlling Access To Cell Ranges By Password And Or User Accounts5:17
- 0904 Saving A Workbook With Password Protection3:46
Protect your excel workbooks by setting a password to open or modify. Use file > save as > tools > general options to apply password protections and read-only options.
- 1001 Creating A Workbook From A Template3:35
Access Office.com templates from the File menu in Excel 2010, download a template such as Home financial expenses, and save the filled workbook with a meaningful name, formulas intact.
- 1002 Creating Your Own Custom Template6:16
Create a custom Excel 2010 template by clearing nonessential data and preserving formulas, then save as an .xltx and access via File > New > My Templates.
Description
A Verifiable Certificate of Completion is presented to all students who undertake this course.
In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application.
In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.
By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.