PC Applications training

...and summarise data over multiple sheets. Calculations and Named Ranges Brief review of common functions and formulae Calculate and format dates Create... Learn about: Microsoft Excel, Excel 2013, Intermediate Excel...

...We are proud to say that Hope Tutors is a top notch WordPress Training center in Chennai. This course is designed to ensure that you learn & master... Learn about: Web Server...

...MS Word 2013 with easy to understand examples. Document appearance; Working with fonts; Paragraph formatting and spacing; Document styling; Templates and styling... Learn about: Microsoft Word, Ms Word...

...This course will ensure that participants acquire all the skills and knowledge to sync, organize, share and collaborate information within their organization... Learn about: Logical Architecture, SharePoint 2013, MCSE training...

...Work with and Nest Functions Nest functions IF with AND / OR, VLOOKUP, VLOOKUP with MATCH and INDEX/MATCH Apply DATE Functions Use and nest TEXT Functions... Learn about: Functions in Excel, Nesting functions, Text Functions...

...Making with VBA Repeating Actions in VBA Working with Arrays Working with Collections Manipulating Files & controlling Other Applications with VBA Manipulating... Learn about: Analytic Expert...

...or the Sheets mobile app in case of mobiles. Since Sheets is an online spreadsheet software, you can share and collaborate with multiple people on the same document... Learn about: Office IT, Formatting Numbers, Basic Arithmetic...

...Microsoft Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building... Learn about: CRM & Analytics, Business Data, Analyzing Business...

...Channels Create a new Channel Starting a conversation Replying Add fun elements - emotions, gifs and stickers Add files for sharing Using @ Mentions Adding... Learn about: Microsoft Collaboration, Teams training, Office 365...

...Conditional Functions & Formats and Date Calculations Benefits and purpose If Statements , Nested If And, Or, Not Combining If, And, Or, Not Sumif... Learn about: MS Excel...

...teach you how to make the most of planning and managing projects using Microsoft Project, building on your existing skills and teaching you to make... Learn about: MS Excel, Tasks and Milestones, Resource Leveling...

...It may be especially useful to Sage users who currently export data out of Sage software and into Excel. Important Note: although this course uses...

...functions, ranges, sorts, filters and formatting commands. This Course Covers: Formulae and Functions Using Absolute Cell References ‘Insert’ Function...

...Fairly experienced Excel 2007 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros. Course Contents... Learn about: MS Excel...

...such as Excel and Word, so it is a popular choice for many businesses. For example, many of the views available are similar to an Excel spreadsheet... Learn about: Project Management, IT Project Management, Text Styles...

...to creating templates and using macros. Suitable for: This one day course is aimed at anyone who wishes to utilise the more advanced features within the Excel program...

...gained by combining the built-in features of Excel with the programming capabilities of Visual Basic for Applications (VBA). Visual Basic For Applications... Learn about: Visual Basic training, Excel Sheet, Microsoft Excel...

...Window Code Window Properties Window Navigating between Excel and the VB Editor Editing Code + Methods of Executing Using the Visual Basic Editor Structure... Learn about: MS Excel...

...Time Management Create and manage folders Out of Office Assistant Meetings, appointments and events Schedule a meeting Notes, Tasks and Journals Tasks—...

...demand forecasting, - sample size determination The curriculum is delivered using practical case studies. For students, graduates, engineers... Learn about: Microsoft Excel, Pivot charts, Statistical analysis...