Lấy dữ liệu duy nhất trong Excel.

Chào các bạn.

Hôm nay mình sẽ hướng dẫn các bạn, những cách Lọc lấy dữ liệu duy nhất trong Excel đơn giản và nhanh chóng, sử dụng những tính năng có sẵn trong Excel. 173 more words

Duy Nhất

xlCubeSuper An Excel Game Explained – Part2

In Part1, the new version of xlCube (now referred to as xlCubeSuper) was introduced.


In Part2, I will describe the different techniques to make this game application work. 202 more words


ISDA CDS in VBA - Update

Below you’ll find some code which will successfully value a CDS according to the ISDA standard model. This is only the credit piece (the yield-curve needs to have already been bootstrapped), and there is a lot more testing to do, but I wanted to share the work in progress. 3,204 more words


Making Data Visualizations

I entered the data visualization competition run by Chance Analytics. We were given a full season’s data from the Chinese Super League and told to visualize it as best as possible. 314 more words

xlCubeSuper An Excel Game Explained - Part1

I have just recently updated/modified my xlCube game that I first started on 20 years ago. The main modification is that it now has 7 cubes that must be destroyed before the game is over. 124 more words


Microsoft Office for Mac updated with real-time collaboration, auto cloud saving, and more

Microsoft on Thursday “announced a major update for Office 2016 for Mac,” Chance Miller reports for 9to5Mac. “The update brings the app to version 16 and includes new features for Microsoft’s entire suite of applications.” 152 more words