KINGEXCEL.INFO: Mr King Excel Tips

Showing posts with label Mr King Excel Tips. Show all posts

LET: Storing Variables Inside Your Excel Formulas

May 04, 2020

LET: Storing Variables Inside Your Excel Formulas Formulas in Excel are already a programming language. When you build a model in Excel, ...

Excel 2020: Simultaneously Edit the Same Workbook in Office 365

March 16, 2020

Excel 2020: Simultaneously Edit the Same Workbook in Office 365 For decades, some people have been wanting a better way to have mul...

Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring

March 14, 2020

Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring The reason that co-authoring is possible is because of Aut...

Bill's "How Would You Clean This Data" Challenge

March 14, 2020

Bill's "How Would You Clean This Data" Challenge When I do a live Power Excel seminar, I offer that if anyone in the ...

Excel 2020: Old Style Comments Are Available as Notes

March 14, 2020

Excel 2020: Old Style Comments Are Available as Notes While the new threaded comments are cool, there are some great tricks that ...

Excel 2020: Add a Tooltip to a Cell with Validation

March 12, 2020

Excel 2020: Add a Tooltip to a Cell with Validation The problem with notes: it is possible to arrow in to a cell without ever hovering...

Excel 2020: Create Perfect One-Click Charts

March 12, 2020

Excel 2020: Create Perfect One-Click Charts One-click charts are easy: Select the data and press Alt+F1 . What if you would ...

Excel 2020: Paste New Data on a Chart

March 12, 2020

Excel 2020: Paste New Data on a Chart You might be responsible for updating charts every month, week, or day. For example, in my la...

Excel 2020: Create Interactive Charts

March 12, 2020

Excel 2020: Create Interactive Charts It is easy to create interactive charts without using VBA. By default, if you hide rows in Excel...

Excel 2020: Show Two Different Orders of Magnitude on a Chart

March 12, 2020

Excel 2020: Show Two Different Orders of Magnitude on a Chart It is nearly impossible to read a chart where one series is dramatically la...

Excel 2019: Turn Data Sideways with a Formula

January 27, 2020

Excel 2019: Turn Data Sideways with a Formula Someone built this lookup table sideways, stretching across C1:N2. I realize that I ...

Subscribe to: Posts ( Atom )

LET: Storing Variables Inside Your Excel Formulas

Excel 2020: Simultaneously Edit the Same Workbook in Office 365

Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring

Bill's "How Would You Clean This Data" Challenge

Excel 2020: Old Style Comments Are Available as Notes

Excel 2020: Add a Tooltip to a Cell with Validation

Excel 2020: Create Perfect One-Click Charts

Excel 2020: Paste New Data on a Chart

Excel 2020: Create Interactive Charts

Excel 2020: Show Two Different Orders of Magnitude on a Chart

Excel 2019: Turn Data Sideways with a Formula

Trang

Pages

Trang

Top Post

Random Posts

Recent Comments

Popular Posts

Search This Blog

About Me

Total Pageviews

Translate

About me

Popular Posts

Popular Posts

Bài đăng phổ biến

Recent Posts

Bài đăng phổ biến

Random Posts

Bài đăng phổ biến

Popular Posts