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