Yelp Facebook LinkedIn YouTube Twitter Instagram

Classes available in-person (strict social distancing) or live online with an extended free retake period. See details.

Noble Desktop Noble Desktop
  • Coding
    • Web Development
    • Python
    • FinTech
    • Ruby on Rails
    • Summer Camps Teens
    • iOS Development
    • JavaScript
    • Data Science
    • Web Certificates
    • SQL
    • HTML Email
    • WordPress
    • Machine Learning
    • React
    • All Coding Classes & Bootcamps
  • Design
    • Graphic Design
    • Web Design
    • Photoshop
    • After Effects
    • Premiere Pro
    • InDesign
    • Illustrator
    • Video & Motion
    • Visual Design
    • UX Design
    • Sketch
    • Adobe XD
    • Photography
    • AutoCAD
    • All Design Classes & Certificates
  • Business
    • Digital Marketing
    • SEO
    • Google Analytics
    • Google Ads
    • Social Media
    • Data Analytics
    • Excel
    • Tableau
    • PowerPoint
    • Financial Modeling
    • Finance
    • Project Management
    • All Business Classes & Certificates
  • Certificates
    • Graphic Design
    • UX & UI Design
    • Motion Graphics
    • Web & Visual Design
    • Web Design
    • Digital Design
    • Visual Design
    • Front-End Web
    • Data Science
    • Digital Marketing
    • Front End & React
    • Full-Stack Web
    • FinTech
    • Python Developer
    • Software Engineering
    • Data Analytics
    • Find & Compare Certificates by Topic
  • Corporate
    • Excel
    • SQL
    • Python
    • Data Science
    • Graphic Design
    • Web Design
    • Photoshop
    • After Effects
    • Video Editing
    • Digital Marketing
    • Data Analytics
    • Adobe
    • Microsoft Office
    • Project Management
  • Compare
  • Schedule
  • Coding
    • Web Development
    • Python
    • FinTech
    • Ruby on Rails
    • Summer Camps Teens
    • iOS Development
    • JavaScript
    • Data Science
    • Web Certificates
    • SQL
    • HTML Email
    • WordPress
    • Machine Learning
    • React
    • All Coding Classes & Bootcamps
  • Design
    • Graphic Design
    • Web Design
    • Photoshop
    • After Effects
    • Premiere Pro
    • InDesign
    • Illustrator
    • Video & Motion
    • Visual Design
    • UX Design
    • Sketch
    • Adobe XD
    • Photography
    • AutoCAD
    • All Design Classes & Certificates
  • Business
    • Digital Marketing
    • SEO
    • Google Analytics
    • Google Ads
    • Social Media
    • Data Analytics
    • Excel
    • Tableau
    • PowerPoint
    • Financial Modeling
    • Finance
    • Project Management
    • All Business Classes & Certificates
  • Certificates
    • Graphic Design
    • UX & UI Design
    • Motion Graphics
    • Web & Visual Design
    • Web Design
    • Digital Design
    • Visual Design
    • Front-End Web
    • Data Science
    • Digital Marketing
    • Front End & React
    • Full-Stack Web
    • FinTech
    • Python Developer
    • Software Engineering
    • Data Analytics
    • Find & Compare Certificates by Topic
  • Corporate Training
    • Excel
    • SQL
    • Python
    • Data Science
    • Graphic Design
    • Web Design
    • Photoshop
    • After Effects
    • Video Editing
    • Digital Marketing
    • Data Analytics
    • Adobe
    • Microsoft Office
    • Project Management
    • All Corporate Training
More
  • Compare Courses
  • Class Schedule
  • Classes Near Me
  • FAQ
  • Blog
  • Workbooks
  • Free Seminars
  • NextGen Bootcamp
  • Resources
  • Student Testimonials
  • Student Showcase
  • Job Board
  • Evaluation
  • Course Catalog

Excel Blog

Free Excel Resources & Tutorials

Learn tips and tricks in Excel with these free resources and tutorials. Watch free tutorials to learn functions, read about the perks of learning Excel, and compare it to other data analytics tools with these free resources.

Thumbnail image for Python vs. Excel for Data Analytics

Python vs. Excel for Data Analytics

In this article, we'll discuss two of the most popular tools for data analytics, Excel and Python. We'll walk through how each of these tools fares across a variety of dimensions to help you with your next steps in professional development and learning.

Thumbnail image for Multiple Pivot Tables Excel

Multiple Pivot Tables Excel

Learn advanced features of Pivot Tables like adding percent totals, creating slicers, and creating multiple Pivot Tables off the same dataset. 

Thumbnail image for IF Statements

IF Statements

In this section, we’ll cover IF statements. IF statements allow you to check to see if something is true or false and then take different actions depending on which result you get.

More Excel Resources

  • Excel Consolidation

    Learn to use the Consolidate function to consolidate information across multiple sheets in Excel. 

  • Excel Macros Report

    In this video, we'll create a macro that's going to format a report that we are going to imagine we need to create every single day.

  • Excel Macros

    Learn to use Macros to help you to automate work in Excel.

  • Working Across Sheets Excel

    Learn to work across multiple sheets if you need to apply formatting or summarize calculations across multiple sheets.

  • Excel Windows

  • Excel Index Double Match

    Learn to use Index Double Match for its flexibility when we're looking up information in a table.

  • Excel Index Match

    Learn how INDEX and MATCH efficiently return a value in a row or column that matches a value in another row or column in Microsoft Excel.

  • Excel VLOOKUP and MATCH Function

    Learn to create a more accurate VLOOKUP by enhancing the determination of the column index number by using the MATCH function in Microsoft Excel.

  • Excel MATCH Function

    Learn to use the MATCH function to find the relative position in a column or a row of a lookup value in Microsoft Excel.

  • Pivot Charts Excel

    Learn how to work with Pivot charts in Microsft Excel. Pivot charts are dynamic graphical representations of pivot table data that work in tandem with pivot tables.

  • Excel Pivot Tables, Calculated Fields and Items

    In this Excel video tutorial, we'll cover Pivot Tables, Calculated Fields and Calculated Items.

  • Pivot Table Sales Report Variances 

    In this Excel tutorial, we're going to create a pivot table. In order to do this, we're going to have to use one of the Value Field Settings calculations that we have yet to begin to use.

  • Excel Conditional SUMPRODUCT

    Learn to use conditional SUMPRODUCT to extract the subset of the information that you want and exclude everything else. 

  • Excel Data Tables

    Learn to use Excel Data Tables to show the range of effects of one or two different variables on a formula.

  • Excel Goal Seek

    Learn to use Goal Seek to calculate equations in Excel.

  • Excel IF Statement with AND OR

  • Excel Nested IF Statements

    In this section, we're going to cover how you can nest multiple IF statements together to account for more than just two possibilities. 

  • Excel Advanced Conditional Formatting

    Learn to use advanced conditional formatting to format cells based on values in another location. 

  • Excel Date Functions

    In this section, we'll take a look at five Excel date functions you can use to calculate dates in the future or the total number of days between any two dates, as well as figure out the week number for the current date that you're in. 

  • Excel Hotkeys

    Learn to use a keyboard shortcut to access any commands on the ribbon on a PC.

  • Excel Go to Special

    Learn to use Go to Special to perform several time-saving tasks in your Excel spreadsheet.

  • Excel Advanced Cell Locking

    Learn to create powerful formulas by locking either a column, a row or both in Excel. 

  • Combo Charts

    Combo charts combine two or more charts into a single chart with the option of adding a secondary axis. 

  • Excel COUNTIFs and SUMIFs

    Learn to use SUMIFs and COUNTIFs to count and sum based on conditions.

  • Excel AND OR Logical Functions

    In this section, we'll take a look at how you can use the AND OR functions to test if multiple criteria are all true, or at least one of them is true. 

Contact Us

Office Hours: 9am–6pm, Mon–Fri

(212) 226-4149

Location

185 Madison Ave 3rd Floor
New York, NY 10016

Map & Directions

Win a Free Class!

Sign up to get tips, free giveaways, and more in our weekly newsletter.

Adobe Certified Training Center

© 1998–2021 Noble Desktop - Privacy & Terms