GET IT Certification Training from Self-Study Store!

Self-Study Store offers a wide range of quality Computer-Based Training (CBT) and Online Computer Training (WBT) solutions for IT Certification Training to Microsoft Office Training to Business & Personal Development (Softskills) training. Computer-Based Training empower individuals to learn key skills or reach career goals. With Self-Study Computer Based Training CD courseware, you can start your education anytime and anywhere without the hassle of attending a classroom environment. Get Microsoft MCSE certified faster with live boot camp classes! Check out the MCSE boot camp training courses here.

Select from over 150 affordable Online and Computer Based Training for your needs, including the CompTIA A+ certification training and MCSE certification exam training. Browse our site to find more reasons how our computer training products will help you step foot in the door of competitive IT industry.

30-Day Money Back eLearning Guarantee

All online and cbt training courses come with a 30-day money back gaurantee.

Before you consider another elearning course, make sure that you receive a full 30-Day money back guarantee! Don't be fooled by the common no pass, no pay exam certification guarantee. No matter what, if you're not satisfied with the course content within 30 days after receiving the course, send it back for a full refund, less shipping fees.

MCSE Certification Self-Study Store offers the Microsoft MCSE 2003 Training on CD Format. Learn from home or at work, when time isn't a luxury. Our Microsoft courses engage you with full interaction within a hands-on learning environment. Learn key steps over and over until you are confident enough to pass the exams. Visit our MCSE Training Product Page

A+ Certification Training This self-paced A+ (APlus) training course comes in 7 modules, 2 cd-roms, and is CompTIA approved! Packed with interactive exercises and comes in full audio. This A+ (APlus) course covers both hardware and operating system exams to help you obtain your A+ certification. Learn key steps repeatedly at your own pace, until you fully comprehend A+ concepts. Visit our A+ Training Product Page

Cisco Certification Training Cisco Training by Self-Study Store gives you an affordable training method to become Cisco certified. Self-Study Store offers CCNA, CCNP, CCDA, CCDP certification training courses for self-paced learning. Each Cisco CBT Course was co-developed with Cisco and this gives you the edge you need to pass the cisco exams on your first try. Visit our Cisco Training Product Page

Thank you for visiting Self-Study Store, an alternative online computer training solution for Microsoft, Cisco, CompTIA, CIW, Oracle, Linux and more. Feel free to contact us at 1.866.831.7353.

Articles:

Entering Formulas in Excel

If you haven't had a chance to enroll in Microsoft Excel Training yet but need to work with spreadsheets on a basic level, one of the first things you should learn his how to enter simple formulas in Excel. Once you learn how to work with formulas, you'll see just how useful spreadsheets are.

Formulas fall into several categories including AutoSum, Financial, Logical, Text, Date and Time, Lookup and Reference, Math and Trig, and many more. You use the Function Library in the Formulas tab of Excel 2007 to insert formulas using a wizard or you can enter formulas directly in the cells.

For example, if you have a column of values that you want to total, clicking the AutoSum icon automates this. Simply click the cell below the column and then click AutoSum. This will automatically place =SUM and the range that is being totaled into the cell and return the results.

Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation

You can also type in the formula manually. In the above example, you'd type in: =Sum(C4:C15).

Formulas start with an equal sign and reference the various cells. In math formulas, the plus and minus signs are used to represent addition and subtraction while the asterisk (*) and forward slash (/) are used for multiplication and division.

Let's say you want to calculate the cost of gallons used by the average price per gallon of gas. You can do this by entering a formula into the cell directly below "Cost" which is cell D4. The formula is: =B4*C4

Now, you can simply copy the first formula and paste it into the remaining cells in the column to have each month's total cost for gas calculated automatically.

While formulas are extremely useful, Excel offers far more than automatic calculations. This makes Microsoft Excel 2003 Training valuable. If you have Excel 2007, make sure to specify Microsoft Excel 2007 Training as the 2007 version is dramatically different than previous versions.