Excel'lent

20/12/2015

คุณคิดว่า Pivot Table ไม่ค่อยเวิร์คหรือเปล่าครับ? ถ้าใช่ แสดงว่าคุณคือ 1 ใน 2 ประเภทนี้ เจอเคสยากจริงๆ การสรุปข้อมูลของแต่ละแถวต้องใช้ตรรกะต่างกัน หรือต้องจัดฟอร์แมตแบบซับซ้อน คุณยังไม่ได้ทำความรู้...

05/07/2015

เทคนิคลับสุดยอด VLOOKUP ข้อมูลเร็วขึ้น 100 เท่า!!!

21/06/2015

http://www.extendoffice.com/documents/excel/2450-excel-vlookup-in-multiple-sheets.html

To use this array formula, you should give these three worksheets a range name, please list your worksheet names in a new worksheet, such as following screenshot shown:

21/06/2015

http://www.myelesson.org/

Learn Excel in Hindi. Take Free Excel Course in Hindi and English.

21/06/2015

Top 10 Excel Productivity Tips

Excel is used by more than 500 million people around the world and only 5% really know how to use its full suite of tools. In this post I will show you the top 10 Excel productivity tips that you need to know in order to complete your tasks much quicker within Excel, so you can go home a tad bit...

21/06/2015

save chart template

Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template. So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it seconds.

21/06/2015

Ctrl P is Power in Control (Printing)

Yeah I know even a child with rock bottom skills know how to print. But Excel's print is not just a Ctrl + P. Its this and much more. One of the nuisance often encountered by excel users is to print same headings on each page of every print. Or what if your data has overflown from print area i.e. ei…

03/04/2015

http://www.inwexcel.com/formula/

22/02/2015

Tom’s Tutorials For Excel: Lookup Oldest and Newest Date

The picture shows one way of obtaining the oldest and newest dates in column B that correspond to the person’s name in column A that is in cell D2 as a lookup criteria. Because dates are numbers, you can use the MIN function for the oldest date, and the MAX function for the newest date.

22/02/2015

รับออกแบบ Excel Report ให้ใช้งานง่ายสะดวก ติดต่อทาง inbox ได้เลยค่ะ

22/02/2015

Select Data to Display in an Excel Chart With Option Buttons

This tutorial shows how to let a user control the displayed data in a chart using option buttons in the worksheet.

14/02/2015

VLOOKUP: What it is, and when to use it.

You may have heard of the VLOOKUP function, and you may have heard reasons why you should use it. But what does it do, exactly? In this training course, get hands-on practice using VLOOKUP.