UDEMY
UDEMY Logo

Microsoft Excel 2010 for Beginners and Intermediate 

  • Offered byUDEMY

Microsoft Excel 2010 for Beginners and Intermediate
 at 
UDEMY 
Overview

Learn to Invoke the Power of Microsoft Excel in easy to follow stages

Duration

9 hours

Total fee

529

Mode of learning

Online

Official Website

Go to Website External Link Icon

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
Read more
Details Icon

Microsoft Excel 2010 for Beginners and Intermediate
 at 
UDEMY 
Course details

Who should do this course?
  • Suitable for beginners to advanced users
  • Ideal for users who learn faster when shown
What are the course deliverables?
  • 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
More about this course
  • 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

649
– / –
11 hoursCertificate
– / –
– / –
3.2 K
– / –
3.5 K
– / –
View Other 2339 CoursesRight Arrow Icon
qna

Microsoft Excel 2010 for Beginners and Intermediate
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...