Printer Friendly

Browse Jelen, Bill

1-144 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: YEAR-OVER-YEAR CHANGES IN A PIVOT TABLE: Creating a year-over-year 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
BRUTE-FORCE 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
Color-coding 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
Top-level budget vs. detail-level 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 time-consuming 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 A-Z 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 two-monitor 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 Add-In 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

Terms of use | Privacy policy | Copyright © 2020 Farlex, Inc. | Feedback | For webmasters