Introduction to Excel and Visual Basic for Excel - UNIGE
[Pages:44]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
Excel and Visual Basic for Excel Excel: Basics
Outline
1 Excel, what is it? 2 Excel: Basics 3 Macro and Visual Basic (VBA) programming
18/9/2013gr 5/26
Excel and Visual Basic for Excel Excel: Basics
Spreadsheet
Rows, indexed by numbers (1,2,3,...)
Columns, indexed by letters (A,B,C,...)
Cell, intersection of a column (ex B) and a row (ex 3)
Reference Address
18/9/2013gr 6/26
of a cell: Column letter and row number (ex B3), of a table (range): B2:D5
Excel and Visual Basic for Excel Excel: Basics
Spreadsheet
Rows, indexed by numbers (1,2,3,...)
Columns, indexed by letters (A,B,C,...)
Cell, intersection of a column (ex B) and a row (ex 3)
Reference Address
18/9/2013gr 6/26
of a cell: Column letter and row number (ex B3), of a table (range): B2:D5
................
................
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 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