Spreadsheet work can present what seems like unavoidable data entry tasks, but thankfully there are often ways to avoid or at least minimize drudgery. In this presentation author and Excel expert David H. Ringstrom, CPA, empowers you to work smarter rather than harder. You’ll learn how to use AI in Excel to convert pictures or PDF into editable data, and to combine or separate data into columns. David will show how to use worksheet functions to transform text, as well as how to use the Text to Speech command to have Excel read your data entry aloud to you so that you can cross-check it efficiently back to the original source.
Topics Covered:
• Transforming text by way of Excel’s UPPER, LOWER, PROPER, and TRIM functions.
• Combining words or other text together by concatenating.
• Converting an array or range of cells to a single string of text.
• Merging columns within an Excel worksheet together with Power Query.
• Separating first/last names into two columns without using formulas or retyping.
• Creating an in-cell list by way of Excel’s Data Validation feature.
• Double-checking manual inputs easily by having Excel read numbers aloud to you.
Learning Objectives:
• State which feature in Excel allows you to combine two or more columns together.
• State which version(s) of Excel offer the ability to extract data from PDF files by way of Power Query.
• State the functionality that the Flash Fill feature offers.
Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/