I live in Setúbal, Portugal. I work with Excel for more than 10 years. This tool is so powerful and complete that I'm still learning to work with it. Everyday I discover new fixtures and ways of doing things in Excel.
I'm an active member of the Experts Exchange Community forums. where I’ve more than 1,600 questions answered. I try to help others solve their problems in Excel and also in other tools, mainly Microsoft tools (Access, Outlook, Visual Basic .Net, Powerpoint).
I'm also a Microsoft Office Specialist. I'm a self-taught person but I'm also taking a degree in Information Systems Management.
I started writing this blog to share with others what I've learned over the years that I use Excel and with the experience in problem solving that I've got from my participation on Excel forums. Hope that you recognize the work I've done here.
I started writing this blog to share with others what I've learned over the years that I use Excel and with the experience in problem solving that I've got from my participation on Excel forums. Hope that you recognize the work I've done here.
Several articles published on other websites:
Microsoft Excel Blog:
Using multiple criteria in Excel Lookup formulas: http://blogs.office.com/b/microsoft-excel/archive/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas.aspx
Pplware (Tech page from SAPO Portuguese portal — articles in PT):
VLOOKUP Function : http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-7/
Create random numbers lists: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-9/
Add totals to stacked bar chart: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-11/
Financial functions: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-13/
Fill empty cells: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-17/
Move, Copy and Paste techniques: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-e-ao-domingono-pplware-18/
Create Chart Templates: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-e-ao-domingono-pplware-19/
Add data to an existing Chart: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-20/
Use Named Ranges: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-22/
SUMPRODUCT, SUMIF and SUMIFS functions: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-e-ao-domingono-pplware-23/
How to handle dates in a chart: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-e-ao-domingono-pplware-25/
Protect a worksheet: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-ao-domingono-pplware-28/
Set PrintArea dynamically: http://pplware.sapo.pt/tutoriais/dicas-do-microsoft-excel-e-ao-domingono-pplware-34/
VLOOKUP Week:
Cascading Validation Lists: http://vlookupweek.wordpress.com/2012/03/27/jp-pinto-cascading-validation-lists-w-vlookup/
Winner of the VLOOKUP Week: http://blogs.office.com/b/microsoft-excel/archive/2012/04/11/great-white-shark-award.aspx
Programar Magazine (article in PT):
Excel PowerPivot as a BI tool: http://www.portugal-a-programar.org/revista-programar/edicoes/download.php?e=34&t=site~
Several tips & tricks videos published on Microsoft knowledge sharing site:
120segundos.net (Videos in PT): http://120segundos.net/videos/pesquisa?q=excel