...edupristine.com/ca Agenda Introduction to Macros & Advanced Application Building in Excel • Introduction and context Key Concepts in Macros Macros as recorded Robots! Designing application to gather user data • Implementing user forms in Excel Macros • Linking forms to excel cells • Building flexible Charts in Excel Understanding VBA • Understanding the relevant language constructs • Example: Write your First Macro Debugging VBA code • Errors in VBA • Step into VBA Writing more VBA Codes • Random Number Generator: Use of Loop, Excel Functions • Message Box, Input Box Advanced Financial Applications • Breaking circular loops • Monte Carlo Simulation © EduPristine Macros 2 Agenda Introduction to Macros & Advanced Application Building in Excel • Introduction and context Key Concepts in Macros Macros as recorded Robots! Designing application to gather user data • Implementing user forms in Excel Macros • Linking forms to excel cells • Building flexible Charts in Excel Understanding VBA • Understanding the relevant language constructs • Example: Write your First Macro Debugging VBA code • Errors in VBA • Step into VBA Writing more VBA Codes • Random Number Generator: Use of Loop, Excel Functions • Message Box, Input Box Advanced Financial Applications • Breaking circular loops • Monte Carlo Simulation © EduPristine Macros 3 Building user applications in excel requires knowledge of advanced functions Excel is one of the most widely used...
Words: 4063 - Pages: 17
...Microsoft Excel for financial calculations? Microsoft Office Excel is a great computer program that is widely used throughout the financial industry. Excel is an invaluable tool in Finance and Accounting. Of course professionals also use special financial calculators. But a financial calculator can be expensive for students. It is not intuitive to use and unless they become investment bankers or realtors, most students will never use it after finishing the financial course. Fortunately, it is very easy to create a financial calculator for free if you have Excel on your computer. In fact, an Excel calculator can do much more than a dedicated financial calculator. Another advantage is the fact that if you learned how to use financial functions of Excel you will be able also to use a special financial calculator should the need arise. Below is a short introduction of how to start using MS Excel for financial calculations. Inserting Functions Excel comes with a wide array of functions that can easily be inserted into a spreadsheet. Adding a function is as easy as clicking on the "Insert Function" button on the top tool bar. Insert Function Button If you don't see the "Insert Function" button on your tool bar, you can easily add it by clicking: Tools > Customize > Commands > Find and click on Insert in the left-hand scroll-down menu. Then, find "Insert Function" in the right-hand scroll-down menu and click and drag it to your tool bar. Clicking on the "Insert Function" button...
Words: 488 - Pages: 2
...Introduction to Microsoft Access 2003 Zhi Liu School of Information Fall/2006 Introduction and Objectives Microsoft Access 2003 is a powerful, yet easy to learn, relational database application for Microsoft Windows. This tutorial is designed for users who are new or only have little experience using Access 2003. It introduces fundamental database concepts and operations and illustrates how they are performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003; emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access. Please be aware that Microsoft Access is only available for Windows users; Mac users may want to seek out a FileMaker Pro Tutorial. Objectives By using this tutorial, you will learn to perform the following operations in Access 2003: • • • • • • Launch Access and identify the parts of the screen. Define fields and field properties constructing table structures. Enter and edit records in a table. Find, sort data. Design custom queries to display data. Import and export data between Excel and Access. Definitions These words are used often in Access so you will want to become familiar with them before using the program and this tutorial. Relational Database: in relational databases such as Access, data is stored in tables made up of one or more fields (Access calls a column a field). The data stored in each 1 ...
Words: 3238 - Pages: 13
...Beginner's Guide To The Bloomberg Terminal: Introduction Filed Under » Fundamental Analysis, Investment, Technical Analysis, Trading Systems Welcome to the Beginner's Guide to Bloomberg. This portion of the guide is aimed at new Bloomberg users, and will provide an overview of how to use a Bloomberg terminal. If you are a more experienced user, or if after reading this guide you want to go into more detail on Bloomberg's capabilities, please be on the lookout for the Advanced Guide to Bloomberg which will soon follow. (For more, see Day Trading Strategies For Beginners.) In this Basic Guide, we will examine how to sign up for, install and access Bloomberg. We will then go on to covering basic navigation on the Bloomberg system. Navigating Bloomberg is somewhat unique in that the system uses a special keyboard with some keys that are different from those found on a "normal" keyboard. Therefore, the navigation section of this guide will be important to newcomers. After gaining a working knowledge of these basics, in chapter four we will then move on to discuss some of the market and news monitor functions that are available on Bloomberg. Chapter five will focus on the basics of analyzing securities on Bloomberg. Advanced functionality in this area will be covered in the Advanced Guide; in this Basic Guide we will focus more closely on the types of analysis that Bloomberg allows users to perform. Finally, chapter six will provide some tips and tricks for navigating Bloomberg...
Words: 3683 - Pages: 15
...Excel Tutorial to Improve Your Efficiency (2007 Version) Introduction My purpose with this Excel tutorial is to illustrate some Excel tips that will dramatically improve your efficiency. I make no attempt to be as encyclopedic as some of the 800-page Excel manuals available. I concentrate on common tasks, not every last thing that can be done in Excel. Also, I presume that you have some Excel knowledge. For example, I assume you know about rows and columns, values, labels, and formulas, relative and absolute addresses, and other basic Excel elements. If you know virtually nothing about Excel, you probably ought to work through an “Excel for Dummies” book and then work through this tutorial. The style of this tutorial should be easy to follow. Main topics appear in bold black type. Specific direction headings are in yellow, and these are followed by detailed directions in red. Additional comments about the directions appear in blue. Then there are “Try it!” exercises in green. These “Try it!” exercises are a key feature of this tutorial. I have embedded numerous sample Excel spreadsheets so that you can try out the directions right away—without switching into Excel. When you double-click on one of these spreadsheets, you launch Excel, and the spreadsheet “comes alive.” The menus and toolbars even change to those for Excel. By clicking outside one of these spreadsheets, you’re back in Word. The easiest way to maneuver around this tutorial is to switch to outline view. To do...
Words: 6379 - Pages: 26
...MS-EXCEL FOR CHARTERED ACCOUNTANTS SUNIL B GABHAWALLA CHARTERED ACCOUNTANT WESTERN INDIA REGIONAL COUNCIL OF THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA TABLE OF CONTENTS 1 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry ................................................................................................................... 8 2.1 Text ..................................................................................................................... 8 2.2 Number (including date, time, percent) .............................................................. 8 2.3 Formulae ............................................................................................................. 8 2.4 Functions............................................................................................................. 9 2.5 AutoComplete ..................................................................................................... 9 2.6 AutoCorrect........................................................................................
Words: 16077 - Pages: 65
...Excel 2010 Microsoft ® ® ® Formulas John Walkenbach BONUS CD-ROM! Includes all Excel workbook files used in the book, plus the complete book in a searchable PDF file Excel® 2010 Formulas by John Walkenbach Excel® 2010 Formulas Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 7486011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks...
Words: 49651 - Pages: 199
...Symbiosis Institute of Business Management, Pune MS Excel 2010 Preinduction Courseware Contents Introduction to Microsoft Excel 2010 ......................................................................................... 2 What is new in Excel 2010 ..................................................................................................... 2 Getting started with Excel 2010 .................................................................................................. 4 Excel worksheet movement keys ............................................................................................ 4 Entering and editing data in Excel worksheet............................................................................. 5 Using AutoFill to enter a series of values ............................................................................... 5 Creating Custom Lists............................................................................................................. 6 Adding comments in the cell .................................................................................................. 6 Editing data in Excel worksheet ............................................................................................. 8 Using Paste Special ................................................................................................................. 8 Formatting data in the worksheet ...........................................................................
Words: 3348 - Pages: 14
...Chapter 4: More on Logical, Information, and Text Functions Introduction Logical functions are those that involve Boolean values. The Boolean values are TRUE and FALSE. Some logical functions return a Boolean value as their result, others use the Boolean result of a comparison to choose between alternative calculations. There are six functions listed in the logical group in Excel 2003 – the functions AND, FALSE, IF, NOT, OR, TRUE – and a seventh in Excel 2007 – the function IFERROR. You’ll see the use of most of these in this lab. First, however, it’s worthwhile to become familiar with the logical operators. Logical Operators TRUE and FALSE are common concepts. They are values which pertain to statements. For example, the statement “It is morning.” is either TRUE or FALSE. We recognize that its truth value may change, but at any particular time the statement is either TRUE or FALSE. What may be hidden here is the existence of an implied comparison. To determine the truth value of any statement we compare our understanding of the meaning of the claim with the facts. Strictly speaking the statement “It is morning.” means the time of day is after midnight and before noon. To decide if it’s TRUE we need to know the actual time of day and compare it to our criteria. It’s in these comparisons that we use Logical Operators: |Comparison |Symbol | |less than |< | |less...
Words: 2638 - Pages: 11
...Spreadsheet Templates to Accompany Horngren et al, Introduction to Management Accounting 14e Templates by Albert Fisher EXCEL TUTORIAL ___ This tutorial is written for you, the student, to help you complete the Excel templates that your instructor may assign as needed. These templates are partially completed to allow you to concentrate on solving the problem and not worry about the formatting or presentation of the answer. All cells that need to be completed are shaded in blue and will require you to enter one of the following: a formula, an account title, a number, or a function. These four items will be covered in a later section of this tutorial. Finally, there a few problems that have no shaded cells and you will be required to complete the entire template. BASIC SKILLS Starting Excel is similar to starting other Windows applications. The following steps are required: Launching Excel Double click the Microsoft Excel icon from your desktop icons. If Excel does not have a desktop icon, then do the following: a. Click Start to display the start menu. b. Click Program to display the programs available on your computer. c. Scroll down until you find the Excel program and double click on it. Opening a Worksheet File a. Make sure your student CD is in the disc drive. b. There are two ways to open a worksheet file. 1. The first way is to click the Open button. Buttons are shortcuts for many worksheet tasks. We will be using some of these...
Words: 1297 - Pages: 6
...Welcome to Microsoft Excel 2007 Introduction Level Prepared by: Ziad Azzi Sep , 2014 What is a Spreadsheet? A spreadsheet is a document that is entirely made up of rows and columns. It is used to list and analyze data. Editing and formatting – Excel works much like the tables in MS Word Formulas and functions – Excel allows you to perform calculations and analyze data. Common calculations include: finding the sum, average or total number of items in a list Creating Charts and Graphs – You can create colorful charts and graphs from the data in your worksheet. Excel will automatically update the chart to display any changes you make in your data. =sum(B6:B23) =AVERAGE(F4:F8) =count(B2:B25) Starting Excel Excel 2007 Workspace Made up of rows and columns Up to 1,048,576 rows and 16,384(XFD) columns Worksheet Sheets By default 3 but the total number of sheets are limited only by the amount of computer memory Excel 2007 Workspace WHAT IS A WORKBOOK? Multiple worksheets Creating and Opening workbook New Open Excel 2007 Workspace The workspace • includes the page area, the Main Menu and Toolbars. By default, the formatting and standard toolbar will be displayed. Excel 2007 Workspace Excel 2007 Workspace Excel 2007 Workspace Excel 2007 Workspace Excel 2007 Workspace Office button: When clicked, this button opens the Office menu, from which you can open, save, print, and exit as well as the Excel Options button that...
Words: 2286 - Pages: 10
...Introduction to Matlab[1] MATLAB( is a computer program by MathWorks, Inc. for people doing numerical computation. Matlab handles numerical calculations and high-quality graphics, provides a convenient interface to built-in state-of-the-art subroutine libraries, and incorporates a high-level programming language. The purpose of this document is to introduce you to some of the basic capabilities of Matlab which you will find useful for a range of data analysis, plotting, or modelling applications. You will learn to work with Matlab by solving a series of exercises to read, analyse and plot a variety of micrometeorological data. 0. Getting started For the purpose of this introduction, we will assume that you will be using Matlab on a PC-Windows machine, although the appearance and functionality of Matlab is largely platform independent. Begin by starting Matlab from the Start menu. The command window will appear, and this is where you enter commands. Matlab is “command driven”, unlike Excel and most other Windows-based programs. In this document the symbol >> represents the Matlab prompt in the command window. Commands following it indicate that you should type these in; Matlab commands or responses are printed in Bookman Font. Pushing the Enter key causes the command to be executed. Matlab has extensive help resources, available under the "Help" tab of the MATLAB window, or type >> help topic. Hint Use the ( key to recall previous commands, which you...
Words: 3576 - Pages: 15
... cost projections, accounting results, or internal quality reports, every company depends on knowledge to support its planning, decision-making, and control. So how does knowledge fit into the picture? The emergence of the field called knowledge management has highlighted some key propositions in the last 10 years or so. All organizations are storehouses of knowledge that operate in information-rich environments made up of people and things both inside and outside the organization itself Organizations organize, interpret, and evaluate this information to solve organizational problems Knowledge is the primary mechanism for processing and utilizing information People's brains are the key knowledge resource of any organization Codified knowledge stored in books, audio, videotapes, and computer systems can be an important knowledge resource as well There are organizational processes and strategies for IT management and management in general. Therefore, processes and strategies in particular can significantly enhance the ability of organizations to use their knowledge resources for problem solving Several of these themes will come up again in later modules in this course. But by way of introduction to the subject, let's take a look at some views of how knowledge works. Read and review each of the lectures in Frost’s Knowledge Management site to gain a good understanding of KM and its relation to data, information, and knowledge. Frost,...
Words: 1369 - Pages: 6
...Introduction to Information Technology Assessment of Fundamental Competencies Model Paper 50 marks – 1 hour 30 minutes Instructions to Candidates: (i) Select the most appropriate answer from the options available for each question. (ii) There will be no negative marking for incorrect replies. (iii) Each question is of one mark. 1. Which of the following statements about operating system is correct? (a) It controls the operation of all software including application software. (b) It provides systems security. (c) It provides the graphical user interface between the user and the computer. (d) All of the above. The main purpose of the secondary storage device is to: (a) increase the speed of computer (b) take backup (c) share the data on networking (d) store data If you want every student to input his roll number and scan his finger for attendance, you need to have a combination of: (a) Keypad, Mouse, OCR Scanner and Monitor (b) Touch Screen and Biometric Scanner (c) Touch Screen and Keypad (d) Mouse, Monitor and Biometric Scanner Which of the following DOS commands will display the IP address of your computer? (a) comp_ip (b) ip_config (c) ipconfig (d) configip In MS Windows, which of the following utility programs provides most appropriate way of deleting unnecessary files and freeing up space on the hard disk? (a) Disk defragmenter (b) Task manager (c) Disk cleanup (d) Check disk Which of the following syntaxes is correct for using VLOOKUP in MS Excel? (a) VLOOKUP(table_array...
Words: 2503 - Pages: 11
...Excel 2007 Formulas and Functions For additional help with this or other software programs, contact the Center for Teaching and Learning (ctl@mcmail.maricopa.edu) 480-461-7690 Mesa Community College Christine Held 1 This manual was created using excerpts from Introduction to Excel 2002, created by the Technology Training Services department at the Maricopa Community College District Office. Other portions of this manual were created by Christine Held, BPC/CIS Faculty at Mesa Community College. Some picture excerpts were supplied by Thomson-Course Technology 2007. Some text and pictures were inserted directly from the Microsoft Excel Help feature. Mesa Community College Christine Held 2 Learning Objectives: Adding Comments to Cells Absolute vs. Relative Cell References Creating multiple worksheets and adding 3D references Creating Conditional formatting Grouping Worksheets Date Functions Using If Functions Naming Ranges Round Function Using Min, Max and Average functions Auditing Formulas Mesa Community College Christine Held 3 Review Exercise: Create the following worksheet 1. Create the following worksheet and used the formulas as displayed below. Name the sheet “Quarter 1”. 2. Save as Quarterly Budget. Formulas to be used: Mesa Community College Christine Held 4 ADDING COMMENTS TO CELLS Excel has a useful feature call COMMENTS. The comments are notes attached to a specific cell in a worksheet....
Words: 2652 - Pages: 11
