Microsoft Excel 2010 for Beginners and Intermediate
- Offered byUDEMY
Microsoft Excel 2010 for Beginners and Intermediate at UDEMY Overview
Duration | 9 hours |
Total fee | ₹529 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Excel 2010 for Beginners and Intermediate at UDEMY Highlights
- Certificate of completion
- Access on mobile and TV
- Full lifetime access
- 30-Day Money-Back Guarantee
Microsoft Excel 2010 for Beginners and Intermediate at UDEMY Course details
- Suitable for beginners to advanced users
- Ideal for users who learn faster when shown
- 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
- This on-line course helps you learn Microsoft Excel 2010, beginning with the basics of making your first worksheet. Topics like basic to advanced formula and functions are covered then. A chapter on a way to connect with Microsoft internet Apps is additionally included. The course also shows a way to use your own SkyDrive to store and share your Microsoft excel projects. As a part of this course, you will be able to additionally transfer the operating files that help you to figure out the way to use Microsoft excel 2010. With this course, you shall be well versed and capable of operating with Microsoft excel 2010 in any business or professional setting. Course provided by Udemy
Microsoft Excel 2010 for Beginners and Intermediate at UDEMY Curriculum
Working Files - Download These First
0101 Overview Of Excel 2010
0102 The New File Menu In Excel 2010
0103 Exploring The Excel Workbook
0104 What Will I Be Able To Do At The End Of This Course
0105 Customizing The Quick Access Toolbar
0106 Working With The Ribbons
0107 Using The Files Included With This Course
0201 Creating A New Workbook
0202 Saving A Workbook
0203 Saving In Other Formats
0204 Open A Existing Workbook
0205 Navigating An Excel Workbook
0301 Entering Text And Numbers
0302 Entering Numbers As Text
0303 Inputting Dates And Times
0304 Editing The Contents Of A Cell
0305 Using Copy And Paste
0306 The FILL Handle
0307 Using Undo And Redo
0308 Shortcuts For Selecting Cells
0309 Inserting Cells , Columns And Rows
0310 Deleting Cells , Columns And Rows
0311 Changing Column Widths And Row Heights
0312 Hiding And Unhiding A Column Or Row
0313 Searching For Values In A Worksheet
0401 Formatting And Naming Of Worksheet Tabs
0402 Moving Worksheets Within And Between Workbooks
0403 Copying Worksheets Within Workbooks
0404 Inserting And Deleting Worksheets
0405 Viewing More Than One Workbook
0406 Hiding And Unhiding Worksheets
0501 Using The Print Area Command To Control What Excel Prints
0502 Setting Page Margins And Page Orientation
0503 Creating A Header And Footer
0504 Using Page Break View
0505 Setting Print Titles For Large Worksheets
0506 Printing Gridlines Column Row Headings And Other Related Options
0507 Enabling The New Page Layout View
0508 Running The Spell Checker
0509 Print Preview And Printing The Whole Or Part Of The Worksheet
0601 Modifying Typeface , Font Size And Colors
0602 Merging Cells
0603 Applying Number Formats
0604 Aligning Cell Contents
0605 Changing The Text Direction In A Cell
0606 Adding Borders To Cells And Ranges
0607 Applying A Date Format To A Cell Or Range
0608 Use Of The Format Painter
0609 Clearing Cell Contents And : Or Formatting
0701 Getting Started With Basic Math Formula Addition
0702 Getting Started With Basic Math Formula Subtraction
0703 Getting Started With Basic Math Formula Multiplication
0704 Getting Started With Basic Math Formula Division
0705 Getting Started With Basic Math Formula Operand
0706 Order Of Operations With BODMAS
0707 Introduction To Excel Formulas SUM
0708 Copying Formulas And Functions
0709 Displaying Formulae On A Worksheet
0710 Some Useful Functions For Counting
0711 Some Useful Functions For Averages
0712 Some Useful Functions For Highest And Lowest
0713 Absolute Referencing Requirements
0714 Formulas Across Worksheets
0715 Functions Across Worksheets
0716 3D Referencing
0717 Making Use Of Named Cells And Ranges
0801 Enhancing Worksheets Using Themes
0802 Working With Comments
0803 Creating Your Own Auto Fill List
0804 Turning Your Data Into A Table For Formatting
0901 Using Protection On A Worksheet
0902 Protecting Part Of A Worksheet To Facilitate Data Entry
0903 Controlling Access To Cell Ranges By Password And Or User Accounts
0904 Saving A Workbook With Password Protection
1001 Creating A Workbook From A Template
1002 Creating Your Own Custom Template
1101 Inserting And Modifying Clipart
1102 Using Smart Art Graphics
1103 Adding Drawn Shapes To A Worksheet
1104 Inserting An External Picture
1105 Adding A Background Image To A Worksheet
1106 Formatting Graphic Objects
1107 Controlling Stacking Order And Alignment Of Multiple Graphics Objects
1108 Grouping Graphic Objects
1109 Accessing Formula Results In A Callout Bubble
1201 Fixing Rows And Columns On Screen
1202 Fixing Rows And Columns For Print
1203 Sorting Data In A Worksheet
1204 Filtering Data In A Worksheet
1205 Removing Duplicates In An Excel Database
1206 Adding And Using Subtotals In An Excel Database
1207 Splitting One Column Of Data Into More Columns
1208 Splitting The Screen To View Different Parts Of The Same Worksheet
1209 Linking To Data On A Webpage
1301 Creating A Chart The Long Way
1302 Creating A Chart The Quick Way
1303 Changing A Chart From A Sheet Object To A Sheet
1304 Modifying Your Chart Type
1305 Controlling Chart Style And Layout
1306 Adding A Trend Line To A Chart
1307 Pie Charts In More Detail
1401 Adding An IF Function For Cell Comparisons
1402 Using The IF Function To Suppress Excel Error Messages
1403 Text Manipulation With Formulae Part 1
1404 Text Manipulation With Formulae Part 2
1405 Date Formula In Excel
1406 DATEDIF A Hidden But Useful Formula
1407 SUMIF COUNTIF And AVERAGEIF
1408 Use Of A Formula To Rank Scores
1501 Changing Cell Appearance Based On Its Value
1502 Editing Conditional Formatting Rules On A Worksheet
1503 Removing Conditional Formatting Rules
1504 Highlighting Duplicate Values Using Conditional Formatting
1505 Identifying The Top Or Bottom Percentage Of A Range
1506 Use Of Data Bars Within Conditional Formatting
1507 Use Of Colour Scales Within Conditional Formatting
1508 Applying An Icon Set To Conditional Formatting Rules
1601 What Is Office Web Apps
1602 Sign In To Or Sign Up For Your Own Sky Drive
1603 Saving An Excel Workbook Into Sky Drive
1604 Accessing And Editing An Excel Workbook Through Sky Drive
1605 Telling Others Where Your Public Documents Are
1606 Direct Linking Or Embedding Of Sky Drive Documents
Creating A Folder Structure Within SkyDrive
Deleting Files From SkyDrive
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?