Реклама - двигатель прогресса


<< | 1 | >>

Microsoft excel tutorial for beginners #1 - overview

Visit MotionTraining at www.motiontrainingweb.com A quick look at setting up a simple spreadsheet in Excel complete with a chart. More tutorials to follow that will go into more detail on how to use the different features of MS Excel. Category: Howto & Style Length: 00:06:53.250 Tags: .

 

---

Excel basics #1: what is excel?

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #1 Video topics: 1)What is Excel? Calculating formulas and Data Analysis 2)Rows, Columns, Cells, Worksheets, Sheet Tab Names, Workbook 3)File extensions (file types): .xlsx, .xlsm, .xls, .xlsb 4)Excel 2007 Ribbons 5)Excel 2007 Quick Access Tool Bar (QAT) 6)How to find features in Excel 2007 7)How to add buttons to the QAT Quick Access Toolbar Excel Tutorial Excel How To Excel Lessons Learn Excel Beginning Excel Excel Basics Category: Science & Technology Length: 00:07:57 Tags: .

 

---

Microsoft excel 2010

Microsoft Excel 2010 can help you analyze data, create effective visualizations and share data with a team. Save time by using templates, and new tools to quickly and intuitively analyze your data. This quick tutorial will help you learn these new tools. Find Excel on Facebook for support, tips and the latest news: on.fb.me Category: Science & Technology Length: 00:02:28.500 Tags: Business .

 

---

Excel magic trick 905: add 1 to every number greater than 20, if function, paste special values

Download workbook: people.highline.edu See how to add 1 to every number in a column that is greater than 20 using the IF Function and paste Special Values Select Cells Not Next To Each Other (Noncontiguous), Hold Ctrl Key While Clicking Category: Education Length: 00:01:40.500 Tags: .

 

---

Microsoft excel #01: introduction to excel

This is my first in a series of tutorials for Microsoft Excel. This will introduce some of the basic concepts and then demonstrate a couple practical uses. Category: Howto & Style Length: 00:05:14.250 Tags: .

 

---

Excel magic trick 896: conditional formatting formula: entire row red if sum greater than 45

Download workbook: people.highline.edu See how to use a logical TRUE FALSE Formula with comparative operators to conditionally format a row when the sum in the row is greater than 45. See Mixed Cell References in Logical Formula Category: Education Length: 00:03:09 Tags: .

 

---

Excel magic trick 895: entered date must be greater or equal to any dates above data validation

Download workbook: people.highline.edu See how to use Data Validation and a logical TRUE FALSE formula to validate that Entered Dates Must Be Greater or Equal to Any Dates Above. See the MAX Function and how to type a Error message into Data Validation Box Category: Education Length: 00:02:24.750 Tags: .

 

---

Mr excel & excelisfun trick 103: find missing numbers in a series

Download workbook: people.highline.edu See Mr Excel and excelisfun use two formula methods to Find Missing Numbers In A Series: See Mr Excel use the functions IF, ISNA, VLOOKUP, ROW, and SMALL See excelisfun use the functions: MAX, INDIRECT, ROW, MATCH, ISNA, IF, SMALL, IFERROR Category: Education Length: 00:05:10.500 Tags: .

 

---

Excelisfunner & mr excel & excelisfun mr trick 104: truel with 5 year old exceler

Download workbook: people.highline.edu See 5 year old Isaac play around with Excel and the Mr Excel and excelisfun jump in too. Isaac has invented his own Excel name "Excelisfunner"; just like Bill Jelen gave himself the name "Mr Excel" and Mike Girvn gave himself the name "excelisfun"!!! Isaac build a table and chart to track baseball hits in last three Little League Baseball Games Category: Education Length: 00:04:45.750 Tags: .

 

---

Excel lookup picture approximate or exact match (excel vlookup week video #6)

Download workbook: people.highline.edu This video is a part of VLookup Week: vlookupweek.wordpress.com Excel Lookup picture 1. See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or Exact match lookup. 2. See formula inserted into picture for Excel 2010 and 2003. 3. See formula inserted into bitmap image for Excel 2007. Category: Education Length: 00:03:44.250 Tags: .

 

---

Microsoft excel tutorial for beginners #2 - get started

Visit MotionTraining at www.motiontrainingweb.com This video covers a number of basics including entering data, editing data, changing column widths and Autofill. I hope you find it useful. More tutorials to follow. Category: Howto & Style Length: 00:07:03.750 Tags: .

 

---

Excel magic trick 902: conditionally format to do list if date in row is today and item is done

Download workbook: people.highline.edu See how to use a logical formula uising Mixed Cell References, Comparative Operators, TODAY and AND Functions to format the row in a To Do List if the date is TODAY and the items has not been completed yet. Category: Education Length: 00:03:06 Tags: .

 

---

Excel magic trick 889: excel 2010 filter search: easy to "partial text"filter

Download workbook: people.highline.edu See the great new Excel 2010 Search Ability in Filter. Search for partial text to get your filter. Category: Education Length: 00:00:45.750 Tags: .

 

---

Excel magic trick 904: lookup group number and return names in group

Download workbook: people.highline.edu See how to Lookup Group Number and Return Names In Group using an array formula that lookup a single group number and return multiple names. See the Functions, INDEX, SMALL, IF, ROW, ROWS, IFERROR, AGGREGATE. Category: Education Length: 00:06:01.500 Tags: .

 

---

Microsoft excel #02: create a seating chart

Creating charts and diagrams may not be the first thing you think of when you use Excel, but I use it all the time. In this example I use Excel to create a seating chart for my computer lab. Category: Howto & Style Length: 00:06:19.500 Tags: .

 

---

Vlookup in excel 2007

Several examples of using the VLOOKUP function in Excel 2007 Category: Howto & Style Length: 00:07:22.500 Tags: .

 

---

Excel 2007 demo: get up to speed

See more Excel 2007 demos at office.microsoft.com Microsoft Office Excel 2007 has a new design that makes your work easier, faster, and more efficient. The new Ribbon puts the commands you use most often in plain sight on your work surface instead of hidden in menus or dialog boxes. Ready-made cell styles let you quickly format your worksheet to make it easier to read and interpret. The new Page Layout view shows how your printed worksheet will look as you're creating it. Category: Howto & Style Length: 00:05:11.250 Tags: .

 

---

Excel magic trick 907: excel calendar (4 examples)

Download workbook: people.highline.edu See how to create Dynamic Excel Calendar that changes based on a date types into a cell or the current date from the TODAY function using a non-array formula: 1. Excel Calendar using Formulas and Conditional Formatting for Excel 2003 based on date typed into cell 2. Excel Calendar using Formulas and Conditional Formatting for Excel 2007 or 2010 based on date typed into cell 3. Excel Calendar using Formulas based on date typed into cell 4. Excel Calendar using Defined Name Formulas based on TODAY function 5. See the functions: COLUMNS, ROWS, WEEKDAY, EOMONTH, MONTH and IF 6. All examples are non-array formulas. Category: Education Length: 00:12:09 Tags: .

 

---

Microsoft excel tutorial for beginners #3 - calculations (formulas)

Visit MotionTraining at www.motiontrainingweb.com Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel. Category: Howto & Style Length: 00:06:29.250 Tags: .

 

---

Microsoft excel vlookup tutorial

MORE INFO AT 599CD.com - Learn how to look up values in Microsoft Excel using the VLOOKUP function Category: Science & Technology Length: 00:05:05.250 Tags: .

 

---

Excel magic trick 909: paste special values

Download workbook: people.highline.edu See how to: Copy First, then Paste Special values 1 of 6 ways:: 1. Ribbon Method 2. Alt, E, S, V, Enter 3. Right-click Key, S, V, Enter 4. Right-click Edge of highlighted Range, Drag, Drag back, point to "Copy Here As Values Only" 5. F2, F9 6. Highlight, F9 Category: Education Length: 00:02:26.250 Tags: .

 

---

Excel 2007 - creating a chart

www.keystonelearning.com Follow the link above for a course outline, product details, and options for purchasing the full Excel 2007 course. KeyStone Learning Systems has Enterprise solutions for Companies, Government, and Education. www.keystonelearning.com Category: Education Length: 00:03:12 Tags: .

 

---

(hd) (cc) pivot tables (pivottable) in excel 2007 (including compatibility mode), basic pivotchart

This video shows how to create a PivotTable in Excel 2007. It covers the regular mode as well as compatibility mode (ie Excel 2003 .xls format). Microsoft has made it extremely intuitive to create PivotTables and PivotCharts in this version of Excel. Due to time constraints, a very basic PivotChart example was shown. A more detailed video will follow. Category: Education Length: 00:07:32.250 Tags: .

 

---

Making a gantt chart with excel

Use Excel to create a project management Gantt chart. An Excel 2007 version of this video is also in my channel. Category: Howto & Style Length: 00:04:51 Tags: project management .

 

---

Making a gantt chart in excel 2007

Using Excel 2007 to create a Gantt chart--a popular project management tool Category: Howto & Style Length: 00:05:15 Tags: project management .

 

---

Excel 2007 tutorial 1: intro

Introduction to Excel 2007 Category: Education Length: 00:03:57.750 Tags: .

 

---

Excel vba beginner tutorial - fundamentals

This tutorial goes through some VBA fundamentals such as how to get access to the developer toolbar and how to create a simple macro using the macro recorder. Category: Howto & Style Length: 00:04:02.250 Tags: .

 

---

Excel trick

Easily compare numbers in Microsoft Excel. Category: People & Blogs Length: 00:01:09 Tags: .

 

---

Microsoft excel tutorial for beginners #4 - functions (formulas)

Visit MotionTraining at www.motiontrainingweb.com Continuing the Microsoft Excel series of tutorials for beginners. In part 4 you will learn about creating basic functions in Excel and using the Paste Function feature. Hope you find this useful! Category: Howto & Style Length: 00:05:57.750 Tags: .

 

---

Payment function in excel

use the payment function (pmt) to calculate monthly car payments and mortgage payments Category: Howto & Style Length: 00:07:15 Tags: .

 

---

Excel spread sheet basics - using a formula

CHECK BELOW!!!! How to set up a very basic spread sheet. If you're really new to Excel, you might want to check out my REALLY BASIC video before this one, it has some valuable concepts that will help. www.youtube.com Category: Howto & Style Length: 00:07:06 Tags: .

 

---

Excel practice test

Practice Test for excel file at venus.cs.qc.cuny.edu Category: News & Politics Length: 00:25:19.500 Tags: test .

 

---

Microsoft excel tutorial for beginners #5 - number formats

Visit MotionTraining at www.motiontrainingweb.com Tutorial #5 shows how to do basic number formatting using the toolbar or menu options. The video also introduces the Format Painter and shows how to select non-adjacent cells. Category: Howto & Style Length: 00:07:22.500 Tags: .

 

---

Excel dashboards

excel-dashboards.org Excel Dashboard Reports - Excel is an excellent Dashboard Reporting solution. Quick, easy and ubiquitous, Excel makes for easy to use and distribute business dashboards. This video shows you the quickest and easiest Excel Dashboard Templates to set up and use. Free Excel Dashboard templates and a comprehensive guide to creating your own excel dashboard are available at budurl.com . Category: Science & Technology Length: 00:03:39.750 Tags: .

 

---

Vlookup function beginner to advanced 26 examples (excel vlookup week video #1)

Download workbook: people.highline.edu This video is a part of VLookup Week: vlookupweek.wordpress.com Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP. In this video learn everything you need to know about VLOOKUP in 1 video. Here are the topics (minute marks jump you to that part of the video) 1. VLOOKUP = V = Vertical ( min) 2. Why so common? Because everyone needs to look stuff up ( 00:43 min) 3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min) 4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min) 5. VLOOKUP and Data Validation ( 8:10 min) 6. VLOOKUP with Named Range ( 10:34 min) 7. VLOOKUP as Formula Element ( 17:24 min) 8. HLOOKUP = H = Horizontal ( 18:25 min) 9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min) 10. VLOOKUP with table on different sheet ( 24:00 min) 11. VLOOKUP with table in different workbook ( 25:56 min) 12. Show Full Record: Numbers above column header ( 27:15 min) 13. Show Full Record horizontally: COLUMNS Function ( 30:20 min) 14. Show Full Record vertically: ROWS Function ( 32:28 min) 15. Show Full Record: MATCH Functions ( 33:40 min) 16. Two Lookup Values: Add join column as first column in table ( 35:40 min) 17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min) 18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min) 19. Partial Text Lookup: MID Function ( 45:37 min) 20 ... Category: Education Length: 00:51:02.250 Tags: .

 

---

Easy way to make a graph on excel from scratch - excel 2007 or 2010

A fast and easy to follow tutorial on how to make a good looking graph on Microsoft Excel 2007 and 2010. Example: Scatter plot With bullets and straight lines Line of Best Fit Graph Title Axis Titles Comment, rate, and SUBSCRIBE! ^ ^ ^ ^ ^ | | | | | | | | | | -pH- Category: Howto & Style Length: 00:06:42 Tags: Software Tutorial .

 

---

Excel 2010 tutorial: creating a basic worksheet

Webucator is rolling out our instructor-led online Excel 2010 courses and this tutorial was created as part of the course development process. The Introduction to Excel 2010 class outline is under development and will soon be available at www.webucator.com Category: Education Length: 00:06:06.750 Tags: Class .

 

---

Building a pivot table in excel 2007

missingmanuals.com - This screencast from Matthew MacDonald, author of Excel 2007: The Missing Manual, guides you through building and modifying a pivot table in Excel. Category: Howto & Style Length: 00:05:42 Tags: .

 

---

Trueling excel 'almost live' - "create a chart": podcast #1540

No, we're not coining new words at 'The Learn Excel from MrExcel Podcast Blog, but someone somewhere is... Truel is truly a word [en.wikipedia.org But enough about that, lets look at this podcast! In a Three-way Duel between Mike 'ExcelisFun' Girvin, Bill 'MrExcel' Jelen and - 'ExcelisFunner'. In this 'Almost Live' podcast, Bill and Mike get schooled - in the rain, in an empty parking lot in Seattle... by a 5 year old Excel Wizard! Follow along with Episode #1540 to learn some basic Charting technique. Dueling Excel Podcast #103...Thisepisode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] www.mrexcel.com and "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! www.mrexcel.com "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today! Category: Howto & Style Length: 00:05:11.250 Tags: .

 

---

Learn excel 2010 - "sakai grade book sum when not blank - part iii of iv": podcast #1543

Still working with the CSV Data from the Sakai Grade Book, Bill looks at Calculating the Total Possible Points from Non-Blank Cells. Do you need just the percentage scoring? Cannot figure out why your figures are so far off from the Sakai Total? In Episode #1543, Bill examines why this is happening and what you can do to quickly and effectively correct that issue. 'Livening' up your Grade Book. This is Part III of IV. Formulas for the 'Grade Book Application' that Bill Jelen has created are from the book, "Excel For Teachers" [ www.mrexcel.com ] published by Holy Macro! Books. Learn more about the book "Excel For Teachers" by clicking here [ www.mrexcel.com ] to go to the "Excel For Teachers" information page. ...Thisblog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! www.mrexcel.com "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs! Category: Howto & Style Length: 00:02:33 Tags: .

 

---

Drop down list in excel

www.contextures.com Select from a drop down list on the Excel worksheet. Details at www.contextures.com Category: Science & Technology Length: 00:01:28.500 Tags: .

 

---

The website is down #2: excel hell

The Website is Down episode number two! Chip takes us on a wild ride into the life of a master salesman. How many sales can he make in a single video? One? Maybe? Category: Entertainment Length: 00:06:41.250 Tags: .

 

---

Microsoft excel tutorial for beginners #6 - formatting pt.1

This is the first of 2 videos looking at formatting. Effective formatting will add a professional look to your spreadsheets. In this video learn how to modify text and add colours to your spreadsheet. Category: Howto & Style Length: 00:07:17.250 Tags: .

 

---

Excel 2007: use simple formulas to do the math

See more Excel 2007 demos at office.microsoft.com You can use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later. Category: Science & Technology Length: 00:05:39.750 Tags: .

 

---

Microsoft excel tutorial for beginners #7 - formatting pt.2

The guide to Excel formatting continues with a look at changing text colour, border styles, print preview and an introduction to Conditional Formatting. Category: Howto & Style Length: 00:07:15.750 Tags: .

 

---

Graphing with excel

How to use Excel to make a line graph, an xy graph, a bar graph or a pie chart. About my voice - I know it sounds weird. It's a microphone issue - everyone who knows me says it sounds nasally and not like me. If I put the mic farther away my voice sounds fine but then it is echoey. Some day I'll get something better than this $20 headset mic. Category: Education Length: 00:05:43.500 Tags: .

 

---

Finance in excel 1 - live stock quotes in microsoft excel - msn moneycentral investor stock quotes

Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to view Live Stock Quotes in Microsoft Excel. This tutorial shows you how to view stock quotes through Excel and how to automatically update those stock quotes. This tutorial will show you how to view and therefore better manage your portfolio through Excel. This is a great tutorial for anyone who owns stocks and would like to view how their stocks are doing through Excel. This tutorial shows you how to view stock quotes through the MSN MoneyCentral Investor Stock Quotes existing connection in Excel 2007. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day! Category: Education Length: 00:03:30 Tags: .

 

---

Microsoft excel tutorial for beginners #8 - formatting pt.3

Visit MotionTraining at www.motiontrainingweb.com Learn how to combine conditional formatting with Excel functions. Category: Howto & Style Length: 00:04:44.250 Tags: .

 

---

Excel basics #2: keyboard shortcuts

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #2 Video topics: 1)Ctrl + C = Copy 2)Ctrl + V = Paste 3)Ctrl + X = Cut 4)Excel 2007 Screen Tips with keyboard shortcuts 5)Ctrl + F2 = Print Preview 6)How to Discover all the Alt keyboard shortcuts (Excel 2003 and 2007) 7)Excel 2003 Alt + F + U = Page Setup 8)Excel 2007 Alt P + S + P = Page Setup 9)Ctrl + Arrows keys = Move to end of current region 10)Ctrl + Home = select cell A1 11)Ctrl + Roller-ball-on-mouse = Zoom 12)Atl + = is the keyboard for Auto SUM 13)Shift + Click selects range between to cells 14)Ctrl + Shift + arrow = Select whole current region (This trick is the best Excl keyboard shortcut) Category: Science & Technology Length: 00:07:27.750 Tags: .

 

---

Excel basics #4: formulas and functions

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #4 Video topics: 1)Formulas with cell references 2)Formula efficiency rule: Numbers that can change go in cells and numbers that do not change can be typed into cells 3)Formulas with cell references operators and parenthesis 4)Formula for Effective Annual Interest Rate 5)How to find Excel functions to use in formulas 6)Search for Excel functions 7)EFFECT function 8)Formula for month interest rate 9)Formula for total number of periods 10)Formula for monthly payment on a loan using the PMT function 11)Formula for text string that use cell references, Text in quotes and the DOLLAR function Category: Science & Technology Length: 00:07:39.750 Tags: .

 

---

<< | 1 | >>