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
- excel practice spreadsheet
- excel 2016 formulas and functions
- guide to excel proficiency exercises
- intermediate excel formulas and other tips and tricks
- microsoft excel advanced towson university
- formulas functions in microsoft excel
- basic formulas in excel georgetown isd
- introduction to excel and visual basic for excel
- microsoft excel 2019 formulas and functions
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