MS Excel courses City of London

...documents is addressed to people who want to learn the secrets of the composition of PDF documents Form of conduct Exercise preceded by a lecture teacher... Learn about: Ms Office, Power Point, MS Excel...

...how not to over-clutter slides, and what to focus on in a sales deck. Sales slide deck what to do before starting to design a slide deck, what to include... Learn about: Ms PowerPoint, MS Excel, Confidence Training...

...etc. Creating a software bot A simple screen recording software bot A simple web recording software bot Using the software bot to automate Excel processes Reading... Learn about: Database training, MS Excel, Business Process...

...files Accessing Databases Selecting, inserting, updating and deleting data Generic database API based on SQLite 3, PostgreSQL and MySQL Using the Object... Learn about: XML training, Ms Word, Operating System...

...elements Correcting data items to allow for automatic processing Locating required information in CRS XML Schema Financial data that needs to be reported... Learn about: Financial Training, XML training, MS Excel...

...preparing publications on several devices customize graphics for systems related content automasking, wrap graphics path in enrobing and masking sections... Learn about: MS Excel...

...demonstration how bioinformatics improves biologists lives. The course is designed and aimed for people without computer science background who want to learn programming... Learn about: C programming, Data Mining, Network Training...

...This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions... Learn about: Visual Basic, Visual Basic training, MS Excel...

...object Statusbar Timer List object Events Events with application object Arrays Dynamic arrays Arrays optimization Multidimensional arrays Arrays and objects... Learn about: MS Excel, Object oriented Programming, Object oriented training...

...facilities Create and modify toolbars Options excel (autosave, input, etc.). Options paste special (transpose) Formatting (style, format painter)... Learn about: MS Excel, Database training, Data analysis...

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

...functions Conditional formatting and SmartArt Conditional formatting with graphics SmartArt graphics... Learn about: MS Excel, Microsoft Excel, Financial Training...

...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: Microsoft Excel, Data analysis, Confidence 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, Visual Basic, MS Excel...

...Views caching Optimizing query Exporting views data Exporting data to Microsoft Excel (CVS) Exporting data to Microsoft Word document Extra Modules Views... Learn about: Microsoft Excel, Advanced Programming, Web servers...

...This course guides delegates through series of methodologies, frameworks and algorithms which are useful when choosing how to predict the future based on historical data. It uses standard tools like Microsoft Excel or some simple Open Source programs. Suitable for: This course has been created... Learn about: Data Collection, MS Excel, Market Research...

...basic Drupal and CCK knowledge required. No programming knowledge is required. Course review: Drupal views overview Creating a view Filtering a view Exposing... Learn about: Applications architecture, MS Excel, Ms Word...

...(Correlated Observations) Pairwise Comparisons (Correlated Observations) Exercises Power Introduction Factors Affecting Power Why power matters Exercises... Learn about: IT Law, MS Excel, Confidence Training...