Transcription
MICROSOFT EXCEL FOR ACCOUNTANTSI-Grow Venture LtdContacts: 7998677 or visit www.businessingambia.com
www.businessingambia.comCourse OverviewCourse ObjectivesMastering Excel is essential for every professionalaccountant as it helps to improve productivity. Excel is acommon spreadsheet that can be used for performingdata analysis and presentation. It is also very useful forBy the end of the course, participants will beable to Learn advanced Excel features useful forfinance and accounting professionals suchnon-numerical applications.This course focus on sharing some of the onal using Microsoft Excel. This course isdesigned for accountants. It takes the powerful featuresof Excel and how accountants can apply them tobecome more accurate and more efficient.as data validation, conditional format, productivity VENUE : Senegambia Beach Hotel, The GambiaREGISTRATION FEE : D15,000Perform data analysis using tables, PivotTable and charts. Prepare financial statements from a trialbalance with a simple data refresh DATE : 21st – 23rd August 2019Work with Excel techniques to improvePerform What if analysis such as goalseeker, data table and scenario analysis Introduced to concept of VBA Marco toappreciate automation in ExcelRegistration athttps://businessingambia.com/registrationOr Contact us 7998677
www.businessingambia.comCourse DetailsPart A : Data Entry1. Data Entry Data Entry FormBuilt-in ListBuild a custom listData Validation (Number, List, Date range etc.)Name RangeArray (single cell, multiple cell) Getting More from Advanced FilterRemove DuplicateData SortingList Grouping or data consolidationSub-totalSpecial Paste (values, add, multiple, formatHighlight all formula (Go-To Special)Part B : Data Analysis2. Excel Functions and Formulas Relative and absolute referenceFinancial (NPV, IRR, Depreciation, loancalculation)Logical (IF, Nested IF, OR, AND, IFERROR)Text (JOIN, FIND, LEFT, MID,RIGHT,TEXT,UPPER,LOWER,CON etc.)Date and time (EOMONTH, TODAY,WEEKDAY etc.)Reference (VLOOKUP, INDEX, INDIRECT,MATCHMathematics (ABS, PRODUCT, RAND,ROUND,SUMIF, SUMIFS,SUMPRODUCT,COUNTIF, COUNTIFS)Statistic (AVERAGE, COUNT,CORRELATION, MAX)3. Data Cleaning and Filtering Auto filtering Excel ListsUsing AutoFilter OptionsUsing the Custom Criteria4. Pivot Table Creating a Pivot tableUpdating summary calculations (SUM, AVG,PCT etc.)Calculated FieldsGrouping (Manual, automatic, date)Design layoutRemove totals from PivotStyle and ThemeAnalyze ledger movementsPrepare Financial StatementsCreate a report for every customer5. What-If-Analysis Scenario ManagerGoal SeekerData Table
www.businessingambia.comPart C : Reports and VBA6. Visualising Data Using Formatting Cell styleTable styleAbout Conditional FormattingConditional Formats That Use GraphicsAbout Number FormattingCreating a Custom Number Format7. Excel Charts & Dashboard Introduction chartsTypes of chartsCreating chartsCombination chartFormatting chartsDashboards8. Let’s Use Excel Showing numbers in 1000Joining text with other informationAdd blank row after every data on the listSummary report using INDIRECT functionConvert a text to different columnsInsert header and footer to Excel pagePrinting options - Header and FooterYTD Budget extracts9. Introduction to Macro Introduction to MacroRecord first MacroWrite the first MacroAdd to a keyboard shortcut or ribbon10. Q & A
www.businessingambia.comCourse FacilitatorEbrima Sawaneh is a Fellow of Association of Chartered Certified Accountants (FCCA) with over 14 yearsaccounting and finance experience in top commercial and investment banks such as Guaranty Trust Bank,Ecobank, etc. He currently works as Associate Vice President, Finance Division of an Africa focus infrastructureinvestment bank based in Lagos.He has taught accounting, banking and finance courses at the Management Development Institute (MDI) and othertertiary institutions in the Gambia for more than five years. Ebrima has also delivered lectures on Personal Finance,Financial Management, Corporate Governance, Microsoft Excel and Financial Modelling across West Africa.An Amazon international bestselling author and toastmaster, Ebrima is the Founder of I-Grow Venture, aconsultancy, training and financial solution provider. I-Grow Venture owned the Gambia’s premier business &personal finance blog www.businessingambia.comEbrima also holds a bachelor’s degree (Hons) in Applied Accounting from Oxford Brookes University, a Master’s inBusiness Administration (Finance) from the Edinburgh Business School and a Certified Islamic Finance Executive(CIFE).
Ecobank, etc. He currently works as Associate Vice President, Finance Division of an Africa focus infrastructure investment bank based in Lagos. He has taught accounting, banking and finance courses at the Management Development Institute (MDI) and other tertiary institutions in the Gambia for more than five years. Ebrima has also delivered .
