Applied Microsoft Excel (shortly called App-XL) is strictly an application of Spreadsheet tech book with problems applications in the field of Business, Finance, Economics, and Statistical works. The key topics are -Data Analysis and Management tools, -Financial and Investment Analyzes, -Basic Statistics in Economic and Business Application, -Advance Statistics for Data Analysis of Research works, -Resources Optimization with MS Excel, including others. The key FUNCTIONS and TOOLS are: -Pivot Table, and Chart for table data analysis and management, -Solver for Linear Programming, -Analysis Toolpak for advance statistical works, -Basic Statistics tools for Measure of Central Tendency and Dispersion, -Data Analysis with chart, Slope and Intercept for Market Equilibrium Analysis, Finance, and -Investment tools like DDB, SNL, SYD, FV, PMT, IPMT, PPMT, PV, RATE, IRR, and NPV. It is prepared for MS Excel Users (MEUs) and MS Excel Beginners (MEBs). The name "Applied" is associated with the book due to its attribute of personal practical and real world work Applications in Statistics, Economics, Business, and Finance. It is very friendly in use, consists community (i.e. forums) technical support, open to all MEUs and MEBs, and as well been accompanied with App-XL Solution Pack 1.0.0 downloadable zip file.
About the Author: By profession, N. Stephen is into development practices with specialty in the area of Monitoring and Evaluation (M&E), which has exposed him into microsoft office, database development, data management and analysis. He is an authority in Economics, University of Port Harcourt, and has acquired trainings with many institutes like USAID, John Hopkins Bloomberg School of Public Health auspices (conduct in Global eLearning Center), EvalPartner, UNICEF, and others in his chosen career; M&E. He has a very strong background in information technology (I.T.), and as well can tutor and work with in advance MS Office, Open-Office.org, and other advancce software like SPSS, Cspro, Epi-Info, Dev-Info, including MS Outlook. He can as well give services in System software maintenance, WordPress Services, et cetera. For the passed 13 years and even until now, he spends almost 10 hours of his time everyday in figuring out things in computer, both in online and offline. Those been around him knew that even at home, he spent time mostly writing, conducting research online, studying, volunteering online, creating or developing a project. He is the developer of PTTM (Project Trend Time Manager); an MS Access customization that can help Project Managers manage the time trend of their projects. In working, and worked experience, Stephen is presently the Head of Services (HoS), and stakeholder in Space-Era Data Services of Work Data Group, which runs online data services to individuals and organizations in order to help them accomplish their goals in data management and analysis. Formerly, institutes like IPC-IG of UNDP Brazil, UNICEF of Nigeria, and TechCeFacos NGO of Cameroon cannot forget his worked experience with them. However, returning to his country (Nigeria) his recognition is not missing over there, as he is a member of Monitoring and Evaluation Network of Nigeria (MENN), and Nigeria Institute of Management.