SpreadsheetML.com

Language:
Show price in:
  • Excel Training - Level 2 - (v1.x)

    Merchant:
    ConnectCode Pte Ltd
    Unit price:
    $30.00
    Total price:
    $30.00
    Quantity:

     

    The purchase allows the installation of this Excel Training Course to an unlimited number of PCs within your organization.

    Lesson 1 - Naming Constants. Dates and Times In this lesson, we review the basic concepts of Excel and go into details the concept of Naming Constants and how Excel interprets Dates and Times. Lesson 2 - Worksheet Formulas In this lesson we will look at the thing that Excel does best -- Calculations. Excel has over 300 built in functions that can perform simple additions to some very obscure engineering functions. We will also look at how we can easily perform Nesting, Formula Auditing and Troubleshooting. Lesson 3 - Specific Worksheet Formulas We would like to show you some of Excel most useful and popular functions like COUNT, Address, COUNTIF, DATEVALUE, HLOOKUP, MATCH, MAX and VLOOKUP. Lesson 4 - Decision making and extracting data This lesson provides a good overall look at deciding what functions to use and how to use them. There are no hard and fast rules as more often than not you will need to use a nested formula that will incorporate many types of functions. Extracting data from tables and databases is something that is done quite frequently from within Excel. This lesson is meant as a guide to extracting data from a database or table. Lesson 5 - Validation and External References One thing you can be certain of when allowing other users to input into a spreadsheet you have designed is that they undoubtedly will enter incorrect data at some time or another. This lesson shows you how Excel can help you perform validation. Lesson 6 - AutoFilters, Advanced Filters and Range Names This lesson shows you how you can use Excels Filters (Advanced and Auto) to display virtually any criteria we want, so long as we have set up our table or list is a sensible manner. Lesson 7 - Introduction to Charts Charts in Excel can range from the very simple to the very complex and can be used for a multitude of reasons. They can be used to keep track of spending, stock performance, statistics, employee details and much more. Most charts are used to show a comparison of past data in a highly visual style. A well set up chart should be able to inform the user at a glance exactly what the picture is that it is painting. We have all heard the saying “A picture paints a thousand words” and this should always hold true with charts in Excel. If an informed user looks at a chart and cannot tell what it is that the chart is representing, then it would be fair to say that the chart has not been set up very well. Excel is arguably the best of the Office Applications when it comes to creating and/or using charts. It allows us to create almost any kind of chart needed with minimal effort. As can be said with a lot of Excels features and capabilities, we often find ourselves using only a very small aspect of them, charts are no different in this respect. Lesson 8 - FOUR NOT-SO-COMMON Handy Features For this lesson we thought we would look at a few of Excel’s little known but very handy features. These are Custom Formats, Text to Columns, Save Workspace and Custom Lists. Lesson 9 - Protecting and Hiding There are times when using Excel that we do not want other people to make changes to our Workbooks, Formulas, Worksheets or Cells. We can achieve this in many ways, ranging from hiding data to preventing the Workbook from opening at all without a password to protecting the Workbook or Sheet. Lesson 10 - Custom Views and Report Manager Custom Views can be used on it’s own or in conjunction with the Report Manager. The purpose of Custom Views is to save the appearance of a chosen Workbook. This means we can have more than one person work on a Workbook and each person can save their own Custom View. It also saves a lot of time with Print settings that can be very time consuming and fiddly.


 
http://www.spreadsheetml.com and http://www.barcoderesource.com

Copyright© ConnectCode 2006-2013. All Rights Reserved.