Printer Friendly

Browse Jelen, Bill

1-155 out of 155 article(s)
Title Type Date Words
CLEAN DATA WITH GET & TRANSFORM. Oct 1, 2021 897
Excel: SMOOTH SCROLLING FOR LARGE CELLS. Sep 1, 2021 899
SHOW CHANGES DEBUTS. Aug 1, 2021 872
USING A SLICER ON A DASHBOARD. Jul 1, 2021 776
Excel: CALCULATIONS BASED ON VISIBLE ROWS. Jun 1, 2021 948
IS EXCEL'S ROUNDING SKEWING DATA? May 1, 2021 830
USE SEQUENCE TO LOOP THROUGH CHARACTERS. Apr 1, 2021 868
ENCAPSULATE COMPLEX FORMULAS IN LAMBDA. Mar 1, 2021 795
FORMAT NUMBERS WITH FLASH FILL. Feb 1, 2021 880
Excel: ADD YOUR OWN LINKED DATA TYPE. Dec 1, 2020 872
EXCEL PERFORMANCE IMPROVEMENTS. Nov 1, 2020 916
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

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