If you already know how to declare variables, test conditions, create loops and select cells using keywords like END and OFFSET, you may be ready for our two-day advanced VBA course (but note that for casual users of VBA this will be a course too far). The course will teach you pretty much all of the theory that you'll need to automate routine tasks in Excel, although don't underestimate the need to then practise what you've learnt after the course has finished. You won't need any prior experience to attend this course, although if you've used another programming language you'll find it easier to pick things up. Along the way you'll learn how to create robust financial models. You'll learn much more about the many useful functions in Excel such as VLOOKUP, MATCH and INDEX, as well as how to work with pivot tables and how to import data from different sources.ĭo you consider yourself proficient at using Excel? Do you build spreadsheet models as part of your job? This two day course will show you three things above all: how (and why) to use range names for every formula you create, the many short-cut keys available in Excel and how to use all the built-in Excel functions. You'll learn how to sort and filter data in tables, how to apply conditional formatting, how to use IF functions, how to create range names and much more.įor those who are already comfortable using Excel, and want to find out what else the software allows you to do, we've created this two-day advanced course. This is aimed at people who know the basics, but want to find out a bit more about what you can do in Excel. You won't need any existing experience to attend this course. This is aimed at beginners: it shows how to create, format and print basic worksheets, and how to create simple charts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |