MS Excel courses City of London

...Course Content is specially designed by the GBA facilitators with the view of provided best possible results. With the changes in the industry the course... Learn about: Financial Training, Finance in Excel, Financial Modelling...

...Page Layout options Charts Using Recommended and Standard Charts Chart Elements Chart Tools - Design & Format... Learn about: MS Excel, Visual Basic, Visual Basic training...

...error corrections Allocating cash payments and receipts Allocating bank payments and receipts Allocating supplier payments and customer receipts against... Learn about: Customer Service, Customer satisfaction, Sales Training...

...Course summary Our accounting courses were rated the best in London for personal development in the National Student Survey 2016. Overview On this Bachelor’s degree in Accounting and Finance you will learn principles of accounting and finance, while developing key skills to excel in the financial... Learn about: IT Auditing, Corporate Finance, Accounting and Finance...

...functions, and types of financial analysis to be an Excel power user. Objective Identify the key characteristics of a project. Specify the pricing calculation... Learn about: Financial Modelling, Financial Accounting, MS Excel...

...data Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions) Determining the edge... Learn about: Data analysis, Database Management, MS Excel...

...tricks to use other Excel features, for example double pie, and extracting numeric values ​​from text... Learn about: MS Excel...

...the VBA environment VB Editor Using Project Explorer Toolbox Modules Procedures and Functions Comments Principles and concepts of programming Data types... Learn about: MS Excel...

...and statistical functions Financial functions Search and data Search and matching Functions MATCH (MATCH) and INDEX (INDEX) Advanced management of lists... Learn about: Financial Training, MS Excel...

...Audience Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel. Course Objectives This course will help improve your familiarity with Excel and statistics and as a result increase... Learn about: Data analysis, Microsoft Excel, MS Excel...

...In this instructor-led, live training, participants will learn how to use Excel to optimize the reporting process for financial statements. By the end of this training, participants will be able to: Optimize the report creation process Prepare data for Pivot Tables and formula-based reports Import... Learn about: Financial Training, MS Excel, Financial Reporting...

...Advanced functions Logical functions Math and statistical functions Financial functions Lookups and data tables Using lookup functions Using MATCH... Learn about: Financial Training, Database training, MS Excel...

...application Convert text files Use of external data sources Use external libraries Excel Object Model The protection sheet from VBA Object Workbook... Learn about: Oriented Programming, Visual Basic, Object oriented training...

...Triggering Event Handlers Service frequently occurring events VBA Forms Create your own forms Calling a form from code Use the forms in the sheet... Learn about: Visual Basic training, MS Excel, Visual Basic...

...exceptions Repeated practice activity Loop Multi - instance activity The batch processing Sub-process such transactions The concept of transaction Offsetting... Learn about: MS Excel...

...test, execute, and maintain enterprise-class decision making applications. In this instructor-led, live training, participants will learn how to configure... Learn about: Decision Making, MS Excel...

...Relationship charts. MS Excel integration: importing tables, importing charts, creating new charts in PowerPoint, editing source data. PowerPoint plugins... Learn about: Ms PowerPoint, Office IT, Team Training...

...Working with Schemas Case Study and Exercise: Querying Sales Data for the Year Performing Queries on JSON Data Combining Data Types in SQL Queries Creating... Learn about: MS Excel...

...Layout Implementing Parallel Computing Using the multiprocessing Module Using Numba for Dynamic Compiling Using Cython for Static Compiling Using... Learn about: Database training, MS Excel, Microsoft excel training...

...By the end of this training, participants will know how to program in Python and apply this new skill for: Automating tasks by writing simple Python programs... Learn about: Office IT, Ms Word, MS Excel...