Browse Jelen, Bill
1144 out of 144 article(s)
Title 
Type 
Date 
Words 
EXCEL: HACK FOR FILTERING A PIVOT TABLE. 

Oct 1, 2020 
1169 
STOCK AND EXCHANGE RATE HISTORY. 

Aug 1, 2020 
932 
Excel: OFFICE 365 ADDS CUTOUT PEOPLE AND MORE. 

Jul 1, 2020 
885 
REUSE LOGIC WITHIN A FORMULA. 

Jun 1, 2020 
825 
SHARING A PIVOT TABLE SLICER BETWEEN MULTIPLE DATA SETS. 

May 1, 2020 
876 
Excel: YEAROVERYEAR CHANGES IN A PIVOT TABLE: Creating a yearoveryear statistic in a pivot table generally requires a bit of trickery. I've used various methods over the years, each requiring some additional manipulation. For example, if you changed the shape of the pivot table, additional work was needed. Recently, I was introduced to a more robust and flexible method. 

Apr 1, 2020 
851 
COMBINING ALL WORKSHEETS IN A WORKBOOK. 

Mar 1, 2020 
893 
A PIVOT TABLE WITH DATA FROM DIFFERENT WORKSHEETS. 

Feb 1, 2020 
917 
SENDING FEEDBACK TO THE EXCEL TEAM. 

Jan 1, 2020 
875 
ASK EXCEL A QUESTION ABOUT YOUR DATA. 

Dec 1, 2019 
914 
COLLABORATION IN AN EXCEL WORKBOOK. 

Nov 1, 2019 
830 
THE NEW XLOOKUP FUNCTION. 
Guest commentary 
Oct 1, 2019 
958 
Excel: CONVERTING UNITS OF MEASUREMENT. 

Sep 1, 2019 
808 
BRUTEFORCE SOLVING. 

Aug 1, 2019 
972 
CLUSTERED COLUMN CHART WITH PERCENT OF MONTH. 
Column 
Jun 1, 2019 
926 
WILDCARDS IN VLOOKUP AND SHFS. 

May 1, 2019 
813 
ROLLING 12 MONTHS IN A PIVOT TABLE. 

Apr 1, 2019 
880 
Excel: PIVOT TABLE BY WEEKDAY AND MONTH. 
Instructions 
Mar 1, 2019 
1155 
FILTER FASTER. 

Feb 1, 2019 
963 
Excel: STOCK DATA IN EXCEL: Office 365 subscribers will notice a new Stocks data type appearing on the Excel data tab. With it, you can get current data from the internet related to companies from 60 different stock exchanges around the world. Using formulas, you can keep track of their latest stock price, trading volume, and other information. 

Jan 1, 2019 
861 
Excel: NEW GEOGRAPHY DATA TYPE. 

Dec 1, 2018 
849 
Excel: DYNAMIC ARRAY FUNCTIONS. 
Column 
Nov 1, 2018 
1060 
COMMENTS AND NOTES. 

Oct 1, 2018 
864 
SURVEYS IN EXCEL. 

Sep 1, 2018 
889 
EXCEL: POWER QUERY MAKES TASKS EASIER. 

Aug 1, 2018 
810 
A CHECKLIST SYSTEM USING ICON SETS: At a Power Excel seminar for IMA's Gulf South Council recently, I was demonstrating how to use the Conditional Formatting Icon Sets to indicate if a value is up, flat, or down, when one of the members in attendance, Jack Whipple, shared his method for using a custom Icon Set to keep track of his accounting close checklist. 

Jun 1, 2018 
778 
CONSOLIDATIONS IN EXCEL. 

May 1, 2018 
937 
Excel: USING TEXTJOIN WITH AN ARRAY. 

Apr 1, 2018 
860 
Excel: ARTIFICIAL INTELLIGENCE COMES TO EXCEL. 

Mar 1, 2018 
959 
Excel: CELL SELECTION AND DESELECTION. 

Feb 1, 2018 
889 
USE HELPER CELLS TO IMPROVE FORMULA SPEED. 
Guest commentary 
Jan 1, 2018 
882 
Excel: CREATING TABLES FROM TIMELINE SLICERS. 

Dec 1, 2017 
838 
SPLIT DELIMITED DATA INTO NEW ROWS. 

Nov 1, 2017 
842 
THE PITFALLS OF AUTOSAVE. 

Oct 1, 2017 
810 
Excel: sorting with VBA. 

Jun 1, 2017 
898 
The function arguments dialog and nested functions. 

May 1, 2017 
781 
Setting pivot table defaults. 

Apr 1, 2017 
850 
Finding journal entries not in balance. 

Mar 1, 2017 
858 
When "identical" cells don't match. 

Jan 1, 2017 
853 
Excel: using an alternate calendar. 

Dec 1, 2016 
820 
Moving subtotals to a new column. 
Column 
Nov 1, 2016 
821 
Interactive reports with Power BI. 

Oct 1, 2016 
783 
Colorcoding values. 

Aug 1, 2016 
877 
Using custom lists with the fill handle. 

Jul 1, 2016 
827 
Excel: array formulas in conditional formatting. 

Jun 1, 2016 
847 
Sentiment analysis. 

May 1, 2016 
816 
Excel: six new functions. 

Mar 1, 2016 
820 
Excel: shortening a Vlookup. 

Feb 1, 2016 
930 
Combining many CSV files. 

Jan 1, 2016 
840 
Excel: pivot tables and custom numbers. 
Column 
Dec 1, 2015 
793 
Excel poorly formatted dates. 

Nov 1, 2015 
884 
Excel: what's new in excel 2016. 

Oct 1, 2015 
915 
Cash flow waterfall charts in Excel 2016. 

Sep 1, 2015 
877 
Visualizing positive and negative changes. 

Aug 1, 2015 
873 
Excel: iterating a function 359 times. 

Jul 1, 2015 
885 
Toplevel budget vs. detaillevel actuals. 

Jun 1, 2015 
896 
Excel creating territories: the Group Selection feature in pivot tables makes it possible to group the results of branch offices into territories, but the process is timeconsuming and needs to be repeated with every new pivot table. An improvement to Excel 2013 simplifies creating territories. 

May 1, 2015 
782 
Replacing nested if statements with VLOOKUP. 

Apr 1, 2015 
878 
Excel: noncontiguous selections. 

Mar 1, 2015 
769 
Charting bad data with paste special links. 

Feb 1, 2015 
823 
Bullet points in microsoft excel. 

Jan 1, 2015 
818 
Simpler conditional formatting. 

Dec 1, 2014 
789 
Gathering totals from worksheets of various size. 

Nov 1, 2014 
786 
Excel 2013 pivot tables offer distinct count. 

Oct 1, 2014 
800 
Excel: unpivot data using power query. 

Sep 1, 2014 
924 
Copy the status bar statistics. 

Aug 1, 2014 
889 
Collaborate in real time. 

Jul 1, 2014 
939 
Add a date and time stamp. 

Jun 1, 2014 
849 
Leveraging excel for the iPad. 

May 1, 2014 
954 
Excel: data validation in excel. 

Apr 1, 2014 
979 
Using a slicer to zoom in. 

Mar 1, 2014 
790 
Better depreciation method using index. 
Column 
Feb 1, 2014 
789 
Nested functions and the function arguments dialog box. 

Jan 1, 2014 
714 
Adjusting yearly formulas. 

Dec 1, 2013 
782 
Excel: sorting AZ won't speed up VLOOKUP by itself. 

Nov 1, 2013 
1018 
Counting workdays in nonstandard workweeks. 

Oct 1, 2013 
891 
Extracting matching records with an array formula. 

Sep 1, 2013 
1000 
Excel: office mobile for the iPhone and iPad. 

Aug 1, 2013 
958 
Mark an invoice paid using a picture lookup. 

Jun 1, 2013 
768 
Imagine a clip art gallery for data. 

May 1, 2013 
930 
Excel: calculating loan amortization. 
Statistical data 
Apr 1, 2013 
1004 
A DSUM, DMAX, DMIN on every row. 

Mar 1, 2013 
854 
Add Excel sorting, filtering, and charting to your web pages. 

Feb 1, 2013 
875 
Try Excel 2013. 

Jan 1, 2013 
910 
Excel 2013 solves the twomonitor problem. 

Dec 1, 2012 
792 
Charting improvements in Excel 2013. 

Nov 1, 2012 
845 
Create a leaderboard in Excel. 

Aug 1, 2012 
926 
Don't fear the AutoSum! 

Jul 1, 2012 
913 
VLOOKUP variations. 

May 1, 2012 
1214 
Excel on the iPad. 

Apr 1, 2012 
857 
Calculating delivery dates in excel. 

Mar 1, 2012 
835 
Counting values within a range. 

Feb 1, 2012 
814 
Monitoring key metrics using the watch window. 

Jan 1, 2012 
827 
Excell: cash flow waterfall chart. 

Dec 1, 2011 
786 
Saving custom functions in an AddIn Workbook. 

Nov 1, 2011 
962 
Data visualization tricks. 

Oct 1, 2011 
992 
Evaluating difficult formulas. 

Sep 1, 2011 
711 
Check every date between two dates. 

Aug 1, 2011 
857 
Frequency distribution. 

Jul 1, 2011 
621 
Using sparklines to visualize your data. 

Jun 1, 2011 
709 
 