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.
Excel Basics #3: Formulas w Cell References The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #3 Video topics: 1)Formulas 2)Equal sign = 3)Ampersand & 4)Formulas with Mouse 5)Formulas with Arrow Keys 6)Formulas with cell references 7)Relative Cell References 8)Change input numbers in cells and see resulting formulas update instantly (Bricklin and Frankston VisiCalc) 9)Copy formulas 10)Calculating number result formulas 11)Text formulas 12)Fill handle (Angry Rabbit) and quick formula copy 13)Join cell content and text (using quotes) in text formula using the ampersand &
Excel Magic Tricks # 1: Formulas & Cell References See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references!
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?
Advanced Excel: How to Create a Drop Down Box in a Cell Learn how to create a drop down box in a worksheet cell using the Data Validation function. If you would like to learn more about Microsoft Excel visit our website - /learnexcel.asp
Microsoft Excel Tutorial for Beginners #1 - Overview 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.
Microsoft Excel 2010 Microsoft Excel 2010 can help you ***yze data, create effective visualizations and share data with a team. Save time by using templates, and new tools to quickly and intuitively ***yze 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
VLOOKUP in Excel 2007 Several examples of using the VLOOKUP function in Excel 2007
Excel 2007 - Creating a Chart 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.
Recording Macros - Excel 2003 How to record a macro in Excel 2003. How to add a button to worksheet to run macro.
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)
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.
Making a Gantt Chart in Excel 2007 Using Excel 2007 to create a Gantt chart--a popular project management tool
Building a Pivot Table in Excel 2007 - This screencast from Matthew MacDonald, author of Excel 2007: The Missing Manual, guides you through building and modifying a pivot table in Excel.
Microsoft Excel #04: Excel as a Database I use Excel as something of a simple database. I use it to keep track of movies, collectibles, etc. because I like the interface, the ease of organizing data, and the ability to filter data on-the-fly with AutoFilters and Sorts.
Normal Distribution Excel Exercise (Long-26 minutes) Presentation on spreadsheet to show that the normal distribution approximates the binomial distribution for a large number of trials.
Excel Lookup Series #2: VLOOKUP Function 2nd Example See how to use the VLOOKUP function to deliver a value to cell from the 3rd column of the table using the COLUMN function. Find exact value from column 2 and column 3 of lookup table using the COLUMN function. Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate. In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.
Excel Saga Opening
Excel Saga Complete Opening Complete version of Excel Saga Opening
Excel Dashboards excel- 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 .
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.
Payment Function in Excel use the payment function (pmt) to calculate monthly car payments and mortgage payments
Microsoft Excel Tutorial for Beginners #3 - Calculations Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel.
Import Excel to MySQL Database Take a Microsoft Excel Spreadsheet and import it into a MySQL Database using CSV files and PHPMyAdmin.
Histogram and Frequency Distribution in Excel This video shows students how to create a histogram and frequency distribution table in Excel
Microsoft Excel #03: Cartesian Coordinate & Venn Diagram I use Microsoft Excel to produce a Cartesian Coordinate Plane and a Venn Diagram.
Easy Way to Make a Graph on Excel FROM SCRATCH - Excel 2007 A fast and easy to follow tutorial on how to make a good looking graph on Microsoft Excel 2007. Example: Scatter plot With bullets and straight lines Line of Best Fit Graph Title Axis Titles Comment, rate, and SUBSCRIBE! ^ ^ ^ ^ ^ | | | | | | | | | | -pH-
Excel Statistics 11: Descriptive & Inferential Statistics See Excel Charts for Cross-Sectional Data and Time Series data. Learn about the three types of Descriptive Statistics: Numerical, Tabula and Graphical. See the AVEARGE function, a percentage formula and a finished Histogram. Learn about Populations and Samples in regards to Inferential Statistics. This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin
Excel Lookup Series #1: VLOOKUP Function 1st Example See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from column 2 of lookup table. Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate. In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel. Excel Magic Trick 167p2 IF function formula: 12 Examples! Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel 2007 Demo: Get up to speed See more Excel 2007 demos at 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.
Microsoft Excel Tutorial for Beginners #2 - Get Started 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.
Microsoft Excel VLOOKUP Tutorial Learn how to look up values in Microsoft Excel using the VLOOKUP function
Microsoft Excel Tutorial for Beginners #4 - Functions 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!
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 ***ysis 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
Excel Trick Easily compare numbers in Microsoft Excel.
Mr Excel & excelisfun Trick 78: Extract Top Two Customers In Each Industry with Formula (2 Examples) See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, SMALL, LARGE, ROW functions.
25 Years of Excel-lence We've come a long, long way since Excel 1.0. Check out the journey! Join the conversation on our Facebook page and share your favorite Excel memory for a chance to win a Xbox & Kinect package at
Drawing in Microsoft Excel You thought you saw everything... Think again GAT-X105 Strike Gundam from Gundam Seed Destiny Anime This is the first drawing on Youtube done with Microsoft Excel exclusively (Autoshape can be used to do lineart, colors, shadows, lighting effects and layers, like some drawing softwares). Just for fun. Real length: 12 hours 56 minutes Suscribe, rate and comment Very special thanks to: Valentina (Gracias por la paciencia T_T) Patolín (Saludos a la distancia compadre =D) And you
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.
excel practice test Practice Test for excel file at venus.cs.qc.cuny.edu
(HD) Pivot Tables (PivotTable) in Excel 2007 (including compatibility mode) and 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.
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.