Discover the full potential of Microsoft Excel with online classes led by industry experts. Learn the ins and outs of functions, formulas, data analysis, and automation to become a spreadsheet pro and boost your career prospects.
64 classes have spots left
This is the second course in TLG Learning’s exclusive Power BI for Excel 2013 training series. This course builds on the foundation set in the Power BI for Excel Report Builders course. In this course students will learn how to use the Power View, Power Map, and Power Query add-ins. Power BI Report Writers will learn how to use Power View to create highly effective interactive reports using data models created by more advanced Power BI Designers. ...
This is the second course in our exclusive Power BI for Excel 2016 training series. This course builds on the foundation set in the Power BI for Excel Report Builders course. In this course students will learn how to use the Power View, Power Map, and Power Query add-ins. Power BI Report Writers will learn how to use Power View to create highly effective interactive reports using data models created by more advanced Power BI Designers. Students...
New York City College of Technology @ Virtual Learning, New York, NY
Microsoft Excel is a spreadsheet program that is used by business, management, and financial departments to create tables, columns, and rows in order to present financial information and other data for analysis and decision making. (MS Office Suite 2010) Note: Price Includes $20 Registration Fee
Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Explore private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Excel Private Group EventsThe main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. This course is based on the objectives of the course version 20779B. Course Objectives Explore and extend a classic Excel dashboard Explore and extend an Excel data model Pre-format and import a .CSV file Import...
Data analysis has never been easier than learning Excel PivotTables through Microsoft Excel Training Microsoft Excel PivotTables and PivotCharts are amazing tools to help you analyze large amounts of data. Instead of wasting valuable time with standard Excel look-up features, PivotTables allow you to do quick, easy grouping, summarizing, and filtering of your data. In addition, the formatting features turn a boring report into a professional one...
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 will learn how to manipulate text data, use dates in formulas, calculate complex statistical problems,...
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help...
In this Level 1 series of Excel 2010, you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets. Excel 2010: Level 1 Course Objectives create a basic worksheet by using Microsoft Excel 2010. perform calculations in an Excel worksheet. modify an Excel worksheet....
New York City College of Technology
This advanced Excel course focuses on PivotTables, and VLOOKUP, tools that are used to analyze, summarize and reorgaize data in a table helping organizations to focus on information patterns. Related courses: Intro to Tableau and Data Analytics and Visualization. Prerequisites: Microsoft Excel Beginning Software: Free version of Office 365 https://www.microsoft.com/en-us/microsoft-365 Required Textbook: Learn Microsoft Office...
This course is for individuals responsible for taking data and turning it into powerful business intelligence solutions. With Power Query you can transform data (by reducing, adding columns, and combining data sets) so that it is setup for additional analysis. Power Query makes “data munging” and “data wrangling” easy for non-programmers working as data scientists. This course takes an in-depth approach to the Power Query and will provide...
This bootcamp is an excel class that is designed to provide beginner participants with a general overview of Excel topics and specifically a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and large amount of topics covered, beginner participants are expected to be able to learn quickly. The bootcamp is designed for participants...
New Horizons Computer Learning
In this course, students will create, edit, and enhance Pivot Tables and Pivot Charts using Microsoft Office Excel 2010. Course Outline Understanding PivotTables and PivotCharts Building a PivotTable Manipulating Your PivotTable Changing the PivotTable View Filtering a PivotTable Customizing PivotTable Fields Creating a PivotTable Options Setting PivotTable Options Performing...
Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data. Excel 2016 is also Excel for Office 365. Pre-requisite(s): Excel Level 2 Outline: Lesson 1 : Logical and statistical...
Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data. Pre-requisite(s): Excel Level 2 Outline: Lesson 1 : Logical and statistical functions Logical functions ...
Chicago Computer Classes @ Online Learning
WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great refresher!
The Level 1 course explained how to create and manage simple workbooks and worksheets and to perform simple calculations and apply basic formulas The Microsoft Office Excel 2016: Level 2 course introduces learners to the more advanced features of Excel 2016. NetCom Learning provides in-depth coverage of the more advanced Excel 2016 features with comprehensive Microsoft Office Excel 2016 training. The Excel 2016 online training and Instructor-Led...
After learning the fundamentals of Excel 2013 in the Level 1 course, the Excel 2013 Level 2 course prepares candidates to work with large worksheets, and manage multiple workbooks effectively. This program builds on the foundational knowledge developed through the Excel 2013 introduction course. Learn the basics of Excel 2013 Level 2 at NetCom Learning and develop the proficiency to create advanced worksheets to analyze vast amounts of data and...
In Microsoft Excel level 2, you will use advanced formulas and work with various data analysis tools to get more from your spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of complex workbooks by integrating graphical objects. Course Objectives use advanced formulas organize worksheet and table data using various techniques create and modify charts analyze data using PivotTables, Slicers,...
In this Level 3 series of Excel 2010, students will learn how to use some advanced features to work with different types of reports. Students will look at some productivity tools to increase data entry, features to enable collaboration with others, and use various commands to analyze large numerical reports. Students who complete this course can be on their way to preparing for a Microsoft Office Specialist exam. By completing the other levels available...
The Microsoft Excel for Office 365: Dashboards course is designed for simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your...
Try removing some filters.
Excel Classes Online are rated 4.3 stars based on 2,779 verified reviews from actual CourseHorse.com purchasers.
More in Microsoft Office
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.