Excel Training - Basic - 2017 Fall
Date and time
Location
Technological Institute #MG51
2145 Sheridan Road #MG51 (Wing M, Ground Floor) PC Computer Lab Evanston, IL 60208Refund Policy
Description
EXCEL Basics for Business Institutions
In the EXCEL Basics course you will learn the following (and more!):
- Tour of application, values versus labels, what is a worksheet, workbook/file
- How to set up a simple formula-adding, subtracting, multiplying, dividing order of operations
- How to copy formulas across cells, including how to hold a specific part of the formula constant using the “$” absolute referencing
- How to sum up a group of cells with the sigma sum and autosum button (also count, average, min and max)-how it works and the pitfalls of not verifying the range selected automatically
- How to format a column to fit a longer caption, including making the cell height bigger and using the wrap-around text feature – formatting – size, font, color, alignment (Horizontal and vertical), word wrapping
- How to use bold, italics, centering, right and left justify. Formatting
- How to use borders to underline, double underline, etc. formatting borders and shading
- How to set up appropriate page breaks, manual breaks, page break view and print setting with headers and footers
- How to format with $ or %. Number (and date formatting)
Organized by
The Minor in Business Institutions offered by the Harvey Kapnick Center for Business Institutions is designed to provide Northwestern undergraduates with a rigorous introduction to business and management fundamentals. The minor is open to all Northwestern undergraduates regardless of major or home school. The minor allows them to build on the set of skills and knowledge they have acquired through other Northwestern coursework to prepare for employment in the business world. It also allows students to connect their study of business and management fundamentals to broader areas of academic inquiry both by linking the study of principles of business and management to the social science scholarship that these principles are based on and by introducing students to social science and humanities scholarship on the cultural, political, philosophical, literary and social aspects of business institutions. Therefore, the minor is not meant to serve as narrowly conceived pre-professional training. Instead the minor offers a broad multi-disciplinary perspective on a significant area of inquiry in 21st century society. Students without extensive quantitative training are particularly encouraged to apply. The minor is designed so that such students can acquire the necessary quantitative background by completing four basic prerequisite courses in mathematics, statistics and economics.