Excel Training - Basic - 2021 Spring

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.

Kapnick Center for Business Institutions

Excel Basics Workshop for Northwestern Undergraduates

<h2>THIS WORKSHOP IS FOR NORTHWESTERN UNIVERSITY STUDENTS ONLY.</h2><h3>*All cancellations must be processed by Tuesday, April 20 @ 12:00 PM (CDT) to receive a refund (Eventbrite fees are non-refundable).*</h3><h3>This workshop will be held using Zoom. We will add you to the Canvas page for the workshop prior to April 22nd. </h3>

In the Excel Basics course you will learn the following (and more!):Terminology <ul><li>Values vs. Labels </li><li>Text vs. Numbers </li><li>What is a worksheet? </li><li>Workbook/ file contents &amp; limitations </li></ul>Grand Tour of the Excel Environment<ul><li>File tab</li><li>Tabs, Ribbons, Button, &amp; Dialog boxes</li><li>Uses of a Spreadsheet program</li></ul>Basic Math or Calculations in Excel<ul><li>Turning an Excel cell into a calculating machine</li><li>Formulas vs. Built-in Functions</li><li>Order of Operations - PEMDAS</li><li>Absolute vs. Relative Referencing </li><li>Sum Function &amp; using the Autosum Button - Σ</li><li>Additional commonly used built-in Functions: Count, Average, Min and Max</li></ul>Formatting – give the report a professional look <ul><li>Font Size, Font typeface, Font Color, Cell Alignment (horizontal and vertical), Word-wrapping </li><li>Format Numbers and Dates for readability </li><li>B, I, U – Additional text format options for emphasis</li><li>Borders, Cell Shading &amp; Indent options</li><li>Format as a table – what that does to the range or array of cells</li></ul>Create Column, Bar &amp; Pie charts (2-D/3-D)<ul><li>Format charts with themes and styles</li><li>Change location – on worksheet / on chart sheet </li></ul>Protect a workbook<ul><li>Enable a password and lock cells to prevent unauthorized changes</li></ul>Print settings<ul><li>Common Print Settings with Headers &amp; Footers</li><li>Manual Page Breaks &amp; Page Break View</li></ul>Common clean-ups: The "why" and the how <ul><li>Unmerge cells</li><li>Quickly resize all columns and clear all formatting but leave cell values</li><li>Copy &amp; Paste Values to unlink</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel Training - Basic - 2021 Spring

More events from Kapnick Center for Business Institutions

Follow organizers to get events picked for you

Excel Training - Basic - 2021 Spring

More events from Kapnick Center for Business Institutions

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.