Download Microsoft Excel 2010 Course Beginners/ Intermediate Training Free Udemy Course
Section 1: Getting Started
Lecture 1
Working Files – Download These First
Article
Lecture 2
0101 Overview Of Excel 2010
Lecture 3
0102 The New File Menu In Excel 2010
Lecture 4
0103 Exploring The Excel Workbook
Lecture 5
0104 What Will I Be Able To Do At The End Of This Course
Lecture 6
0105 Customizing The Quick Access Toolbar
Lecture 7
0106 Working With The Ribbons
Lecture 8
0107 Using The Files Included With This Course
Section 2: Working With An Excel Worksheet
Lecture 9
0201 Creating A New Workbook
Lecture 10
0202 Saving A Workbook
Lecture 11
0203 Saving In Other Formats
Lecture 12
0204 Open A Existing Workbook
Lecture 13
0205 Navigating An Excel Workbook
Section 3: Selecting and Entering Data
Lecture 14
0301 Entering Text And Numbers
Lecture 15
0302 Entering Numbers As Text
Lecture 16
0303 Inputting Dates And Times
Lecture 17
0304 Editing The Contents Of A Cell
Lecture 18
0305 Using Copy And Paste
Lecture 19
0306 The FILL Handle
Lecture 20
0307 Using Undo And Redo
Lecture 21
0308 Shortcuts For Selecting Cells
Lecture 22
0309 Inserting Cells , Columns And Rows
Lecture 23
0310 Deleting Cells , Columns And Rows
Lecture 24
0311 Changing Column Widths And Row Heights
Lecture 25
0312 Hiding And Unhiding A Column Or Row
Lecture 26
0313 Searching For Values In A Worksheet
Preview
Section 4: Developing A Workbook
Lecture 27
0401 Formatting And Naming Of Worksheet Tabs
Lecture 28
0402 Moving Worksheets Within And Between Workbooks
Lecture 29
0403 Copying Worksheets Within Workbooks
Lecture 30
0404 Inserting And Deleting Worksheets
Lecture 31
0405 Viewing More Than One Workbook
Lecture 32
0406 Hiding And Unhiding Worksheets
Section 5: Printing and Page Setup
Lecture 33
0501 Using The Print Area Command To Control What Excel Prints
Lecture 34
0502 Setting Page Margins And Page Orientation
Lecture 35
0503 Creating A Header And Footer
Lecture 36
0504 Using Page Break View
Lecture 37
0505 Setting Print Titles For Large Worksheets
Lecture 38
0506 Printing Gridlines Column Row Headings And Other Related Options
Lecture 39
0507 Enabling The New Page Layout View
Lecture 40
0508 Running The Spell Checker
Lecture 41
0509 Print Preview And Printing The Whole Or Part Of The Worksheet
Section 6: Workbook Formatting
Lecture 42
0601 Modifying Typeface , Font Size And Colors
Lecture 43
0602 Merging Cells
Lecture 44
0603 Applying Number Formats
Lecture 45
0604 Aligning Cell Contents
Lecture 46
0605 Changing The Text Direction In A Cell
Lecture 47
0606 Adding Borders To Cells And Ranges
Lecture 48
0607 Applying A Date Format To A Cell Or Range
Lecture 49
0608 Use Of The Format Painter
Lecture 50
0609 Clearing Cell Contents And : Or Formatting
Section 7: Carrying Out Calculations
Lecture 51
0701 Getting Started With Basic Math Formula Addition
Lecture 52
0702 Getting Started With Basic Math Formula Subtraction
Lecture 53
0703 Getting Started With Basic Math Formula Multiplication
Lecture 54
0704 Getting Started With Basic Math Formula Division
Lecture 55
0705 Getting Started With Basic Math Formula Operand
Lecture 56
0706 Order Of Operations With BODMAS
Lecture 57
0707 Introduction To Excel Formulas SUM
Lecture 58
0708 Copying Formulas And Functions
Lecture 59
0709 Displaying Formulae On A Worksheet
Lecture 60
0710 Some Useful Functions For Counting
Lecture 61
0711 Some Useful Functions For Averages
Lecture 62
0712 Some Useful Functions For Highest And Lowest
Lecture 63
0713 Absolute Referencing Requirements
Lecture 64
0714 Formulas Across Worksheets
Lecture 65
0715 Functions Across Worksheets
Lecture 66
0716 3D Referencing
Lecture 67
0717 Making Use Of Named Cells And Ranges
Section 8: Advanced Formatting
Lecture 68
0801 Enhancing Worksheets Using Themes
Lecture 69
0802 Working With Comments
Lecture 70
0803 Creating Your Own Auto Fill List
Lecture 71
0804 Turning Your Data Into A Table For Formatting
Section 9: Security
Lecture 72
0901 Using Protection On A Worksheet
Lecture 73
0902 Protecting Part Of A Worksheet To Facilitate Data Entry
Lecture 74
0903 Controlling Access To Cell Ranges By Password And Or User Accounts
Lecture 75
0904 Saving A Workbook With Password Protection
Section 10: Using Templates
Lecture 76
1001 Creating A Workbook From A Template
Lecture 77
1002 Creating Your Own Custom Template
Section 11: Graphics Objects
Lecture 78
1101 Inserting And Modifying Clipart
Lecture 79
1102 Using Smart Art Graphics
Lecture 80
1103 Adding Drawn Shapes To A Worksheet
Lecture 81
1104 Inserting An External Picture
Lecture 82
1105 Adding A Background Image To A Worksheet
Lecture 83
1106 Formatting Graphic Objects
Lecture 84
1107 Controlling Stacking Order And Alignment Of Multiple Graphics Objects
Lecture 85
1108 Grouping Graphic Objects
Lecture 86
1109 Accessing Formula Results In A Callout Bubble
Section 12: Using Excel As A Database
Lecture 87
1201 Fixing Rows And Columns On Screen
Lecture 88
1202 Fixing Rows And Columns For Print
Lecture 89
1203 Sorting Data In A Worksheet
Lecture 90
1204 Filtering Data In A Worksheet
Lecture 91
1205 Removing Duplicates In An Excel Database
Lecture 92
1206 Adding And Using Subtotals In An Excel Database
Lecture 93
1207 Splitting One Column Of Data Into More Columns
Lecture 94
1208 Splitting The Screen To View Different Parts Of The Same Worksheet
Lecture 95
1209 Linking To Data On A Webpage
Section 13: Using Charts in Excel
Lecture 96
1301 Creating A Chart The Long Way
Lecture 97
1302 Creating A Chart The Quick Way
Lecture 98
1303 Changing A Chart From A Sheet Object To A Sheet
Lecture 99
1304 Modifying Your Chart Type
Lecture 100
1305 Controlling Chart Style And Layout
Lecture 101
1306 Adding A Trend Line To A Chart
Lecture 102
1307 Pie Charts In More Detail
Section 14: More Advanced Formula
Lecture 103
1401 Adding An IF Function For Cell Comparisons
Lecture 104
1402 Using The IF Function To Suppress Excel Error Messages
Lecture 105
1403 Text Manipulation With Formulae Part 1
Lecture 106
1404 Text Manipulation With Formulae Part 2
Lecture 107
1405 Date Formula In Excel
Lecture 108
1406 DATEDIF A Hidden But Useful Formula
Lecture 109
1407 SUMIF COUNTIF And AVERAGEIF
Lecture 110
1408 Use Of A Formula To Rank Scores
Section 15: Conditional Formatting
Lecture 111
1501 Changing Cell Appearance Based On Its Value
Lecture 112
1502 Editing Conditional Formatting Rules On A Worksheet
Lecture 113
1503 Removing Conditional Formatting Rules
Lecture 114
1504 Highlighting Duplicate Values Using Conditional Formatting
Lecture 115
1505 Identifying The Top Or Bottom Percentage Of A Range
Lecture 116
1506 Use Of Data Bars Within Conditional Formatting
Lecture 117
1507 Use Of Colour Scales Within Conditional Formatting
Lecture 118
1508 Applying An Icon Set To Conditional Formatting Rules
Section 16: Office Web Apps and Excel
Lecture 119
1601 What Is Office Web Apps
Lecture 120
1602 Sign In To Or Sign Up For Your Own Sky Drive
Lecture 121
1603 Saving An Excel Workbook Into Sky Drive
Lecture 122
1604 Accessing And Editing An Excel Workbook Through Sky Drive
Lecture 123
1605 Telling Others Where Your Public Documents Are
Lecture 124
1606 Direct Linking Or Embedding Of Sky Drive Documents
Lecture 125
Creating A Folder Structure Within SkyDrive
Lecture 126
Deleting Files From SkyDrive
Course Page
https://www.udemy.com/excel-tutorial/
Download