Video (22)

• 

  Formatting data as tables in Excel

  pubblicato 9 mesi fa

  2:21 | 10 visualizzazioni

  When you format your data in Excel as a table, you can work independently on the data without caring for the other Excel worksheet cells. You can add or delete records. You can even add a new header item or perform calculations in the table.

• 

  How to run multiple macros on an Excel worksheet

  pubblicato 10 mesi fa

  2:50 | 62 visualizzazioni

  We have created two interesting macros in Excel to insert a row and input data using the InputBox and offset properties.

• 

  If function in Excel

  pubblicato 10 mesi fa

  1:17 | 87 visualizzazioni

  The 'if' function is one of the most versatile functions in programming and therefore it is but natural that it plays an important role also in Excel macros or vba programming. Using this function you can perform many different manipulations...

• 

  Creating and saving an excel 2007 document with macro

  pubblicato 11 mesi fa

  2:41 | 103 visualizzazioni

  The Excel 2007 interface has changed considerably. Many people are finding it difficult to work in Excel 2007. This video shows how to create and save a file in Excel 2007 with an embedded macro.

• 

  How to write a 'do while... loop' macro in Excel 2007

  pubblicato 11 mesi fa

  1:14 | 275 visualizzazioni

  Writing a 'do while... loop' is easy in Visual Basic for Applications using the Visual Basic Editor provided with Microsoft Excel 2007. This macro automates the calculations in an Excel worksheet.

• 

  How to perform calculations in Excel 2007 using macros

  pubblicato 11 mesi fa

  1:40 | 94 visualizzazioni

  After understanding how to use 'range' and 'cells' properties to access cells, let's see how a macro is created in Excel 2007 to perform additions and multiplications.

• 

  Using 'cells' property to access Excel worksheet cells

  pubblicato 11 mesi fa

  2:56 | 62 visualizzazioni

  Another interesting method to access cells when writing VBA macro code in the Visual Basic Editor. Accessing cells using the 'cells' property has major advantages when using 'do while' and 'for... next' loops.

• 

  How to access cells in Excel using VBA code with the range property.

  pubblicato 11 mesi fa

  2:56 | 234 visualizzazioni

  When you enter data using a macro, you need to access cells using VBA code. The 'range' property is an easy way to enter numerical as well text data into cells. Text data is defined by using quotes around the text. Numerical values are...

• 

  How to create your first macro in Excel 2007

  pubblicato 11 mesi fa

  2:30 | 299 visualizzazioni

  Macros are written in a programming language called Visual Basic for Applications (VBA) which resembles VB in many ways. VBA has its own grammar or 'syntax'. The writing of the macros must follow this 'syntax' or grammar otherwise...

• 

  How to record a macro in Microsoft Excel 2007

  pubblicato 11 mesi fa

  2:51 | 104 visualizzazioni

  Record a macro to get 2 major benefits: (1)Perform the same action with the macro again and again. (2)Learn Visual Basic for Applications by studying the VBA code in the Visual Basic editor.