Microsoft Excel 2010 Course Beginners/ Intermediate Training

Udemy

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.

By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.



What Will I Learn?
  • 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.


Curriculum For This Course Expand All Collapse All 126 Lectures 09:16:27 + – Getting Started 8 Lectures 24:55 Working Files - Download These First 00:01

This Excel 2010 Training Course is just one of many courses that are created by InfinteSkills. More titles are visible on the InfiniteSkills Website. Click for More Information

0101 Overview Of Excel 2010 Preview 06:16 0102 The New File Menu In Excel 2010 Preview 05:09 0103 Exploring The Excel Workbook Preview 02:25 0104 What Will I Be Able To Do At The End Of This Course Preview 03:53 0105 Customizing The Quick Access Toolbar Preview 02:52 0106 Working With The Ribbons Preview 03:46 0107 Using The Files Included With This Course 00:33 + – Working With An Excel Worksheet 5 Lectures 14:07 0201 Creating A New Workbook Preview 01:36 0202 Saving A Workbook Preview 02:25 0203 Saving In Other Formats 03:04 0204 Open A Existing Workbook 01:45 0205 Navigating An Excel Workbook 05:17 + – Selecting and Entering Data 13 Lectures 58:32 0301 Entering Text And Numbers Preview 03:00 0302 Entering Numbers As Text Preview 03:47 0303 Inputting Dates And Times Preview 04:03 0304 Editing The Contents Of A Cell Preview 02:08 0305 Using Copy And Paste Preview 06:47 0306 The FILL Handle 07:05 0307 Using Undo And Redo 03:03 0308 Shortcuts For Selecting Cells 05:12 0309 Inserting Cells , Columns And Rows 05:17 0310 Deleting Cells , Columns And Rows 03:21 0311 Changing Column Widths And Row Heights 04:06 0312 Hiding And Unhiding A Column Or Row 05:09 0313 Searching For Values In A Worksheet Preview 05:34 + – Developing A Workbook 6 Lectures 21:56 0401 Formatting And Naming Of Worksheet Tabs 03:41 0402 Moving Worksheets Within And Between Workbooks 04:49 0403 Copying Worksheets Within Workbooks 03:17 0404 Inserting And Deleting Worksheets 03:33 0405 Viewing More Than One Workbook 04:34 0406 Hiding And Unhiding Worksheets 02:02 + – Printing and Page Setup 9 Lectures 32:00 0501 Using The Print Area Command To Control What Excel Prints 04:03 0502 Setting Page Margins And Page Orientation 03:29 0503 Creating A Header And Footer 04:48 0504 Using Page Break View 02:55 0505 Setting Print Titles For Large Worksheets 03:01 0506 Printing Gridlines Column Row Headings And Other Related Options 02:48 0507 Enabling The New Page Layout View 03:30 0508 Running The Spell Checker 03:23 0509 Print Preview And Printing The Whole Or Part Of The Worksheet 04:03 + – Workbook Formatting 9 Lectures 35:58 0601 Modifying Typeface , Font Size And Colors 06:12 0602 Merging Cells 02:45 0603 Applying Number Formats 04:04 0604 Aligning Cell Contents 02:02 0605 Changing The Text Direction In A Cell 03:38 0606 Adding Borders To Cells And Ranges 04:43 0607 Applying A Date Format To A Cell Or Range 05:15 0608 Use Of The Format Painter 04:29 0609 Clearing Cell Contents And : Or Formatting 02:50 + – Carrying Out Calculations 17 Lectures 01:25:12 0701 Getting Started With Basic Math Formula Addition 05:23 0702 Getting Started With Basic Math Formula Subtraction 03:20 0703 Getting Started With Basic Math Formula Multiplication 02:45 0704 Getting Started With Basic Math Formula Division 04:22 0705 Getting Started With Basic Math Formula Operand 02:36 0706 Order Of Operations With BODMAS 03:14 0707 Introduction To Excel Formulas SUM 07:46 0708 Copying Formulas And Functions 06:55 0709 Displaying Formulae On A Worksheet 02:59 0710 Some Useful Functions For Counting 04:06 0711 Some Useful Functions For Averages 04:02 0712 Some Useful Functions For Highest And Lowest 03:15 0713 Absolute Referencing Requirements 05:37 0714 Formulas Across Worksheets 07:46 0715 Functions Across
Сессии:
  • Свободный график
Характеристики онлайн курса:
  • Бесплатный:
  • Платный:
  • Сертификат:
  • MOOC:
  • Видеолекции:
  • Аудиолекции:
  • Email-курс:
  • Язык: Английский Gb

Отзывы

Пока никто не написал отзыв по этому курсу. Хотите быть первым?

Зарегистрируйтесь, чтобы оставить отзыв

Show?id=n3eliycplgk&bids=695438
Входит в подборки курсов:
NVIDIA
Ещё курсы на эту тему:
116248_5368_6 Microsoft Outlook v 2013 for Lawyers Training Tutorial
This Outlook tutorial is specifically designed for those who practice law.
23400_00f2_6 Fast Track to Microsoft Excel Beginner + Advanced Training by EVold
MASTER EXCEL in HOURs instead of weeks. Beginner And Advanced Excel Training...
103052_ae95_10 Mastering Microsoft Excel - Charts In Detail
Learn how to create dynamic and interactive charts in Excel. Turn your data...
116244_be91_6 Mastering Microsoft Word 2013 for Lawyers Training Tutorial
This Microsoft Word tutorial is specifically designed for those who practice...
Ещё от Udemy:
Show?id=n3eliycplgk&bids=323058 Thousands of online courses for only $15
Most courses are dropped to $15 flat price!
Banner_ruby Ruby on Rails Tutorial: Learn From Scratch
This post is part of our “Getting Started” series of free text tutorials on...
Show?id=n3eliycplgk&bids=323058 $10 Sitewide Deal
$10 Fixed Price across the site!
64422_c6dd_6 1 Hour HTML
Learn how to code in HTML in 1 hour. This class is set up for complete beginners...
72262_60dc_6 1 hour jQuery
Have you ever wanted to learn to code. This course will show you the basics...

© 2013-2019