Introduction to Excel - Learn Basics

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Automate your workflow and analyze your data with Excel Training Advanced Excel training will lessen the amount of time you spend doing repetitive tasks.  There are more productive ways to work and this Microsoft Excel Advanced class (Level 3) will show you how the right way to get started. In this Excel training, you will learn how to automate...

This three-hour session for Windows and Mac users teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, write arithmetic formulas by hand, parse text strings with the LEFT, MID, RIGHT and SEARCH functions, and perform calculations on dates. You will use HLOOKUP and VLOOKUP to retrieve data based...

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Students must have MS Office Excel software installed on their computer to participate in class. Learn how to create advanced formulas and...

Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced...

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Version Note While this class is being taught using the 2016 version of the Excel software, almost all topics will be applicable...

Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks Viewing,...

Learn Excel to edit and manipulate your spreadsheets This Advanced Excel Class focuses solely on solving complex problems with your data. We will walk you all the way through the basics of formula creation to advanced logical and look-up functions. Learn Excel with our hands-on training in this Advanced Excel class – Formulas & Functions. You...

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have...

In this certificate, students will learn how to use Python to pull, clean, analyze, visualize, and eventually predict off financial data.  This program prepares students for entry-level positions in data science and financial technology as well as upskills any financial analyst.  Master Advanced Python to Analyze Financial Data ...

This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...

In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, database summarization functions, and dynamic array functions. You will also become expert at using mixed...

In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart...

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. The Level 1 class provides all the basics for creating and editing spreadsheets and workbooks and performing simple calculations. Students must have MS Office Excel software installed on their computer to participate in class. Target Student: This...

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service. Audience profile: The course is individuals who are not IT professionals but need to easily create and publish...

In this three-hour session for Windows users only, you will import external data and create queries using Power Query to bring in data from external sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting...

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment,...

Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables. Target Student The course is for individuals who are responsible managing data and creating PivotTables in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline...