MANAGING LISTS IN EXCEL WITH PIVOT TABLES AND SUBT 2016 - Excel - Managing Lists and Databases - By Compliance Global Inc
View: 244
Website https://www.complianceglobal.us/product/700627/MikeThomas/excel-managing-lists-&-databases/1 |
Edit Freely
Category Finance;Business;Accountants;Banking
Deadline: December 13, 2016 | Date: December 13, 2016
Venue/Country: online, U.S.A
Updated: 2016-11-10 20:39:06 (GMT+9)
Call For Papers - CFP
Overview :If you think that Excel is all about working with numbers then think again. More and more people are turning to Excel managing lists & databases, to help them to manage list-based and tabular data.In many cases they receive, download or import data from elsewhere and before that data can be used within their business and treated as a credible source of information, it needs be seriously checked and cleaned - duplicate entries, non-printing characters, extra spaces and capitalisation inconsistencies are all-too-often present in downloaded and imported data. In this Excel training webinar, you'll learn how to deal with and fix all these issues.Why Should You Attend :You'll also learn about managing list and tabular based data in terms of sorting (into different orders), applying and saving filters (that let you display only certain items) and summarising with Excel Pivot Tables.Areas Covered in this Webinar :Sorting a column or row of items into orderSorting a list of date-based items into orderFiltering a list to display only certain itemsSaving a filter for re-useLearning Objectives :The benefits of TablesSummarising a list with Pivot Tables and Excel SubTotal ReportsCleaning up imported/ downloaded dataAdvanced Excel features like importing and linking to non-Excel dataManage lists in ExcelExcel sorting and filteringWho Will Benefit :CFO/Controllers Investment Analysts / Financial Analysts / Business Analysts Forecasting & Planning PersonnelMergers & Acquisitions Specialists Risk ManagersStrategic Planners / Capital Expenditure PlannersCost Accountants / Managerial AccountantsAny User of Excel who wants to learn how to create form-driven applications and spreadsheetsFor more information, please visit : https://www.complianceglobal.us/product/700627/MikeThomas/excel-managing-lists-&-databases/1Email: supportcomplianceglobal.us Toll Free: +1-844-746-4244Tel: +1-516-900-5515Level: BeginnerSpeaker Profile :Mike Thomas has worked in the IT training business since 1989. His expertise and experience covers creating and delivering training courses, writing training materials and recording and editing video-based tutorials. He is a subject matter expert in a range of Microsoft technologies and has also worked extensively with Mac OSX and Mac-related software since 2006, however, his passion is for all-things-Excel. Mike is a Fellow of ‘The Learning and Performance Institute’ and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Keywords: Accepted papers list. Acceptance Rate. EI Compendex. Engineering Index. ISTP index. ISI index. Impact Factor.
Disclaimer: ourGlocal is an open academical resource system, which anyone can edit or update. Usually, journal information updated by us, journal managers or others. So the information is old or wrong now. Specially, impact factor is changing every year. Even it was correct when updated, it may have been changed now. So please go to Thomson Reuters to confirm latest value about Journal impact factor.