Facebook with Latestnigeriannews  Twieet with latestnigeriannews  RSS Page Feed
Home  |  All Headlines  |  Punch  |  Thisday  |  Daily Sun  |  Vanguard   |  Guardian  |  The Nation  |  Daily Times  |  Daily Trust  |  Daily Independent
World  |  Sports  |  Technology  |  Entertainment  |  Business  |  Politics  |  Tribune  |  Leadership  |  National Mirror  |  BusinessDay  |  More Channels...

Viewing Mode:

Archive:

  1.     Tool Tips    
  2.    Collapsible   
  3.    Collapsed     
Click to view all Features headlines today

Click to view all Sports headlines today

Business Data Analysis and Microsoft Excel in-depth training for the Workplace in Lagos and Abuja

Published by Linda Ikeji on Mon, 17 Jul 2017


Making decisions based on gut feelings is outdated. Todays managers are using Microsoft Excel and other spreadsheets to create financials models to understand the financial impact of various options available to them and run a variety of sensitivity around them. Financial modelling using Microsoft Excel enables better decision making, as it allows you to run simulations and projections faster, better and in real time.Microsoft Excel and financial modelling skills are necessary for business executives, entrepreneurs and business school students. Whether you are building a complex financial model for a hotel chain or managing your household expenses, using Excel and other spreadsheets makes your task easier.Greetings fromAlvaPRO esolutions!!!The objective of the training class is to enableprofessionals to enhance their MS Excel skills through exercise,case studies and gaining hands-on experience on varioustechniques & Tools. MS ExcelAdvanced Functions has been exclusively designed for all corporateprofessionals to hone their skills in Excel.The program covers step-by-step lessons ranging frombasic/start fundamentals likes, working with Cells & Ranges,Chartings, and Writing Iteration loop in Excel, Application of Array functions to advanced features and theirapplication in professional jobs. The course will help delegates gain ExcelProficiency-Calculations, Functions. Here youll find our curated exhibition ofExcel functions and formulas most useful in financial modelling.ProgramDeliverables: (1) A training notepad with pen and a comprehensive studymaterial (2) Practice excel worksheets and cases (3) 14hours/2days (4) Posttraining support(5) A training certificate from us (alvaPRO eSolutions, aregistered Microsoft Partner) . (6) A tea break and lunch (7) You have to bringyour laptop for the workshopWhat youlllearn(1) EssentialTrainingWewill demonstrate the core features and tools in Excel. The course introduceskey Excels skills, shows how to utilize these skills with in-depth tutorials onExcel functions and spreadsheet formatting. It also covers preparing documentsfor printing, working with large worksheets and workbooks, collaborating withothers, using Excel as a database, analyzing data, charting, and automating andcustomizing.Topics include:Copying and pasting techniquesWorking with formulas and functionsDealing with formula errorsCreating lookup tablesNaming cells rangesFormatting data and worksheetsFinding and replacing data(2) Managing and AnalyzingDataLarge amountsof data can become unmanageable fast. But the data management and analysisfeatures in Excel, you can keep the largest spreadsheet under control. At theworkshop, the trainer shares easy-to-use commands, features, and functions formaintaining large lists of data in Excel. He covers sorting, adding subtotals,filtering, eliminating duplicate data, and using Excels Advanced Filter featureand specialized database functions to isolate and analyze data. With thesetechniques, youll be able to extract the most important information from yourdata, in the shortest amount of time.Topics include:Preparing datafor analysisMultiple-key sortingSorting by rowsor by columnsSettingsingle-and multi-levels subtotalsUsing text,numeric, and date filters(3) Data ValidationWith Excel datavalidation tools, you can control users input data into workbooks and ensuredata is entered consistently and accurately. You can control the dates, thetimes, even the length of the length of text they enterTopics include:Testing forwhole numbers and decimalsUsing the inputmessage boxSequencing andplacing listsCreatingmultitiered listsSetting data andtime limitationsLimiting textlengthLocating datavalidation rulesRequiringentries to be unique(4) Pivot Tablesand Pivot ChartsYou will learnhow to use PivotTables to summarize, sort, count, and chart your data in Excel.We will show you how to navigate the complexity of PivotTables while takingadvantage of their power. This topic shows how to build PivotTables whiletaking advantage of their power. This topic shows how to build PivotTables fromsingle data, add calculated fields, fields, filter your results, and formatyour layout to make it more readable.Topics include:Formatting datafor use in a PivotTableCreating a newPivotTableConnecting todata sourcesConsolidatingdata from multiple data sourcesCreatingcalculated fieldsSummarizing fielddataSorting andfiltering PivotTablesSummarizingfield dataSorting andfiltering PivotTablesWorking andExcels slicersFormattingPivotTables with styles and formatsApplyingconditional formatsCreatingPivotCharts(5) AdvancedFormulas and FunctionsConquer some ofthe most daunting features in Microsoft Excel once and for all. We willdemystify some of the most challenging of the formulas and functions in Exceland shows how to put them to their best use. The topics start with a review ofthe more basic, building-block functions, and a few critical keyboard shortcutsthat will speed up working with Excel data, even on multiple sheets. We thencovers how to perform advanced searching and data retrieval with lookupfunctions, tabulate and sort data counting and statistical functions, formatdata with text and math functions.Topics include:Displaying andhighlighting formulasConvertingformulas to valuesCreating 3Dformulas to gather data from multiple sheetsUnderstandingthe hierarchy of operations in formulasUsing absoluteand relative references Creating andexpanding the use of nested IF statementsLooking upinformation with VLOOKUPUsing the powerfunctions: COUNTIF, SUMIF, and AVERAGEIFPerformingbasic mathEditing textwith functions(6) Time Value ofMoney and some Financial CalculationWe will show you how to perform some financial calculationsquickly and easily using some financial functions in Excel variables returnsTopics include:Analyzing loans, payments, and interestDiscovering the interest rate of an annuityFor ExampleFuture Value of Lump Sums Well begin with a very simple problem that will provideyou most of the skills to perform financial math using Microsoft ExcelAn example using compounded value approach with Excel commandsTo find the future value of this lump sum investment wewill use the FV function which is defined as FV (rate, nper, pmt, pv, type).Keep in mind that the example below does not detail the whole idea about thesubtopic. It is just to give you a fill for some Excel capabilities. Welldemystify the whole idea to you at the training, even if you are a novice.FV (rate, nper, pmt,pv,type)There 5 different types of compounding (1) Daily compounded(1) Monthly compounding (2) Quarterly compounding (3) Semi-Annual compounding(4) Yearly compound. The example below is based on yearly compounding.Suppose that youhave 500,000 to invest for a period of 5years at an interest rate of 10% peryear. How much will have accumulated at the end of this time period' In thisproblem, the 500,000 is the (PV) i.e. Present Value, NPer (No. of periods) is5, and Rate is 10%. Open a new workbook and enter the data as shown below, butleave B5 blank for now.
Click here to read full news..

All Channels Nigerian Dailies: Punch  |  Vanguard   |  The Nation  |  Thisday  |  Daily Sun  |  Guardian  |  Daily Times  |  Daily Trust  |  Daily Independent  |   The Herald  |  Tribune  |  Leadership  |  National Mirror  |  BusinessDay  |  New Telegraph  |  Peoples Daily  |  Blueprint  |  Nigerian Pilot  |  Sahara Reporters  |  Premium Times  |  The Cable  |  PM News  |  APO Africa Newsroom

Categories Today: World  |  Sports  |  Technology  |  Entertainment  |  Business  |  Politics  |  Columns  |  All Headlines Today

Entertainment (Local): Linda Ikeji  |  Bella Naija  |  Tori  |  Pulse  |  The NET  |  DailyPost  |  Information Nigeria  |  Gistlover  |  Lailas Blog  |  Miss Petite  |  Olufamous  |  Stella Dimoko Korkus Blog  |  Ynaija  |  All Entertainment News Today

Entertainment (World): TMZ  |  Daily Mail  |  Huffington Post

Sports: Goal  |  African Football  |  Bleacher Report  |  FTBpro  |  Kickoff  |  All Sports Headlines Today

Business & Finance: Nairametrics  |  Nigerian Tenders  |  Business Insider  |  Forbes  |  Entrepreneur  |  The Economist  |  BusinessTech  |  Financial Watch  |  BusinessDay  |  All Business News Headlines Today

Technology (Local): Techpoint  |  TechMoran  |  TechCity  |  Innovation Village  |  IT News Africa  |  Technology Times  |  Technext  |  Techcabal  |  All Technology News Headlines Today

Technology (World): Techcrunch  |  Techmeme  |  Slashdot  |  Wired  |  Hackers News  |  Engadget  |  Pocket Lint  |  The Verge

International Networks:   |  CNN  |  BBC  |  Al Jazeera  |  Yahoo

Forum:   |  Nairaland  |  Naij

Other Links: Home   |  Nigerian Jobs