Spreadsheet Resources & Guides
Here you will find a list of the blogs and article groupings available on the site, starting with our primary blog, which is quite Excellent if we don’t say so ourselves! Followed by our spreadsheet focused blog segments.
Excellency Blog
Excel and google sheets Functions and How to Use Them!
-
Date and Time
- Feb 20, 2020 The DATE function
- Feb 21, 2020 The DATEVALUE function
- Feb 22, 2020 The DAY function
- Feb 23, 2020 The DAYS function
- Feb 24, 2020 The EDATE function
- Feb 25, 2020 The EOMONTH function
- Mar 1, 2020 The HOUR function
- Mar 15, 2020 The MINUTE function
- Mar 18, 2020 The MONTH function
- Mar 19, 2020 The NETWORKDAYS function
- Mar 21, 2020 The NOW function
- Apr 1, 2020 The SECOND function
- Apr 10, 2020 The TIME function
- Apr 11, 2020 The TIMEVALUE function
- Apr 12, 2020 The TODAY function
- Apr 15, 2020 The WEEKDAY function
- Apr 16, 2020 The WEEKNUM function
- Apr 17, 2020 The WORKDAY function
- Apr 18, 2020 The YEAR function
- Apr 19, 2020 The YEARFRAC function
-
Information
- Apr 20, 2020 The ISBLANK function
- Apr 21, 2020 The ISERROR function
- Apr 22, 2020 The ISEVEN function
- Apr 23, 2020 The ISFORMULA function
- Apr 24, 2020 The ISLOGICAL function
- Apr 25, 2020 The ISNONTEXT function
- Apr 26, 2020 The ISNUMBER function
- Apr 27, 2020 The ISODD function
- Apr 28, 2020 The ISTEXT function
-
Logical
- Feb 9, 2020 The AND function
- Mar 2, 2020 The IF function
- Mar 3, 2020 The IFERROR function
- Mar 4, 2020 The IFS function
- Mar 20, 2020 The NOT function
- Mar 23, 2020 The OR function
- Apr 7, 2020 The SWITCH function
-
Lookup and reference
- Feb 13, 2020 The COLUMN function
- Feb 14, 2020 The COLUMNS function
- Feb 29, 2020 The HLOOKUP function
- Mar 5, 2020 The INDEX function
- Mar 9, 2020 The LOOKUP function
- Mar 10, 2020 The MATCH function
- Mar 22, 2020 The OFFSET function
- Mar 29, 2020 The ROW function
- Mar 30, 2020 The ROWS function
- Apr 14, 2020 The VLOOKUP function
-
Math and trigonometry
- Apr 4, 2020 The SUM function
- Apr 5, 2020 The SUMIFS function
- Apr 6, 2020 The SUMPRODUCT function
-
Statistical
- Feb 10, 2020 The AVERAGE function
- Feb 11, 2020 The AVERAGEA function
- Feb 12, 2020 The AVERAGEIFS function
- Feb 16, 2020 The COUNT function
- Feb 17, 2020 The COUNTA function
- Feb 18, 2020 The COUNTBLANK function
- Feb 19, 2020 The COUNTIFS function
- Feb 28, 2020 The FREQUENCY function
- Mar 6, 2020 The LARGE function
- Mar 11, 2020 The MAX function
- Mar 12, 2020 The MEDIAN function
- Mar 14, 2020 The MIN function
- Mar 16, 2020 The MODE.MULT function
- Mar 17, 2020 The MODE.SNGL function
- Mar 25, 2020 The QUARTILE.EXC function
- Mar 26, 2020 The QUARTILE.INC function
- Apr 2, 2020 The SMALL function
-
Text
- Feb 15, 2020 The CONCAT function
- Feb 26, 2020 The EXACT function
- Feb 27, 2020 The FIND function
- Mar 7, 2020 The LEFT function
- Mar 8, 2020 The LEN function
- Mar 13, 2020 The MID function
- Mar 24, 2020 The PROPER function
- Mar 27, 2020 The REPLACE function
- Mar 28, 2020 The RIGHT function
- Mar 31, 2020 The SEARCH function
- Apr 3, 2020 The SUBSTITUTE function
- Apr 8, 2020 The TEXT function
- Apr 9, 2020 The TEXTJOIN function
- Apr 13, 2020 The TRIM function
Excel Courses and Guides
Excel Beginners Level
Excel Beginners Guide 1: Navigating Excel - Step 1 To Mastering Spreadsheets
Excel Beginners Guide 2: Data Types And Formatting - Step 2 To Mastering Spreadsheets
Excel Beginners Guide 3: Intro To Formulas - Step 3 To Mastering Spreadsheets
Excel Beginners Guide 4: Keyboard Shortcuts - Step 4 To Mastering Spreadsheets
Excel VBA
Excel VBA Guide 1: Introduction to Visual Basic For Applications - Macros and Automation Part 1