Download Microsoft Excel 2010 Course Beginners/ Intermediate Training


Download Microsoft Excel 2010 Course Beginners/ Intermediate Training Free Udemy Course


Download Microsoft Excel 2010 Course Beginners Intermediate Training


 


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


 





Part 01
http://mir.cr/7SVA0ZKO


Part 02
http://mir.cr/1Z2H6NSW


Part 03
http://mir.cr/QXZZP1HV


Part 04
http://mir.cr/TGJOFGFR


Part 05
http://mir.cr/FEHFKRWB


Password


nulledpk.com







 



Tidak ada komentar