Introduction to Excel and Visual Basic for Excel
Excel and Visual Basic for Excel
Introduction to Excel and Visual Basic for Excel
Gilbert Ritschard
Department of economics, University of Geneva
Master in International Trading, Commodity Finance and Shipping
18/9/2013gr 1/26
Excel and Visual Basic for Excel
Outline
1 Excel, what is it? 2 Excel: Basics 3 Macro and Visual Basic (VBA) programming
18/9/2013gr 2/26
Excel and Visual Basic for Excel Excel, what is it?
Outline
1 Excel, what is it? 2 Excel: Basics 3 Macro and Visual Basic (VBA) programming
18/9/2013gr 3/26
Excel and Visual Basic for Excel Excel, what is it?
Excel, what is it?
Excel is a spreadsheet Interactive table (rows and columns) for managing and exploring data.
Allows Computation (arithmetic and other mathematical and statistical functions) Simple data management
(sort and filter according to one or several keys alphabetic order, dates, values, ...)
Organizing and presenting tables (frame, totals, rows, columns) Graphical rendering of numerical data
(but most often requires data preprocessing)
18/9/2013gr 4/26
Excel and Visual Basic for Excel Excel, what is it?
Excel, what is it?
Excel is a spreadsheet Interactive table (rows and columns) for managing and exploring data.
Allows Computation (arithmetic and other mathematical and statistical functions) Simple data management
(sort and filter according to one or several keys alphabetic order, dates, values, ...)
Organizing and presenting tables (frame, totals, rows, columns) Graphical rendering of numerical data
(but most often requires data preprocessing)
18/9/2013gr 4/26
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- about the tutorial
- guide to excel proficiency exercises
- formulas functions in microsoft excel
- creating a grade sheet with microsoft excel
- excel formulas and functions for dummies cheat sheet
- advanced formulas and functions in microsoft excel
- excel creating basic formulas handout
- introduction to excel and visual basic for excel
- microsoft excel advanced towson university
- more excel 2007 formulas maxwell school of citizenship
Related searches
- visual basic for excel examples
- visual basic for beginners excel
- introduction to finance and accounting
- microsoft visual basic for excel
- visual basic for beginners pdf
- introduction to leadership and management
- introduction to language and linguistics
- introduction to leadership and governance
- introduction to excel 2016 pdf
- introduction to philosophy and logic
- introduction to positive and negative numbers
- visual basic for beginner