You are here

Excel

Featured in 

The Excel for Business Series is a three part series that aims to tackle the most common and practical uses of Excel in business, from basic data entry and navigation to advanced functions, data structures and optimizations. The "Excel Expert Certification" includes our Fundamental, Intermediate, and Advanced Excel classes, as well as the Expert Certification Exam with a free retake.

Monday, November 26, 2018 - 10:00am
Featured in 

Excel is still the go-to software for data journalists and anyone looking for trends and patterns in datasets. In this workshop, we will cover: Getting around a spreadsheet Importing data sets into Excel Types of data stories Cleaning and formatting data Some useful formulas Pivot Tables (time permitting) What to bring: You will be provided with a computer outfitted with Excel in one of our computer labs. If you have Excel on your laptop and prefer to bring it, please do so.

Saturday, November 3, 2018 - 10:00am
Featured in 

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the worlds most popular spreadsheet application. Each class will cover a topic in depth and then give students exercises that apply that knowledge to real world situations. While we recommend that students take the classes in order, there are no attendance requirements, and students are welcome to repeat or skip classes as they choose.

Wednesday, September 26, 2018 - 1:00pm
Featured in 

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data. We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements. Skills required: Know how to navigate menu options in Excel Understand formatting and conditional formatting Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the worlds most popular spreadsheet application.

Wednesday, September 26, 2018 - 10:00am
Featured in 

Learn the basics of working with spreadsheets using Microsoft Excel 2010. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets.

Wednesday, September 26, 2018 - 4:00pm
Featured in 

Learn the basics of working with spreadsheets using Microsoft Excel 2010. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets.

Wednesday, September 19, 2018 - 4:00pm
Featured in 

This ILT Series course will teach students how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables.

Tuesday, November 6, 2018 - 10:00am
Featured in 

Step by step this course explains how to start building sophisticated financial models capital investment and financing decisions. We start with Excel essentials and then move to Excel VBA (Visual Basic for Applications) programming. This Excel Macro Course assumes no previous knowledge of Macros. This basic VBA class, that will help you apply skills to build quantitative models in excel. Four projects for the course: Multiple Linear Regression Logistic Regression Monte Carlo Simulation (AR1) Scraping data from Yahoo Finance We will cover: Macros / VBA What are Macros? What is VBA?

Saturday, October 13, 2018 - 10:00am
Featured in 

This course builds off of the foundational and intermediate knowledge presented in the Microsoft Office Excel: Level 1 and Level 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.

Wednesday, September 19, 2018 - 9:00am
Featured in 

Learn the basics of working with spreadsheets using Microsoft Excel 2010. Topics include: entering data and formulas moving and copying data formatting & print previewing worksheets

Wednesday, September 26, 2018 - 4:00pm

Pages