FindNLearn

06/06/2017

Index and Match with Multiple Criteria - a Perfect Example!

https://exceljet.net/formula/index-and-match-with-multiple-criteria

To lookup values with INDEX and MATCH, using multiple criteria, you can use an array formula. In the example shown, the formula in H8 is:

05/15/2017

2016 cheat sheet

http://www.networkworld.com/article/3195741/software/excel-2016-cheat-sheet.html

Are you getting the most from Microsoft Excel 2016? Get to know the key new features.

05/01/2017

strategy: make your code more useful

https://www.intheblack.com/articles/2017/05/01/excel-make-code-more-useful

Excel’s CurrentRegion command can be used to create dynamic ranges in a macro for an advanced filter, making your code more useful and flexible.

04/13/2017

April 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in

https://blogs.office.com/2017/04/06/april-2017-updates-for-get-transform-in-excel-2016-and-the-power-query-add-in/

Excel 2016 includes a powerful set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce five new data transformation and connectivity features that have been requested by our customers. —Read on for details.

03/22/2017

Botched Windows patch KB 3178690 freezes, crashes 2010

http://www.infoworld.com/article/3182388/microsoft-windows/botched-windows-patch-kb-3178690-freezes-crashes-excel-2010.html

Microsoft admitted the problem and has stopped forcing the bad patch through automatic update, but it hasn’t pulled the update

03/06/2017

Limited Time Offer! $25 instead of $250 for any SAP End-User Training Course - Save up to 90%! Offer includes SAP FICO, MM, SD, SAP System Access Training Courses. See more using below links:

http://sapacademy.ca/course/How_to_get_FREE_SAP_System_Access
http://sapacademy.ca/course/SAP_FICO_End_User_Training
http://sapacademy.ca/course/SAP_MM_End_User_Training
http://sapacademy.ca/course/SAP_SD_End_User_Training

03/06/2017

Three Approaches for Counting Data Instances in

http://www.accountingweb.com/technology/excel/three-approaches-for-counting-data-instances-in-excel

CPA and Excel guru David Ringstrom compares using COUNTIF, COUNTIFS, and a pivot table for counting the number of instances within a dataset.

02/16/2017

Geocode your Maps data in

https://support.office.com/en-us/article/geocode-your-3d-maps-data-80da122d-048e-4b03-8736-5443fb48b862?wt.mc_id=AID600162_QSG_PD_SCL_138274

02/03/2017

If NOT this or that: function

https://exceljet.net/formula/if-not-this-or-that

01/30/2017

You can attain mastery with Microsoft Office Specialist Certification — and it only costs $15

https://thenextweb.com/offers/2017/01/25/can-attain-excel-mastery-microsoft-office-specialist-certification-costs-15/

Taken on their own, spreadsheets don’t seem inherently exciting. However, it’s hard to overstate the impact of a well-presented Excel document… an impact you’ll be able to make after going through this Microsoft Office Specialist Excel Certification course bundle. Right now, you can pick up this twi...

01/11/2017

Did you know can help you outline your novel?

http://www.writersdigest.com/online-exclusives/oct-16/use-a-spreadsheet-to-outline-your-novel

Use an Excel spreadsheet to outline your novel.

01/04/2017

Offering in Partnership with SAP Academy!

Limited Time Offer! $25 instead of $250 for an online SAP Financial Accounting & Controlling (FICO) End-User Training Course - save up to 90% - See more at: https://lnkd.in/e6SeH7N

SAP Academy is a leading provider of SAP End-User & SAP Super-User & Advanced SAP training and SAP courses. Our courses helps aspirants learn SAP MM, SAP FICO, SAP PP, SAP HR, SAP SD and much more.