104 Excel Analytics courses delivered Online

COURSE OVERVIEW Use Microsoft's benchmark business application to its full potential by taking this  Advanced Excel Analytics by Real World Projects course. Using expert guidance, the contents will familiarise you with the broad range of functionalities on Excel, empowering you to deliver enhanced information analysis and accurate conclusions more effectively across an organisation. This progressive Excel learning experience will teach you how to download and manipulate complex data patterns and any collection of figures or statistics. You will become intuitively aware of how to arrange this for visual and investigative purposes. The coaching delivers a masterclass for core competencies that will take you from being a regular analyst to a sought-after Excel expert in all forms of data presentations. Make your mark in Microsoft skills and take your office abilities to the next level.  This best selling Advanced Excel Analytics by Real World Projects has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Excel Analytics by Real World Projects is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced Excel Analytics by Real World Projects is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced Excel Analytics by Real World Projects is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced Excel Analytics by Real World Projects, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced Excel Analytics by Real World Projects will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced Excel Analytics by Real World Projects to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. GETTING STARTED WITH EXCEL * Navigate the Excel User Interface * Use Excel Commands * Create and Save a Basic Workbook * Enter and Edit Cell Data * Fill Cells with Series of Data (AutoFill and Flash Fill) * Use Excel Help PERFORMING CALCULATIONS * Create Worksheet Formulas * Insert Functions and use Autocomplete * Reuse Formulas and Functions * Create an Absolute Reference MODIFYING A WORKSHEET * Insert, Delete, and Adjust Cells, Columns, and Rows * Move and Copy Data between Cells * Search for and Replace Data * Use Spellcheck and Proofing FORMATTING A WORKSHEET * Apply Text Formats * Apply Number Formats * Align Cell Contents * Apply and Copy Cell Styles * Apply Basic Conditional Formatting PRINTING WORKBOOKS * Preview and Print a Workbook * Controlling Page Layout * Adding Headers and Footers * Set Print Titles and Print Ranges MANAGING WORKBOOKS * Manage Worksheets * Insert and Delete Worksheets * Manage Workbook and Worksheet Views * Manage Workbook Properties

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 LESSON 1: BLENDING DATA FROM MULTIPLE SOURCES * Topic A: Blend Data * Topic B: Refine Blends to Visualize Key Information LESSON 2: JOINING DATA * Topic A: Create Joins * Topic B: Troubleshoot Joins * Topic C: Merge Data with Unions LESSON 3: ACCESSING DATA IN PDFS * Topic A: Connect to PDFs * Topic B: Clean Up and Organize PDF Data LESSON 4: REFINING VISUALIZATIONS WITH SETS AND PARAMETERS * Topic A: Create Sets * Topic B: Analyze Data with Sets * Topic C: Apply Parameters to Refine Visualizations * Topic D: Create Advanced Visualizations LESSON 5: ANALYZING DATA WITH CALCULATIONS * Topic A: Create Calculated Fields to Analyze Data * Topic B: Manipulate Data with Functions * Topic C: Analyze Data with Table Calculations LESSON 6: VISUALIZING DATA WITH ADVANCED CALCULATIONS * Topic A: Create Groups and Bins with Calculations * Topic B: Analyze Data with LOD Expressions LESSON 7: PERFORMING STATISTICAL ANALYSIS AND FORECASTING * Topic A: Perform Statistical Analysis * Topic B: Forecast Data Trends LESSON 8: CREATING GEOGRAPHIC VISUALIZATIONS * Topic A: Create Maps * Topic B: Customize Mapped Data LESSON 9: GETTING ANSWERS WITH ASK AND EXPLAIN * Topic A: Ask Data * Topic B: Explain Data ADDITIONAL COURSE DETAILS: Nexus Humans Tableau Desktop - Part 2 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 Tableau Desktop - Part 2 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.

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Tableau data visualizations from data analysts or from data visualization engineers. These data report recipients want to take advantage of the many Tableau features and capabilities that enable them to explore the data behind the initial analysis, perform additional analysis to ask next-level questions of the data, and to customize visualizations and dashboards to share new insights and create compelling reports. Overview Explore Tableau reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter views. Prepare reports. Troubleshoot, collaborate, and share views and analysis As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Tableau© software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed on to business data-driven decision makers. These decision makers can use Tableau's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets? LESSON 1: EXPLORING TABLEAU REPORTS * Topic A: Data Analysis Workflow with Tableau * Topic B: Explore Views * Topic C: Edit Workbooks LESSON 2: ANALYZING DATA TO GET ANSWERS AND INSIGHTS * Topic A: Configure Marks with the Marks Card * Topic B: Ask New Questions by Changing Aggregation * Topic C: Find Answers with Calculations * Topic D: Answer Questions with Table Calculations LESSON 3: SORTING AND GROUPING DATA FOR ANALYSIS AND REPORTING * Topic A: Sort Data * Topic B: Group Data LESSON 4: FILTERING VIEWS * Topic A: Filter Data to Refine Analysis * Topic B: Create Interactive Filters for Reports LESSON 5: PREPARING REPORTS * Topic A: Format and Annotate Views to Tell Your Story * Topic B: Emphasize Data in Reports * Topic C: Animate Visualizations for Clarity LESSON 6: TROUBLESHOOTING, SHARING, AND COLLABORATING * Topic A: Troubleshoot Data Issues * Topic B: Collaborate in Tableau Online * Topic C: Collaborate with Non-Tableau Users

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS * Introduction to Data Science * Create and Modify Tables * Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL * Visualize Data with Charts * Modify and Format Charts * Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS * Analyze Data with Formulas and Named Ranges * Analyze Data with Functions * Implement Data Validation, Forms, and Controls * Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES * Create a PivotTable * Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL * Visualize Data with PivotCharts * Filter Data Using Slicers and Timelines * Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL * Create Map Charts in Excel * Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS * Visualize Trendlines and Sparklines with Excel * Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA * Connect to Data with Queries * Clean and Combine Data * Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT * Install Power Pivot in Excel * Create Data Models with Power Pivot * Create Power Pivots * Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) * Plan a Report * Create a Report

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX * INTRODUCTION TODAX * CREATING OBJECTS WITHDAX * CONTEXT AND RULES OF EVALUATION * VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS * GETTING STARTED * IMPLICIT MEASURES * ADDING QUICK MEASURES * WORKING WITH DAX DATA TYPES . * DOING BASIC MATH * USING LOGIC IN YOUR CALCULATIONS * USING THE IF() FUNCTION * NESTED IF() * USING THE SWITCH() FUNCTION * ADVANCED SWITCH() * LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() * AGGREGATING AND SUMMARIZING DATA * THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL * CONTEXT DEFINED * DATA MODELING BASICS * INTRODUCTION TO DIMENSIONAL MODELING * RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT * GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE * LOOKING UP DATA WITHOUT USING RELATIONSHIPS * MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS * THE DAX ITERATOR FUNCTIONS * USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME * PERFORMING DATE CALCULATIONS * WORKING WITH DATE TABLES * GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION * DEFINING CUSTOM OPERATING PERIODS * YTD, QTD, AND MTD CALCULATIONS * CUSTOM TO-DATE CALCULATIONS * FINDING YEAR-OVER-YEAR CHANGE * FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE * CONTROLLING VISIBILITYOF YOUR MEASURES * USING WHAT-IF PARAMETERS * ADDING BANDING * USING DAX TO PROVIDE ROW-LEVEL SECURITY

Duration 2 Days 12 CPD hours Overview Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files Create views and customize data in visualizations. Manage, sort, and group data. Save and share data sources and workbooks. Filter data in views. Customize visualizations with annotations, highlights, and advanced features. Create and enhance dashboards in Tableau. Create and enhance stories in Tableau As technology progresses and becomes more interwoven with our businesses and lives, more and more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets?. LESSON 1: TABLEAU FUNDAMENTALS * Topic A: Overview of Tableau * Topic B: Navigate and Configure Tableau LESSON 2: CONNECTING TO AND PREPARING DATA * Topic A: Connect to Data * Topic B: Build a Data Model * Topic C: Save Workbook Files * Topic D: Prepare Data for Analysis LESSON 3: EXPLORING DATA * Topic A: Create Views * Topic B: Customize Data in Visualizations LESSON 4: MANAGING, SORTING, AND GROUPING DATA * Topic A: Adjust Fields * Topic B: Sort Data * Topic C: Group Data LESSON 5: SAVING, PUBLISHING, AND SHARING DATA * Topic A: Save Data Sources * Topic B: Publish Data Sources and Visualizations * Topic C: Share Workbooks for Collaboration LESSON 6: FILTERING DATA * Topic A: Configure Worksheet Filters * Topic B: Apply Advanced Filter Options * Topic C: Create Interactive Filters LESSON 7: CUSTOMIZING VISUALIZATIONS * Topic A: Format and Annotate Views * Topic B: Emphasize Data in Visualizations * Topic C: Create Animated Workbooks * Topic D: Best Practices for Visual Design LESSON 8: CREATING DASHBOARDS IN TABLEAU * Topic A: Create Dashboards * Topic B: Enhance Dashboards with Actions * Topic C: Create Mobile Dashboards LESSON 9: CREATING STORIES IN TABLEAU * Topic A: Create Stories * Topic B: Enhance Stories with Tooltips