+ Reply to Thread
Results 1 to 4 of 4

Training material?

  1. #1
    Registered User
    Join Date
    11-11-2010
    Location
    Oslo
    MS-Off Ver
    Excel 2003
    Posts
    3

    Smile Training material?

    Hei!
    I hope somone can help me. I am looking for some training material. I am going to have some trainingsessions with some of my coellegues. I just wonder if someone have some good links or files that could help me? Need some examples that I could use.

    Everything is okay. All from easy use of formulas to advanced use of functions.

    Please help me.
    Reg
    Jonny
    Last edited by jonlill; 11-21-2010 at 02:45 PM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Training material?

    jonlill,

    Training / Books / Sites:

    How to Learn to Write Macros
    http://articles.excelyogi.com/playin...ba/2008/10/27/

    How to use the macro recorder
    http://articles.excelyogi.com/

    Click here and scroll down to Getting Started with VBA.
    http://www.datapigtechnologies.com/ExcelMain.htm

    If you are serious about learning VBA try
    http://www.add-ins.com/vbhelp.htm

    Excel Tutorials and Tips - VBA - macros - training
    http://www.mrexcel.com/articles.shtml

    See David McRitchie's site if you just started with VBA
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    Debra Dalgleish has some notes how to implement macros here:
    http://www.contextures.com/xlvba01.html

    David McRitchie has an intro to macros:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    Ron de Bruin's intro to macros:
    http://www.rondebruin.nl/code.htm

    Creating custom functions
    http://office.microsoft.com/en-us/ex...117011033.aspx

    Writing Your First VBA Function in Excel
    http://www.exceltip.com/st/Writing_Y...Excel/631.html

    http://www.excel-vba.com/
    http://www.mvps.org/dmcritchie/excel/getstarted.htm
    http://www.exceltip.com/excel_links.html

    (livelessons video)
    Excel VBA and Macros with MrExcel
    ISBN: 0-7897-3938-0
    http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1

    http://www.xl-central.com/index.html

    http://www.datapigtechnologies.com/ExcelMain.htm

    Dependent validation lists. Debra has a neat little tutorial here.
    http://www.contextures.com/xlDataVal02.html

    Data Validation > Drop-Down Lists - Dependent
    http://www.bettersolutions.com/excel...E229212022.htm

    Cascading queries
    http://www.tushar-mehta.com/excel/ne...ing_dropdowns/

    http://www.contextures.com/xlDataVal05.html

    Excel Data Validation - Add New Items
    http://www.contextures.com/excel-dat...ation-add.html

    Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
    This page describes how to write code that modifies or reads other VBA code.
    http://www.cpearson.com/Excel/vbe.aspx

    Locating files containing VBA
    Searching Files in Subfolders for VBA code string:
    http://www.dailydoseofexcel.com/arch...a-code-string/

    http://www.pcreview.co.uk/forums/thread-978054.php

    Excel 2003 Power Programming with VBA, by John Walkenbach

    VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

    Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

    VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

    Excel 2007 Book: you can try this...there is a try before you buy ebook available at this linků
    http://www.mrexcel.com/learnexcel2.shtml


    DonkeyOte: My Recommended Reading:
    Volatility
    http://www.decisionmodels.com/calcsecretsi.htm

    Sumproduct
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    Introduction to Array Formulas
    http://www.xtremevbtalk.com/showthread.php?t=296012

    Using Pivot Tables and Pivot Charts in Microsoft Excel
    http://peltiertech.com/Excel/Pivots/pivotstart.htm

    Email from XL - VBA & Outlook VBA
    http://www.rondebruin.nl/sendmail.htm
    http://www.outlookcode.com/article.aspx?ID=40

    Excel Function Dictionary
    http://www.xlfdic.com/

    Excel 2007 function name translations
    http://www.piuha.fi/excel-function-name-translation/

    Dynamic Named Ranges
    http://www.contextures.com/xlNames01.html


    Where to paste code in VBE VBA
    Introducing the Excel VBA Editor
    http://www.ask.com/web?qsrc=2417&o=1...cel+VBA+Editor

    VBA for Excel (Macros)
    http://www.excel-vba.com/excel-vba-contents.htm

    VBA Lesson 11: VBA Code General Tips and General Vocabulary
    http://www.excel-vba.com/vba-code-2-1-tips.htm

    Excel VBA -- Adding Code to a Workbook
    http://www.contextures.com/xlvba01.html

    Basics of array formulas
    http://www.youtube.com/view_play_lis...7E7E9CA63304D3

    Array formula data extract formulas
    http://www.youtube.com/watch?v=Tp7I5u1MqiM
    http://www.youtube.com/watch?v=R5ZWAiNJLNo
    http://www.youtube.com/watch?v=132ZdpxBm1U

    Unique Record Counting and Data Extract formulas
    http://www.youtube.com/watch?v=uUrI8hoj8BA


    And, as your skills increase, try answering posts on sites like:
    http://www.mrexcel.com/
    http://www.excelforum.com/
    http://www.ozgrid.com/
    http://www.vbaexpress.com/portal.php
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Training material?

    and don't forget the tips link in this forum
    http://www.exceltip.com/exceltips.php
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    11-11-2010
    Location
    Oslo
    MS-Off Ver
    Excel 2003
    Posts
    3

    Thumbs up Re: Training material?

    Thanks for great tips!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1