SpreadsheetML.com

Language:
Show price in:
  • Excel Training - Level 3 - (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 - Advanced Formulas In this lesson, we will show you how how to easily write those mega functions that you have seen elsewhere. This includes concepts like Nesting, Array Formulas and Dfunctions. Nesting means to use the result of one formula as the argument in another. Array formulas allow you to perform calculations and return a result. Dfunctions are known as Excel Database functions. Lesson 2 - Advanced Filters In this lesson, we will have a good look at one of Excel's arguably most useful features and that is the Advanced Filter. Advanced Filter will allow us to nominate where we would like our filtered data to be placed. The choices are: Filter the list, in place or Copy to another location. Advanced Filter has a built-in function that will allow us to filter by unique records. Advanced Filter allows us to use a formula as our criteria. Lesson 3 - Pivot Tables (Part 1) In this lesson we will start to look at arguably one of Microsoft Excel most powerful and useful feature, that is Pivot Tables. In a nutshell a Pivot Table takes two dimensional data (your spreadsheet) and creates a three dimensional table (the Pivot Table itself). They are a great way to produce statistical information from a table of data. We would use a Pivot Table to produce meaningful information from a table of information. You will recall in lesson 2 we looked at Excel's Advanced Filter feature and how it could be used to extract information from a table of data based on a set of criteria. A Pivot Table could be used on that same table to create a table that could tell us much statistical information about all the data contained within it. Lesson 4 - Pivot Tables (Part 2) In this lesson, we will look at constructing some more complicated pivot tables and extracting meaningful data from them. This includes Grouping Fields options where we could, for example, group people(data) by the years(attributes) in which they were born(rules). Lesson 5 - Pivot Tables (Part 3) In the last lesson on Pivot Tables, we looked at setting up a complete pivot table and how to use the grouping and field options of Pivot Tables. We will also discuss some of the more advanced features like Calculated field and, more importantly, be fully aware of the pitfalls associated with them. Lesson 6 - Scenarios and Goal Seek In this lesson we are going to look at two of the tools that are specifically designed for use in "What-If analysis", and as such make up part of the "What-If Analysis Toolpak of Microsoft Excel". These tools are used to determine different outcomes of your data by changing different cells within a Worksheet model. The two tools we will discuss here are called Scenarios and Goal Seek. Both of these tools are used widely in financial, accounting and engineering businesses today, and once understood, can be a huge aid in determining various outcomes and projections. Lesson 7 - Data Tables and Consolidation In this lesson, we are going to look at two of the very handy, but little known features of Excel -- Data Tables and Consolidation. Data Tables are another one of the tools that are specifically designed for use in "What-If analysis". By now, you will be familiar with how "What-If Analysis" works and what it is used for. Data Tables are just a range of cells that are used for testing and analysing outcomes on a a larger scale. Consolidation is a powerful feature of Microsoft Excel that enables you to combine data from separate worksheets into one consolidated worksheet. It also enables you to perform many calculations on this data, including 3-D formulas, which are formulas which refer to cells on multiple Worksheets. Lesson 8 - Excel on the Web One extremely handy feature that Excel offers is its ability to allow you to publish a spreadsheet on the web, so you can communicate your data to anyone you like, irrespective of whether they use or even have Microsoft Excel on their computers. In other words, your Excel spreadsheet can be viewed in a web browser. This could be useful for such things as employers wanting their employees to access things such as sales data from different areas, cost calculations, time sheets and many other uses. Basically, if your Excel Workbook is placed on the web, people anywhere in the world can access it, with or without Excel. Lesson 9 - MACROS (Part 1) In our last two lessons in our Excel Level 3 course, we will be taking a look at recording, editing and running macros using Excels Macro Recorder. A macro is simply an action or a set of actions you can use to automate a particular task or tasks. You use the Macro recorder a bit like using a video camera. You switch it on, record what you want to record, then switch it off. In effect a macro is like a mini-program that performs the actions that you have recorded. Macros are a fantastic time-saving feature and are ideal for automating repetitive tasks. They are also useful if you are setting up an application for others to use as you can use macros to create buttons and dialog boxes to guide a user through your application as well as automating the processes involved. Lesson 10 - MACROS (Part 2) In this, our last lesson in our Excel Level 3 course, we will be delving further into the macro feature of Excel. You now know how to record and run both absolute and relative macros, and hopefully you now understand a little about the actual macro (VBA) language. In this lesson we are going to create a mini-application using macros and we will assign these macros to an object.


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

Copyright© ConnectCode 2006-2013. All Rights Reserved.