www.jeffersoncosta.com.br
Essa é uma vídeo aula de Microsoft Excel Avançado 2010.
O objetivo aqui é ensinar macros / botões / guias de forma simples.
twitter: ProfJcosta
Duration : 0:4:21
Posts Tagged ‘office’
Excel (Macros / Botões / Guias) – www.jeffersoncosta.com.br
Monday, April 23rd, 2012Excel VBA tutorial 28 GetSaveAsFilename.flv
Monday, April 23rd, 2012
How to open up a saveas dialog boxExcel VBA tutorial 15 Do Until loops and finding the end of data.flv
Monday, April 23rd, 2012
Do until loops and copying data from one sheet to another. How to Use Excel Functions & Formulas to Analyze Inventory for a Retail Store
Monday, April 23rd, 2012
Continuing in my series of Excel Tutorials for analyzing the year-end inventory of I retail store, I demonstrate how to use Excel Functions and Formulas.
In this case, using just three “hard coded” numbers (Sales, Cost of Goods Sold and Average Inventory), we create six formulas: Gross Profit $, Gross Profit %, Inventory “turns” per period, Products as a % of Sales, Inventory (by product) as a % of total inventory, GMROI (Gross Margin Return on Investment)
As a bonus, I demonstrate several ways to quickly – and accurately enter your Excel formulas.
I invite you to visit my secure online shopping webiste – http://shop.thecompanyrocks.com – to preview all of the resources tht I offer to you.
Danny Rocks
The Company Rocks
Duration : 0:16:8
How to Apply Named Cell Ranges to Existing Excel Formulas
Monday, April 23rd, 2012
I am a proponent of creating Named Cell Ranges and then using them in your Excel Formulas. However, what if you have existing formulas that use cell references and NOW you wish to create and apply Named Cell Ranges?
In this tutorial, I first demonstrate two methods for creating Named Cell Ranges. Next, I walk you through the process of substituting a Named Cell Range for existing cell references in your formulas and functions.
I invite you to visit my secure, online shopping website – http://shop.thecompanyrocks.com – to preview all of the resources that I offer you.
Danny Rocks
The Company Rocks
Duration : 0:10:43
How to Create Named Ranges to Use in Excel Formulas
Saturday, March 3rd, 2012
In my opinion, there are three main reasons to use Named Ranges in Excel Formulas:
1) They are easier to write – especially when range of cells is large
2) They are easier to remember – e.g. Gross Profit = Sales minus Costs
3) They are easier to explain to others – see example for point #2
In this lesson, I demonstrate two ways to create a Named Range. The first is to use the “Name Box” in all versions of Excel. The second is to Create a Named Range from Selection.
In my next lesson, I will show you how to modify named ranges and also how to apply named ranges to existing formulas.
Please visit my secure online shopping website – http://shop.thecompanyrocks.com – to preview all of the resources that I offer.
Danny Rocks
The Company Rocks
Duration : 0:13:8
How to Use Criteria in Excel Filters and Functions
Thursday, February 9th, 2012
In this tutorial, I demonstrate how to use the “Logical Functions” of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Function, each logical test must answer TRUE.
I frequently “Nest” the AND Function inside an IF Function and I demonstrate how this works.
I also share my “Best Practice” tips for using the Advanced Filter tool in Excel. The key to success is know how to use AND criteria and OR criteria.
I invite you to visit my website – www.thecompanyrocks.com – to view all of my videos and to sample the many resources that I offer.
Danny Rocks
The Company Rocks
Duration : 0:11:13
Excel VBA tutorial 30 Userforms Pictures and RGB Values.flv
Thursday, February 2nd, 2012
Excel VBA tutorial 30 Userforms Pictures and RGB ValuesHow to Use the VLOOKUP Function in Excel
Thursday, January 19th, 2012
I receive numerous questions about how to use the VLOOKUP Function in Excel. So, I created this video to show you the step-by-step process to create them and to share my best practices for using VLOOKUPs.
I invite you to visit my online shopping website – http://shop.thecompanyrocks.com – to view all of my videos and resources. You can also order your copy of my DVD, “The 50 Best Tips for Excel 2007″ using my secure shopping cart at http://store.thecompanyrocks.com
I welcome your feedback.
Danny Rocks
The Company Rocks
Duration : 0:5:37
(Change Sheet Background)