Microsoft Office brings support for Visual Basic for Applications (VBA) macros back to the Mac. But if you haven’t used VBA before, you might be wondering what you can actually use it for and how ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...