![]() Separating first/last names into two columns without using formulas or retyping.Exploring the pros and cons of merging cells in spreadsheets.Learning how to recover unsaved workbooks.Locating data anywhere within a spreadsheet by way of the Find feature.Learning two different ways to insert or delete rows and columns within a worksheet.Contrasting Paste as Values with normal pasting in Excel.Who should attend: Professionals seeking to learn or refresh the basics of working with Excel spreadsheets. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.Įxcel for Microsoft 365 is a subscription-based product that receives periodic feature updates. ![]() David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. You'll also learn techniques such as merging cells, finding data, tracing formulas, sorting lists, and recovering unsaved workbooks.ĭavid is the author of “Exploring Microsoft Excel's Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features”. ![]() David will explore the nuances of copying and pasting in Excel, which is different than in other programs. You'll learn how to duplicate Excel worksheets to save time, as well as create a fallback position. This presentation by Excel expert David Ringstrom, CPA, builds on the discussion in part 1 of his two-part series on spreadsheet basics. *approximate length: 45 minutes to 1 hour There is just too much information to pack into one day. Have you signed up for Part 1 yet? Part 1 is always the best place to start in this much needed 2-Part Series.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |