Professional Excel
20/12/2015
9 สิ่งควร(ต้อง)รู้(จัก) กับ Pivot Table! คุณคิดว่า 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
How to vlookup values across multiple worksheets? 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
Learn Excel In Hindi Learn Excel in Hindi. Take Free Excel Course in Hindi and English.
21/06/2015
Top 10 Excel Productivity Tips
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
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)
Excel Tutorial – Ctrl P is Power in Control (Printing) | PakAccountants.com 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…
22/02/2015
Tom’s Tutorials For Excel: Lookup Oldest and Newest Date
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.
รับออกแบบ Excel Report ให้ใช้งานง่ายสะดวก ติดต่อทาง inbox ได้เลยค่ะ
22/02/2015
Select Data to Display in an Excel Chart With Option Buttons
Select Data to Display in an Excel Chart With Option Buttons - Peltier Tech Blog This tutorial shows how to let a user control the displayed data in a chart using option buttons in the worksheet.
VLOOKUP: What it is, and when to use it.
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.