"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS trining team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Courses


hey this is here
hey this is here

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

FURTHER DETAILS
hey this is here
hey this is here
hey this is here
hey this is here

Target student This course takes users to a high level of knowledge using financial topics available in Excel such as financial functions, auditing and charts. Prerequisites Delegates should have an understanding of any of the Windows operating system and a good understanding of Microsoft Excel or alternatively should have attended Excel level 1 and level 2 training or have equivalent knowledge.

FURTHER DETAILS
hey this is here

· Using multiple worksheets, workbooks and workspaces · Working with advanced functions · Use advanced formatting techniques · Using charts to display data · Using Excel as a Database Target student This course takes users to a high level of knowledge using multiple worksheets, charting, advanced functions and advanced formatting.

FURTHER DETAILS
hey this is here

Excel Introduction Level 1- Identify basic worksheet and workbook concepts and terms Enter and edit data Modify the worksheet Use functions to calculate and return values Format cells to enhance the appearance of your worksheet Change the page set-up to define how the printed worksheet appears

FURTHER DETAILS
hey this is here

Excel Macros/VBA (Part 2)This 1 day course builds on the MS Excel Macro/VBA (part 1). Here where we look at topics such as Forms, error Handling and Office Automation.

FURTHER DETAILS
hey this is here

Excel Macros/VBA (Part1)This course introduces users to the process of writing and editing Macros. No prior programming experience is assumed. Prerequisites Candidates should have an excellent working knowledge of Excel or should have attended the Excel L3 training. Day 2: A further 1 day course is available which builds on this training (Part1) Here where we look at topics such as Forms, error Handling and office Automation. The course can be run as a 2 day course or as separate 1 day courses. The second day course is named MS Excel Macro/VBA (part2)

FURTHER DETAILS
hey this is here
hey this is here

Excel Power BI consists of the following products – Power Query, Power Pivot, Power View, DAX (Data Analysis Expression) functions. With these tools you are able to: Import millions of rows of data from multiple data sources into a single Excel Power Pivot data model Create relationships between heterogeneous data Create calculated columns and measures using DAX functions & formulas Build Power Pivot tables and Power View charts and then further analyse the data so that you can make timely business decisions without requiring IT assistance Our 2 Day Excel Power BI training course will enable delegates to maximise the benefits of the above tools.

FURTHER DETAILS
Page 1 of 3123