Free Webinar on Basic Skills in the Digital Age
Data Consolidation Using Microsoft Excel: Some Case-Study Demonstrations
Presented by Venkataraman Anantharaman, PhD (Founder, The Art of Copyediting)
Who can attend?
- Anyone handling a team at any level and has a need to summarize data
- Anyone interested in learning the simple but powerful possibilities with Microsoft's flagship product, Excel.
The background
- The presenter will use a commonly encountered scenario—the situation he found himself in, quite early in his career—and use that as a starting point for the entire presentation
- Everything that will be presented was live at some part in the presenter's work-life, and will therefore be proof of concept
Overview
- Basic features of Excel that one can learn step by step
- A free offering—and a practical method—to help people learn Excel
- Example of a hypothetical scenario and the setting up of a tracking sheet
- Using some of the features of Excel during the setting up of the tracking sheet
- Theoretical indication of the reports that can be imagined for the hypothetical scenario
- Showcasing of over a dozen consolidated reports that can be generated from the simple tracking sheet
- Indication of the possibilities of data consolidation from a single data sheet
- Formatting of tables for better presentation
- Some examples of how the presenter uses Excel in his daily life (unconnected with the world of production!)
Focus
- The focus of the webinar will be on using simple, logical thinking to build what we need from a single Excel sheet in any given situation
- The focus will NOT be on which formulae are to be used and why—these are things that one will always need time to learn
If this is your first sign-up for an Art of Copyediting webinar, you will be asked to confirm your email (please check your email Inbox or Spam folder) before you are sent a registration confirmation email.
Hurry! Space is limited.