Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Excel 2010 Expert 5
By Richard Rost     10 years ago

The focus of this course is working with math and basic statistical functions in Excel. Topics covered include:

- More with the SUM function
- Calculating a Running Balance / Total
- The SUMIF and SUMIFS functions
- Counting Numeric, Blank, Non-Blank Cells
- Rounding Up, Down, and more
- Lots of Math (Median, Sqrt, Modulus, Random)
- Automatic Recalculation
- Basic Trigonometry in Excel
- Calculate the Height of a Building
- Lots More!

Jafar Abdalla
5 years ago
Hi, can you please make an video abut using trig functions in Excel? Thanks
Joe Beniacar
7 years ago
But it rounds down, while QUOTIENT removes the fractional part that would increase it above that integer...?
Anonymous
7 years ago
Is QUOTIENT the same function as INT?

No. QUOTIENT returns the integer portion of a division (the opposite of MOD). INT just rounds.
Anonymous
7 years ago
Hi Richard, can you think of some examples (+ or -) of when TRUNC is different than ROUNDDOWN (for the same num_digits)? Could they be the same function? Thanks!

Laurie J.
8 years ago
Do you have any sample tests where we can check our skills on these classes?

I used to have a whole set of tests for my older Excel 2003 lessons. I was in the process of re-writing them for 2010, but got busy with other projects. It is high on the TO-DO list.
Mubeezi Micah
10 years ago
Dear Richard,

I am fully satisfied with this tutorial. It is amazing how many math functions you demonstrate in just an hour. Keep it up!

MICAH

Start a NEW Conversation
 Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

 You may want to read these articles from the 599CD News:
 6/23/2021 Import Data 5/14/2021 Quick Queries #4 4/4/2021 Text to Columns 3/15/2021 VLOOKUP in Access 2/17/2021 Old Excel 2003 Outlines 2/17/2021 Excel Expert Outlines 2/17/2021 Excel Beginner Outlines 2/4/2021 Free Beginner Courses 12/26/2020 Import New, Changed Records 12/13/2020 Duplicates Conditional Formatting

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey
Keywords: excel sumif sumifs averageifs countifs counta round trigonometry random  Page Tag: whatsnew  PermaLink