KCR Learning Solutions

KCR Learning Solutions

Learning solutions for around the office

  • Home
  • Courses
  • Dashboard
  • Notifications
  • Sign In

Excel Flash Fill

April 22, 2019April 22, 2019 KCR Posted in ExcelTagged Flash FillLeave a Comment on Excel Flash Fill
View Article

The Basics: SUM, COUNT, MAX, And MIN

April 21, 2019April 22, 2019 KCR Posted in ExcelTagged COUNT, MAX, MIN, SUMLeave a Comment on The Basics: SUM, COUNT, MAX, And MIN
View Article

EMT1100 – Cross Tabulated Lookup

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged IF, INDEX, ISNUMBER, MATCH, SUMPRODUCTLeave a Comment on EMT1100 – Cross Tabulated Lookup

…

View Article

EMT1099 – Compare 2 Lists with Semi-colon Discrepancies

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged ISNUMBER, MATCH, SUBSTITUTELeave a Comment on EMT1099 – Compare 2 Lists with Semi-colon Discrepancies

…

View Article

EMT1098 Compare Two E-mail Lists with Formula: E-mail In List? Not In List?

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged ISNA, ISNUMBER, MATCH, NOTLeave a Comment on EMT1098 Compare Two E-mail Lists with Formula: E-mail In List? Not In List?

…

View Article

EMT1097 AND & OR Criteria Together for Counting, Adding, Conditional Formatting

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged AND, Conditional Formatting, COUNTIFS, OR, SUMIFS, SUMPRODUCTLeave a Comment on EMT1097 AND & OR Criteria Together for Counting, Adding, Conditional Formatting

…

View Article

EMT1096 Extract Date from Middle of Description, Better Formula

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged MID, SEARCH, SUBSTITUTELeave a Comment on EMT1096 Extract Date from Middle of Description, Better Formula

…

View Article

EMT1095 Count Doubles & Triples Using FREQUENCY function

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged COUNT, COUNTIF, FREQUENCYLeave a Comment on EMT1095 Count Doubles & Triples Using FREQUENCY function

…

View Article

EMT1094 Wildcards for Sheet References and INDIRECT function

April 13, 2019April 22, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged INDIRECTLeave a Comment on EMT1094 Wildcards for Sheet References and INDIRECT function

…

View Article

EMT1093 Extract Date from Middle of Description

April 13, 2019April 22, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged LEFT, REPLACE, SEARCH, SUBSTITUTE, Text To ColumnsLeave a Comment on EMT1093 Extract Date from Middle of Description

…

View Article

Posts navigation

Older posts
Newer posts

Popular Topics

Advanced Filter AND Array Formula COLUMN Conditional Formatting COUNT COUNTA COUNTIF COUNTIFS Database DATE GETPIVOTDATA IF INDEX INDIRECT ISEVEN ISNA ISNUMBER ISODD LEFT LOOKUP Macro MATCH MEDIAN MID MIN MMULT MOD MODE MONTH NOT OFFSET OR PowerPivot ROW ROWS SEARCH SUBSTITUTE SUM SUMIF SUMIFS SUMPRODUCT TEXT VBA VLOOKUP

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

My Tweets
KCR Learning Solutions
Don`t copy text!