Posts Tagged ‘spreadsheet’
Friday, March 23rd, 2012
The Basics of Excel Charting: Part IV
This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we’d set up our Data Set, Created our Chart and made adjustments to our Chart Axis. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data.
…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010″, by Bill Jelen a.k.a. MrExcel.
For more Excel 2010 knowledge, check out “Excel 2010 In Depth”, by Bill Jelen a.k.a. MrExcel.
For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.
Duration : 0:3:17
(more…)
Technorati Tags: accounting, Bill Jelen, business, charting, charts, excel, Excel2010, Learn Excel, MrExcel, spreadsheet, technology, tutorial, workbook
Tags: accounting, Bill Jelen, business, charting, charts, excel, Excel2010, Learn Excel, MrExcel, spreadsheet, technology, tutorial, workbook
Posted in Learn Basic Excel | 2 Comments »
Sunday, February 26th, 2012
This video provides most commonly used lookup reference functions in Microsoft Excel. I’m touching on vlookup, hlookup, match, and index functions. You can follow along with a free downloadable workbook at my website at www.excelroutineworks.com
Thanks and have a great day!
Duration : 0:7:29
(more…)
Technorati Tags: excel, Excel Tutorial, functions, spreadsheet, Templates
Tags: excel, Excel Tutorial, functions, spreadsheet, Templates
Posted in Learn Excel Formulas | 2 Comments »
Thursday, January 26th, 2012
Visit MotionTraining at http://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.
Duration : 0:9:25
(more…)
Technorati Tags: Beginners, excel, Guide, Help, Microsoft, Microsoft Excel, ms, software, spreadsheet, technology, tips, tricks, tutorial
Tags: Beginners, excel, Guide, Help, Microsoft, Microsoft Excel, ms, software, spreadsheet, technology, tips, tricks, tutorial
Posted in Learn Basic Excel | 24 Comments »
Thursday, December 15th, 2011
Watch the full course at http://SimonSezIT.com.
Website: http://SimonsezIT.com
Facebook: http://www.facebook.com/SimonSezIT
Twitter: http://twitter.com/SimonsezIT
Duration : 0:5:40
(more…)
Technorati Tags: 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet
Tags: 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet
Posted in Learn Excel Formulas | 6 Comments »
Saturday, November 26th, 2011
I am available for consulting. Call 510-473-2492 10 am to 10 pm Pacific time or eMail via YouTube for more details. This example uses MS Access to launch Excel, create a workbook, add worksheets, format worksheets, write data and add charts to graph the data.
Duration : 0:2:30
(more…)
Technorati Tags: 2000, 2007, Access, analysis, automation, call, Center, Chart, charting, charts, data, database, DB, excel, Microsoft, ms, office, OLE, spreadsheet, trending, vba, xp
Tags: 2000, 2007, Access, analysis, automation, call, Center, Chart, charting, charts, data, database, DB, excel, Microsoft, ms, office, OLE, spreadsheet, trending, vba, xp
Posted in Learn Excel Macros | 6 Comments »
Wednesday, November 16th, 2011
Visit MotionTraining at http://www.motiontrainingweb.com
A look at the Repeat (REPT) function in Microsoft Excel. This tutorial waa made with Excel 2000 but it works just the same in Excel 2003 & 2007 versions. Hope you find it useful!
Duration : 0:6:42
(more…)
Technorati Tags: data, Educational, excel, function, Guide, Help, howto, instructions, Microsoft, ms, Repeat, REPT, software, spreadsheet, technology, tips, tricks, tutorial
Tags: data, Educational, excel, function, Guide, Help, howto, instructions, Microsoft, ms, Repeat, REPT, software, spreadsheet, technology, tips, tricks, tutorial
Posted in Learn Excel Formulas | 21 Comments »
Monday, October 31st, 2011
Visit MotionTraining at http://www.motiontrainingweb.com
Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel.
Duration : 0:8:39
(more…)
Technorati Tags: Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, tips, tricks, tutorial
Tags: Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, tips, tricks, tutorial
Posted in Learn Excel Formulas | 25 Comments »
Friday, September 9th, 2011
http://www.infiniteskills.com/training/advanced_microsoft_excel_2010_training.html In this video based course expert author Guy Vaccaro shows you the techniques to take your Excel skills to the next level. This tutorial video covers the Using HLOOKUP . If you would like to all the Advanced Excel lessons in far higher detail, visit our website.
Duration : 0:3:14
(more…)
Technorati Tags: excel, Microsoft, spreadsheet, vba
Tags: excel, Microsoft, spreadsheet, vba
Posted in Learn Excel Formulas | No Comments »
Sunday, July 31st, 2011
This is the channel teaches the excel in tamil.
In this video
You could learn how to make marklist along with these function include
SUM, AVERAGE, RANK.
Duration : 0:7:57
(more…)
Technorati Tags: AVERAGE, channel, excel, in, inside, make, marklist, Names, Rank, spreadsheet, SUM, tamil, Total, ultimate
Tags: AVERAGE, channel, excel, in, inside, make, marklist, Names, Rank, spreadsheet, SUM, tamil, Total, ultimate
Posted in Learn Basic Excel | No Comments »
Friday, July 1st, 2011
After a while of using spreadsheets you get to a point where you need better control on how data is being presented to the end user. Quite often this requires you to make “interpretations” of the data to provide an outcome suitable to the business at hand. Well this is where (not always!) the IF function comes into play.
The purpose of the IF function is to allow you to control how data is displayed or derive a formula based on set values within the sheet. This video will explain how an if statement works and how you can control the results being returned. If functions are common place in spreadsheets so it is a key skill you will need to understand if your using spreadsheets day to day in your job.
Following this video we will focus on the dreaded “Nested If”, this can be straight forward or ridiculouslycomplex! This will be covered on a subsequent Video and other better ways of performing evaluations on values…
Duration : 0:11:17
(more…)
Technorati Tags: excel, formula, formulas, function, functions, IF, Microsoft, office, spreadsheet, spreadsheets
Tags: excel, formula, formulas, function, functions, IF, Microsoft, office, spreadsheet, spreadsheets
Posted in Learn Excel Formulas | 3 Comments »
