VBA Macros – How to create Your Own Excel Macros

Excel VBA macros make repetitive tasks as simple as recording your keystrokes and pressing run. This tutorial will show you how to access the macro recorder, how to record your macros and how to run your macros to remove repetition from your daily task list. This tutorial is a fairly basic tutorial and therefore requires only a basic knowledge of Excel. To learn the basics, Excel 2013 For Dummies Video Training, Deluxe Edition course offers 106 lectures and 19.5 hours of content that will teach you the basics of Excel 2013. The course will teach you to launch and navigate worksheets as well as how to save and print your data. You will learn how to enter data and how to use AutoFill to make data entry simpler. The course will teach you to enter and print formulas and once you have a good knowledge of the basics the course will teach you advanced functions like how to work with pivot charts and tables. The course also covers how to share your workbooks via SkyDrive.

[Read more…]

Solver: Excel 2013 Tutorial

Excel 2013 contains powerful tools to save you hours of calculations. The Excel solver function for example, can help you work out what optimum levels of production or sales will be based on various objectives and constraints. This tutorial will show you how solver works and how you can use it to determine how many units to sell in different branches of an organization.

If you are familiar with Excel and want to take your skills to the next level, enroll in Learn Microsoft Excel 2013 – Advanced now and join over four thousand students who are learning to use Excel like a pro. This course offers over 52 lessons and 12 hours of video content to teach you how to take advantage of advanced Excel functions. You will learn how to work with dates and times, how to calculate depreciation, how to insert and format tables and how to work with Pivot tables and charts. [Read more…]

How to program in Java – Absolute Beginners Guide to Java

constructor javaJava is still one of the most popular and most important programming languages. Once you understand Java, you will have the foundation for understanding a lot of the modern programming languages today like JavaScript. This article is a basic introduction to how to program in Java. It includes basic concepts you need to know to start your Java learning journey.

For a great introduction to Java, Java Programming for Beginners offers over 59 lessons and 6 hours of content designed to give you an excellent introduction to the Java programming world. The course will start by teaching you basic Java concepts, tools and functions. Once you understand the basics, you will learn to create your first fully functional program. You will learn about Java syntax and how to use the syntax to create Java applications. The course will also introduce you to object oriented programming and you will learn about Java and the JDK development environment. The course includes lessons on how to install the JDK as well as how to use variables, classes and objects.

[Read more…]

Java Coding Standards and Google Java Coding Standards

java string to byte arrayThe advent of open source and community development changed the way developers and programmers create new applications and collaborate on the development of new projects and designs, but there is one downside to open source, and that is that this type of collaboration can lead to a diverse approach when it comes to coding approaches and standards. That is why the Google Java Coding Standards guide has been seen by many within the industry as a great way to standardize the approach to coding in Java applications. And let’s face it, who is going to argue with Google anyway? As one of the most powerful providers, it pays to ensure your coding meets the requirements set out in the guide. If you are new to Java, the Introduction to Java Training Course offers 205 lessons and over 20 hours of video content that will teach you all you need to know about coding in Java. It will show you how to write stand-alone applications using the Java language and Eclipse IDE for development purposes. It will help you to accurately implement object oriented principles using the various Java features like classes, interfaces and references. You will create well-scoped classes using pages and you will learn to write programs that handle exceptions. The course will teach you to read and write data input using various output and input streams and you will learn to use the Java collections framework to group objects and work with those groups.

[Read more…]

Vlookup – Cheat Sheet for Vlookup in Excel

When you’re working with large workbooks that contain thousands of rows of data, then finding information can be worse than searching for a needle in a haystack. Luckily Excel 2013 comes with built-in lookup functions like Vlookup and Hlookup that makes finding that needle really simple. This tutorial will teach about how the Vlookup function works and how you can use the Vlookup function to find any data within your worksheet. If you are new to Excel, consider enrolling in the Excel 2013 for Dummies Video Training, Deluxe Edition course now and join over one thousand students who are learning to harness the power of Excel to manage and sort through their data.

[Read more…]

Excel VBA Vlookup – Add a Form to Find Prices in Excel 2013

excel vba vlookupVisual Basic for Applications makes Excel 2013 more than just a spreadsheet for saving, sorting and analyzing data. VBA allows you to create small programs or routines within Excel that users can use to access the data in the worksheet. In this tutorial we will use VBA to create a form that allows users to look up the price and stock of a particular item quickly and easily using a custom user form. This tutorial is based on the assumption that you are used to working in Excel and that you know the basics of the application. If you would like to develop your Excel skills, Learn Microsoft Excel 2013 offers over 102 lectures and 3.5 hours of content will help you master the basics of Excel. The course will teach you all of the basic functions of worksheets and workbooks. You will learn about formatting your data and worksheets. You will learn all about Excel formulas, illustrations and you will learn to create your own charts. The course will teach you how to save, print and share your workbooks. Once you have the basics, you will learn about the advanced functions of Excel and how to use them.

[Read more…]

Vlookup examples in Excel 2013 – Make searching simple

Excel has a number of built-in formulas and functions to help you store, search and analyze your data. If you are working with large worksheets, then finding specific data within that worksheet can prove quite difficult. This tutorial will show you how to use the Vlookup function to find data quickly and easily. We will use the Vlookup function to lookup specific data and then we will create a function to allow others to find data quickly and easily by selecting an item. This tutorial contains references to function like named ranges. For a great introduction to Excel, check out the Excel 2013 For Dummies Video Training, Deluxe Edition course. This course offers over 106 lectures and 19 hours of content designed to take you from beginner to Excel master. You will learn how to launch and navigate Excel worksheets. You will learn to add data and how to use AutoFill to make adding data really simple. The course will teach you about the various Excel Formulas and how to use them in your worksheets. Once you are familiar with simple tasks, the course will teach you about advanced techniques including working with pivot charts and tables, and sorting and filtering data.

[Read more…]

Programming in Excel for Absolute Beginners

excel cell referenceProgramming in Excel is simpler than you may think. The VBA editor and built in programming functions in Excel make creating your own routines and programs easy. This tutorial will show you how to create your own Inventory Input form so that a user can add stock to the worksheet. This tutorial requires a basic knowledge of Excel. For a great introduction to Excel, enroll in the Microsoft Excel 2013 Basics course now. This course contains lessons that will teach you how to identify parts of the worksheet. You will learn how to select cells and enter data. The course will show you how to change column widths and row heights. You will learn to work with various elements of the worksheet and you will learn to work with charts.

[Read more…]

Vlookup Multiple Values – The Array Formula to Look Up Data

shutterstock_169741670Vlookup allows you to search data for a value and return a corresponding value from the sale row. Vlookup is great for returning values like a price for a particular item or stock on hand for a particular item being sold. Vlookup however has one limitation because Vlookup only returns one value at a time. To use Vlookup for returning multiple values, you need to either use multiple instances of the Vlookup formula or you need to use an array formula. This tutorial will show you how to use the array formula to lookup multiple values within a table where values are repeated within the table.

This tutorial requires a good knowledge of the use of Excel. To improve your Excel skills, Excel 2013 For Dummies Video Training, Deluxe Edition will take your Excel skills to the next level. This course offers over 106 lessons and 19 hours of video content designed to turn an Excel beginner into an Excel Professional. This course will teach you all the basic skills required to use Excel 2013, from launching the application to navigating your workbooks. You will learn to enter data and how to use the AutoFill feature to allow for simpler data entry. You will then learn to add formulas to your worksheets. Once you have mastered the basics, you will move onto pivot tables and charts and other advanced skills. The course will even teach you to share your workbooks via SkyDrive.

[Read more…]

Vlookup VBA – An Excel Tutorial on how to use Vlookup in vba

The real power of Excel lies not in the built-in functions and formulas that are available in Excel, but in the fact that Excel also allows users to create small code snippets based on

Visual Basic using the Excel VBA functions. Excel VBA is an acronym for Visual Basic for Applications and the VBA turns Excel from an ordinary spreadsheet into a fully-fledged application development environment. This tutorial will show you how to access VBA in Excel and how to use the Vlookup formula in VBA. To learn to harness the power of Excel, enroll in Excel 2013 The Basics now. This course includes just under four hours of videos to teach you all the Excel skills you will need to become an Excel master. You will learn how to get started in Excel 2013. The course will teach you how to perform calculations, how to modify worksheets and how to save and print your worksheet. You will learn to manage large workbooks and how to customize your Excel working environment. You will also learn advanced Excel functions and formulas and you will learn about the developer tab which is essential for VBA.

[Read more…]