Learn how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can’t be recorded. Learn how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Short on time? Make sure to check out the “Top Ten Shortcuts” and “Ten Tiny Tips” chapters for a quick productivity boost. The course then steps through the crucial new features in each of the major applications-Word, Excel,Ĭreate formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Includes an overview of the new features and improvements to Office 2013, including the new interface, Touch mode, and cloud storage and computing features. Migrating from Office 2010 to Office 2013 The top 5 things that have changed in Excel 2013.Flash Fill, new in Excel 2013, allows you to fill out data based on an example.Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells. Most trainings have an audio component, so be sure to wear headphones or turn up your speakers. Microsoft offers a series of 15-60 minute online training courses that can be completed from your desk at your own pace. Visit Microsoft’s Help and How-to Site to get started.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |