How to Decide When to Use Worksheets & Workbooks in Excel. Part of the series: Microsoft Excel Tips. Excel workbooks are used for complicated analysis, and worksheets are for simpler Excel assignments. Learn when to use worksheets and workbooks in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.