Skip to content
WebDummies – Easy to doWebDummies – Easy to do
  • Sign IN
  • Sign IN
  • Technology
    • Microsoft Excel
      • Excel Basics
      • Excel Functions
    • HTML and CSS
      • Learn Bootstrap
      • Learn Colors
      • Learn Icons
      • Learn Graphics
      • Learn SVG
      • Learn Canvas
      • Learn How To
      • Learn Sass
    • Programming
      • Learn Python
      • Learn Java
      • Learn C++
      • Learn C#
      • Learn R
  • Blog
  • Technology
    • Microsoft Excel
      • Excel Basics
      • Excel Functions

15.2 Excel Decimal Data Validation

Create the little dropdown give the users the exact values for them to pick from. Another type that I want to show up here is arrange a numeric range. I want to specify that within a column in this case within the Rate column. You can only put values 14.95...

15.1 Creating an Excel Data Validation List

I’m still on the Sort & Filter worksheet within the Excel102exercise file. Now I want to create a dropdown list, when users are entering the make value within these records. I want to give them a specific list of makes that they can choose: Ford, Chevy, Pontiac, Oldsmobile.. That way...

14.6 Excel Function: SUBTOTAL()

What the subtotal function can do for you, this is excels subtotal function. The subtotal function I’m going to F1, I started to type There’s subtotal function, it’s asking me for two things. I’ll go hit the fx button, here’s argument window. It’s got two arguments, It wants to know...

14.5 Excel Function: DCOUNT()

Now I want to get the counts, I want to know how many sales we’re done with the category of SUPPLIES. At J9 cell, I’m get a count of the sales column where the category is equal to supplies. I’m going to use the DCOUNT function because I’m going to...

14.4 Excel Function: DAVERAGE()

I’ve got my average sales at cell K2 and I’m just going to use my same criteria section. We can do And, Or statements exactly the same way that we did it with the DSUM. Let’s start out with the simple one and then I’ll give you an opportunity to...

14.3 Excel DSUM Function with AND Criteria

We’ve seen a single criteria where we’re getting where category is equal to rent, and we’ve included the software category. We’re giving total sales where category is equal to rents or software,  that was in your statement. Let’s take a look at utilizing an and statement inside of our criteria....

14.2 Excel DSUM Function with OR Criteria

We’ve got a single bit of criteria we’re summing up the total sales column where the category column is equal to “Rent”. What if you wanted to do I want to get a sum of the category for rent and or I want to get it for overhead so give...

14.1 Excel DSUM Function Single Criteria

By utilizing the DSUM function we can add criteria to the sum we’re going to say hey excel. I want to sum up the total sales but I only want to do it where the category is equal to rents, or where the categories equal to telemarketing or whatever it...

13.9 Removing Duplicates in Excel

We’ve identified the duplicates by using conditional formatting. But in many cases once you’ve identified them you then want to perform some action with those duplicates. And in this case I’m going to remove the duplicates. Remember it’s two separate steps. First you identify them using conditional formatting and in...

13.8 Using Conditional Formatting to Find Duplicates

Something speech that I want to show of here deals with duplicate records. Now once again I’ve got the example file open and I’m looking at the Employee records worksheet. In the employee records worksheet we got a list of employee information. And I just now added a couple of...

  • 1
  • 2

How to
  • Tabs
  • Dropdowns
  • Accordions
  • Side Navigation
  • Top Navigation
  • Modal Boxes
  • Progress Bars
  • Parallax
  • Login Form
  • HTML Includes
  • Google Maps
  • Range Sliders
  • Tooltips
  • Slideshow
  • Filter List
  • Sort List
Certificates
  • HTML
  • CSS
  • JavaScript
  • Python
  • SQL
  • PHP
  • And more

   

  • REPORT ERROR
  • FORUM
  • ABOUT
  • SHOP
Top Tutorials
  • JavaScript Tutorial
  • How To Tutorial
  • SQL Tutorial
  • Python Tutorial
  • Bootstrap Tutorial
  • PHP Tutorial
  • Java Tutorial
  • C++ Tutorial
  • jQuery Tutorial
Top References
  • HTML Reference
  • CSS Reference
  • JavaScript Reference
  • SQL Reference
  • Python Reference
  • Bootstrap Reference
  • PHP Reference
  • HTML Colors
  • Java Reference
  • Angular Reference
  • jQuery Reference
Top Examples
  • HTML Examples
  • CSS Examples
  • JavaScript Examples
  • How To Examples
  • SQL Examples
  • Python Examples
  • Bootstrap Examples
  • PHP Examples
  • Java Examples
  • XML Examples
  • jQuery Examples
Web Courses
  • HTML Course
  • CSS Course
  • JavaScript Course
  • SQL Course
  • Python Course
  • jQuery Course
  • PHP Course
  • Bootstrap Course
  • XML Course
  • Get Certified »

Webdummies is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using Webdummies, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2021 by webdummies. All Rights Reserved.
webdummies

  • Technology
    • Microsoft Excel
      • Excel Basics
      • Excel Functions
  • WooCommerce not Found
  • Newsletter
  • Technology
    • Microsoft Excel
      • Excel Basics
      • Excel Functions