698 Money Management Tools courses

Duration 3 Days 18 CPD hours This course is intended for Report Authors Overview What is IBM Cognos Analytics ? Reporting Examine dimensionally modelled and dimensional data sources Examine personal data sources and data modules Examine List reports Aggregate measure/fact data Use shared dimensions to create multi-fact queries Add repeated information to reports Create crosstab reports Create complex crosstab reports Format, sort, and aggregate data in a crosstab report Create discontinuous crosstab reports Create Visualization reports Add business logic to reports using IBM Cognos Analytics ? Reporting Focus reports using filters Focus reports using prompts Augment reports using calculations Extend report functionality in IBM Cognos Analytics - Reporting Customize reports with conditional formatting Conditionally format one crosstab measure based on another Drill-through definitions Enhance the report layout Use additional report building techniques This offering provides Business and Professional Authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity. What is IBM Cognos Analytics - Reporting? Create a simple list report Create a report from a dimensionally modeled relational data source Examine personal data sources and data modules Upload personal data Upload custom images Use navigation paths Create a report from a personal data source Examine list reports Group data in a list Format columns in a list Include headers and footers in a list Enhance a list report Aggregate measure/fact data Identify differences in aggregation Explore data aggregation Use shared dimensions to create multi-fact queries Create a multi-fact query in a list report Add repeated information to reports Create a mailing list report Create crosstab reports Add measures to a crosstab Data sources for a crosstab Create a simple crosstab report Create complex crosstab reports Add items as peers Create crosstab nodes and crosstab members Create a complex crosstab report Format, sort, and aggregate data in a crosstab Sort, format, and aggregate a crosstab report Create discontinuous crosstab reports Present unrelated items using a discontinuous crosstab Create a visualization report Create and format a visualization report Create a report that uses a Map visualization Show the same data graphically and numerically Focus reports using filters Apply filters to a report Apply a detail filter on fact data in a report Apply a summary filter to a report Focus reports using prompts Create a prompt by adding a parameter Add a value prompt to a report Add a Select & search prompt to a report Create a cascading prompt Augment reports using calculations Add calculations to a report Display prompt selections in the report title Customize reports with conditional formatting Create a multilingual report Highlight exceptional data and conditionally render a column Drill-through definitions Let users navigate to related data in IBM Cognos Analytics Enhance report layout Create a report structured on data items Create a condensed list report Use additional report building techniques Section a report and reuse objects within the same report Reuse layout components in a different report Explore options for reports that contain no data Additional course details: Nexus Humans B6158 IBM Cognos Analytics - Author Reports Fundamentals (v11.0.x) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the B6158 IBM Cognos Analytics - Author Reports Fundamentals (v11.0.x) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for Before taking this course delegates should already be familiar with basic analytics techniques, comfortable with basic data manipulation tools such as spreadsheets and databases and already familiar with at least one programming language Overview This course teaches delegates who are already familiar with analytics techniques and at least one programming language how to effectively use the programming language for three tasks: data manipulation and preparation, statistical analysis and advanced analytics (including predictive modelling and segmentation). Mastery of these techniques will allow delegates to immediately add value in their work place by extracting valuable insight from company data to allow better, data-driven decisions. Outcomes: After completing the course, delegates will be capable of writing production-ready R code to perform advanced analytics tasks enabling their organisations make better, data-driven decisions. Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. These programming languages are some of the most powerful and flexible tools in the data analytics toolkit. Topic 1 Intro to our chosen language Topic 2 Basic programming conventions Topic 3 Data structures Topic 4 Accessing data Topic 5 Descriptive statistics Topic 6 Data visualisation Topic 7 Statistical analysis Topic 8 Advanced data manipulation Topic 9 Advanced analytics ? predictive modelling Topic 10 Advanced analytics ? segmentation

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals. Overview ?Understand common Analysis Services solutions.?Understand version changes of SSAS from 2008-2014.?Understand Analysis Services installation and architecture.?Understand how to choose the right model.?Understand the Analysis Services tools available.?Understand the multidimensional model.?Utilize data sources and data source views.?Create a cube.?Understand and utilize dimensions.?Understand and utilize attributes.?Understand and utilize relationships.?Understand and utilize hierarchies.?Understand and utilize measures and measure groups.?Understand and utilize calculated members.?Understand and utilize perspectives.?Understand and utilize translations.?Browse perspectives and translations.?Understand and utilize deployment options.?Understand and utilize processing strategies.?Understand and utilize security.?Deploy a multidimensional model.?Understand the tabular model.?Create a tabular project.?Analyze the data using Microsoft Excel.?Create and configure calculated measures and calculated fields.?Backup and Restore. This course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. Course Overview Introduction Course Materials Facilities Prerequisites What We'll Be Discussing Lab 1: Course Overview Introduction to Microsoft SQL Server Analysis Services Common Analysis Services Solutions Version Changes of SSAS from 2008-2014 Analysis Services Installation and Architecture: One Product, Two Models Choosing the Right Model Analysis Services Tools Lab 1: Introduction to Microsoft SQL Server Analysis Services The Multidimensional Solution Understanding the Multidimensional Model Utilizing Data Sources and Data Source Views Creating a Cube Lab 1: The Multidimensional Solution Dissecting with Dimensions Developing Dimensions Utilizing Attributes Relating with Relationships Handling Hierarchies Lab 1: Dissecting with Dimensions Managing Measures Measures and Measure Groups Calculated Members Lab 1: Managing Measures Configuring Cube Options Understanding Perspectives Utilizing Translations Browsing Perspectives and Translations Lab 1: Configuring Cube Options Deploying Examining Deployment Options Processing Strategies Exploring Security Lab 1: Deploying The Tabular Solution Understanding the Tabular Model Creating a Tabular Project Deploying Browsing the Model Querying the Solution and Understanding DAX Maintaining and Optimizing Lab 1: The Tabular Solution

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Overview This comprehensive course on Financial Modeling Using Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Modeling Using Excel comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Financial Modeling Using Excel. It is available to all students, of all academic backgrounds. Requirements Our Financial Modeling Using Excel is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 9 lectures • 01:31:00 total length •Welcome to the Course! Get the Overview of What You'll Learn: 00:04:00 •Planning your Financial Model: 00:09:00 •Building a Model Template: 00:12:00 •Projecting the Income Statement: 00:13:00 •Projecting the Balance Sheet: 00:17:00 •Projecting Cash Flows: 00:14:00 •Advanced Financial Modeling: 00:14:00 •BONUS LESSON: Top 5 Excel Features for Financial Modellers: 00:08:00 •Resources - Financial Modeling Using Excel: 00:00:00

Overview This comprehensive course on Excel Pivot Tables will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Pivot Tables. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 18 lectures • 00:47:00 total length •Excel Pivot Tables: 00:03:00 •Overview about Store Dataset: 00:02:00 •Data Insights: 00:02:00 •Sales Profit Summary: 00:03:00 •Highlight the Data: 00:01:00 •Unprofitable Products: 00:02:00 •Create Crosstabs: 00:02:00 •Select Regions for Unprofitable Products: 00:04:00 •Real Time Analytics and Insights: 00:02:00 •Search Data for States with Slicers: 00:06:00 •Finding Trends: 00:02:00 •Find Data for Specific Date: 00:04:00 •Reporting Made Easy: 00:02:00 •Generate Reports with Pivot Tables: 00:04:00 •Marketing Analytics: 00:02:00 •Target Your Advertisements: 00:05:00 •Become Analyst: 00:01:00 •Assignment - Excel Pivot Tables: 00:00:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Description: Microsoft Excel 2016 and VBA continues Velsoft's in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Excel 2016 and VBA is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Excel 2016 and VBA is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Developing Macros Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 and VBA 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 and VBA 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for New administrators, business analysts or report writers who are new to creating reports or dashboards within Salesforce. Overview A student in this class will learn the basic Salesforce object model, and how to create and secure reports and dashboards. The instructor will lead students through exercises to create tabular, summary, matrix and join reports. Students will learn advanced reporting functionality such as charting, report summary fields, bucket fields, conditional highlighting, advanced report filters and building custom report types. Finally, the student will learn how to create and run dashboards and schedule and email reports and dashboards. This course is specifically designed to teach administrators, business analysts or report writers how to utilize the basic and advanced analytic capabilities of Salesforce. Introductions / Login to Training OrgsOverview of Salesforce Object ModelTabular, Summary, Matrix, Join ReportsCharts, Bucket Fields, Report Summary Fields, Conditional HighlightingCustom Report TypesDashboardsReport & Dashboard Scheduling Additional course details: Nexus Humans Introduction to Salesforce.com Analytics - Building Reports and Dashboards training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to Salesforce.com Analytics - Building Reports and Dashboards course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.