Posts Tagged ‘howto’
Monday, April 23rd, 2012
Excel If Function in VBA code. This VBA Function does exactly what the Excel If Function does.
Code:
Function ifCode(s1 As String, s2 As Variant, s3 As Variant)
tst = Evaluate(s1)
If tst = True Then
ifCode = s2
Else
ifCode = s3
End If
End Function
Duration : 0:4:24
(more…)
Technorati Tags: else, excel, for, functions, how, howto, IF, next, range, then, to, tutorial, Variable, vba
Tags: else, excel, for, functions, how, howto, IF, next, range, then, to, tutorial, Variable, vba
Posted in Learn Excel Macros | No Comments »
Monday, April 23rd, 2012
This Tutorial introduces String variables and how to concatenate strings together to form new strings.
Please Click on my channel to see all my tutorials and subscribe to future tutorials!
Duration : 0:6:38
(more…)
Technorati Tags: computer, computers, Computing, discussion, electronics, excel, financial, howto, laptops, Macro, maker, programing, programs, software, string, strings, technology, tutorial, Variables, vba, visual basic, windows
Tags: computer, computers, Computing, discussion, electronics, excel, financial, howto, laptops, Macro, maker, programing, programs, software, string, strings, technology, tutorial, Variables, vba, visual basic, windows
Posted in Learn Excel Macros | 2 Comments »
Sunday, February 5th, 2012
An introduction to variables and how to use them in calculations.
Also introduces the “With” keyword
Duration : 0:9:37
(more…)
Technorati Tags: begginer, cheats, computers, Computing, crafts, discussion, downloads, electronics, excel, financial, howto, increment, instruction, integer, Macro, management, programming, programs, self help, software, technology, tips, tutorial, Variables, vba, visual basic, with
Tags: begginer, cheats, computers, Computing, crafts, discussion, downloads, electronics, excel, financial, howto, increment, instruction, integer, Macro, management, programming, programs, self help, software, technology, tips, tutorial, Variables, vba, visual basic, with
Posted in Learn Excel Macros | 4 Comments »
Saturday, January 7th, 2012
Excel Formulas Urdu Tutorials – Part 7 – by Irfan Wazir Ali
Duration : 0:8:39
(more…)
Technorati Tags: Ali, analysis, by, cellphones, commentary, computers, defense, diy, downloads, Educational, electronics, excel, formulas, gaming, hacking, hacks, home video, howto, instructions, Irfan, laptops, Part, programs, repair, smart phones, software, technology, tips & tricks, trailer, tutorial, tutorials, unboxing, Urdu, video game, vlog, Wazir
Tags: Ali, analysis, by, cellphones, commentary, computers, defense, diy, downloads, Educational, electronics, excel, formulas, gaming, hacking, hacks, home video, howto, instructions, Irfan, laptops, Part, programs, repair, smart phones, software, technology, tips & tricks, trailer, tutorial, tutorials, unboxing, Urdu, video game, vlog, Wazir
Posted in Learn Excel Formulas | 2 Comments »
Saturday, December 31st, 2011
Intro to Excel VBA this is a quick video that explains the most commonly used code for Ranges in Excel. We name a range and copy a range to another location. We also show how to copy a selected range
Duration : 0:4:14
(more…)
Technorati Tags: a1, Copy, excel, howto, lesson, range, select, tutorial, vba
Tags: a1, Copy, excel, howto, lesson, range, select, tutorial, vba
Posted in Learn Excel Macros | No Comments »
Saturday, December 31st, 2011
Excel Formulas Urdu Tutorials – Part 3 – by Irfan Wazir Ali
Duration : 0:14:0
(more…)
Technorati Tags: Ali, analysis, by, cellphones, commentary, computers, creature, cybersecurity, defense, diy, downloads, economy, Educational, electronics, environment, excel, finance, financial, formulas, hacking, hacks, howto, instructions, Irfan, medicine, Money, music charts, Part, programs, repair, smart phones, software, technology, tutorial, tutorials, Urdu, video game, vlog, Wazir
Tags: Ali, analysis, by, cellphones, commentary, computers, creature, cybersecurity, defense, diy, downloads, economy, Educational, electronics, environment, excel, finance, financial, formulas, hacking, hacks, howto, instructions, Irfan, medicine, Money, music charts, Part, programs, repair, smart phones, software, technology, tutorial, tutorials, Urdu, video game, vlog, Wazir
Posted in Learn Excel Formulas | 5 Comments »
Thursday, December 22nd, 2011
This tutorial is a brief overview of Microsoft Excel and a few of its basic functionalities. This video is intended for people that know a little about computers but are just trying to get their hands into Excel or any other spreadsheet creation software. I hope it helps.
Duration : 0:8:48
(more…)
Technorati Tags: Advanced, advice, Basic, Basics, beginner, Beginners, business, easy, Free, Help, hints, howto, ideas, information, instruction, learn, Lessons, management, mobile device, need, need help, needs, please, please help, Quick, secrets, software, Software Tutorial, techniques, tips, tricks, tutorial, use, your
Tags: Advanced, advice, Basic, Basics, beginner, Beginners, business, easy, Free, Help, hints, howto, ideas, information, instruction, learn, Lessons, management, mobile device, need, need help, needs, please, please help, Quick, secrets, software, Software Tutorial, techniques, tips, tricks, tutorial, use, your
Posted in Learn Basic Excel | 2 Comments »
Saturday, December 17th, 2011
In this video I explain the basics of what a macro is and how you can get started making (recording) them. Later on I will probably make a more advanced tutorial that will explain and demonstrate more advanced uses of macros.
Thanks for watching!
Comment, rate, subscribe!
Follow me on Twitter! @jn_lord
https://twitter.com/#!/jn_lord
Duration : 0:5:17
(more…)
Technorati Tags: 2007, Basic, beginner, computers, excel, Help, howto, Macro, Microsoft, Record, software, technology, tips, tutorial, video, workbook
Tags: 2007, Basic, beginner, computers, excel, Help, howto, Macro, Microsoft, Record, software, technology, tips, tutorial, video, workbook
Posted in Learn Excel Macros | No Comments »
Sunday, November 27th, 2011
This video shows how to link data from different sheets and even different workbooks in Excel. It shows the linking notation and how to go about linking without having to write the cell reference by hand. It also shows a very neat way reference a cell across different sheets.
Duration : 0:6:45
(more…)
Technorati Tags: computers, excel, formula, formulas, Guide, howto, technology, tutorial
Tags: computers, excel, formula, formulas, Guide, howto, technology, tutorial
Posted in Learn Excel Formulas | No Comments »
Thursday, November 17th, 2011
Free articles on learning Excel. Visit http://www.launchexcel.com/
Sumif, Countif and Averageif help you to analyse data in a list that matches the conditions you specify. Named ranges make it simpler to read formulas and easily enter large ranges. Together they make a simple and powerful combination in Excel. For more information see http://www.launchexcel.com/formula-basics-sum-count-average-if
Highlights in the video:
0:58 – Named range tricks (Ctrl + F3 to bring up name manager, Ctrl + Shift + F3 to create named range from selection)
1:52 – Create unique list of names (using Excel’s Remove duplicates feature, available in Excel 2007+)
2:30 – Set up data validation drop down list, sourced from a defined named range
3:35 – SUMIF() formula (total lifetime sales)
4:21 – COUNTIF() formula (number of months with sales)
5:04 – AVERAGEIF() formulas (average monthly sales)
5:49 – Using drop down list to select new sales person, formulas automatically recalculate
You can discover more Excel tips and tricks to make you productive in Excel by visiting my website at http://www.launchexcel.com
Duration : 0:6:22
(more…)
Technorati Tags: AVERAGEIF, computers, COUNTIF, create name from selection, Educational, excel, Excel 2010, Fast, formula, formulas, functions, howto, instructions, map, mind, name manager, named range, Quick, remove duplicates, Software Tutorial, summit, tip, tips & tricks, tutorial
Tags: AVERAGEIF, computers, COUNTIF, create name from selection, Educational, excel, Excel 2010, Fast, formula, formulas, functions, howto, instructions, map, mind, name manager, named range, Quick, remove duplicates, Software Tutorial, summit, tip, tips & tricks, tutorial
Posted in Learn Excel Formulas | No Comments »
Excel Formulas Urdu Tutorials – Part 7 – by Irfan Wazir Ali
Saturday, January 7th, 2012Duration : 0:8:39
(more…)
Technorati Tags: Ali, analysis, by, cellphones, commentary, computers, defense, diy, downloads, Educational, electronics, excel, formulas, gaming, hacking, hacks, home video, howto, instructions, Irfan, laptops, Part, programs, repair, smart phones, software, technology, tips & tricks, trailer, tutorial, tutorials, unboxing, Urdu, video game, vlog, Wazir
Tags: Ali, analysis, by, cellphones, commentary, computers, defense, diy, downloads, Educational, electronics, excel, formulas, gaming, hacking, hacks, home video, howto, instructions, Irfan, laptops, Part, programs, repair, smart phones, software, technology, tips & tricks, trailer, tutorial, tutorials, unboxing, Urdu, video game, vlog, Wazir
Posted in Learn Excel Formulas | 2 Comments »