428 Row courses

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: * Create, manage and save documents, files and folders * Create paragraph lists, bulleted and numbered paragraphs * Edit, modify and format paragraphs * Create and format tables * Use shortcuts to navigate documents * Format the layout of documents * Manage page headers and footers * Insert and managing pictures and diagrams within a document * Learn time saving tips and tricks to obtain a professional finish to documents * Use printing options 1 CREATING DOCUMENTS * Getting help * Creating and saving documents * Accessing recently used documents * Managing files and folders 2 ENTERING AND EDITING TEXT * Inserting and editing paragraph text * Cutting, copying and pasting text * Using tool tips to manage content * Applying and removing text formatting * Correcting spelling and grammar 3 CREATING PARAGRAPH LISTS * Creating bulleted paragraphs * Creating numbered paragraphs * Managing bulleted and numbered lists 4 MODIFYING PARAGRAPHS * Changing paragraph alignment * Indenting a paragraph * Adding borders and shading to paragraphs * Formatting paragraphs using styles 5 NAVIGATING DOCUMENTS * Using shortcuts for navigating documents * Using 'Go To' to navigate documents * Finding and replacing text * Changing to read view 6 DOCUMENT LAYOUT * Inserting page breaks * Changing page orientation * Adjusting page margins * Adding borders to pages 7 PAGE HEADERS AND FOOTERS * Inserting page headers and footers * Using header and footer commands * Inserting page numbers * Using different first page 8 INSERTING PICTURES AND DIAGRAMS * Inserting pictures from your computer * Inserting online pictures * Flowing text around a picture * Changing a picture * Inserting SmartArt diagrams * Entering text into SmartArt 9 INSERTING TABLES * Using tabs to create tables * Resizing and repositioning tables * Inserting and deleting rows and columns * Using a table's commands * Changing a tables text direction * Formatting tables 10 PRINTING DOCUMENTS * Previewing and printing documents * Using the printing tools * Printing parts of a document

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 GETTING STARTED * The Power BI process * Launching Power BI Desktop * The four views of Power BI * Dashboard visuals 2 CONNECTING TO FILES * Connect to data sources * Connect to an Excel file * Connect to a CSV file * Connect to a database * Import vs. DirectQuery * Connect to a web source * Create a data table 3 TRANSFORMING DATA * The process of cleaning data * Column data types * Remove rows with filters * Add a custom column * Append data to a table * Fix error issues * Basic maths operations 4 BUILD A DATA MODEL * Table relationships * Manage table relationships 5 MERGE QUERIES * Table join kinds * Merging tables 6 CREATE REPORT VISUALISATIONS * Creating map visuals * Formatting maps * Creating chart visuals * Formatting chart * Tables, matrixes, and cards * Control formatting with themes * Filter reports with slicers * Reports for mobile devices * Custom online visuals * Export report data to Excel 7 THE POWER QUERY EDITOR * Fill data up and down * Split columns by delimiter * Add conditional columns * Merging columns 8 THE M FORMULA * Creating M functions * Create an IF function * Create a query group 9 PIVOT AND UNPIVOT TABLES * Pivot tables in the query editor * Pivot and append tables * Pivot but don't summarise * Unpivot tables * Append mismatched headers 10 DATA MODELLING REVISITED * Data model relationships * Mark a calendar as a date table 11 INTRODUCTION TO CALCULATED COLUMNS * New columns vs. measures * Creating a new column calculation * The SWITCH function 12 INTRODUCTION TO DAX MEASURES * Common measure categories * The SUM measure * Adding measures to visuals * COUNTROWS and DISINCTCOUNT functions * DAX rules 13 THE CALCULATE MEASURE * The syntax of CALCULATE * Things of note about CALCULATE 14 THE SUMX MEASURE * The SUMX measure * X iterator functions * Anatomy of SUMX 15 INTRODUCTION TO TIME INTELLIGENCE * Importance of a calendar table * A special lookup table * The TOTALYTD measure * Change year end in TOTALYTD 16 HIERARCHY, GROUPS AND FORMATTING * Create a hierarchy to drill data * Compare data in groups * Add conditional formatting 17 SHARE REPORTS ON THE WEB * Publish to the BI online service * Get quick insights * Upload reports from BI service * Exporting report data * What is Q&A? * Sharing your reports 18 APPLY YOUR LEARNING * Post training recap lesson

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 GETTING STARTED * The Power BI ecosystem * Opening Power BI Desktop * Power BI's four views * Introduction to Dashboards 2 IMPORTING FILES * Importing data sources * Importing an Excel file * Importing a CSV file * Importing a database * Connect to an SQL Server Database * Import vs. Direct Query * Importing from the web * Importing a folder of files * Managing file connections 3 SHAPE DATA IN THE QUERY EDITOR * The process of shaping data * Managing data types * Keeping and removing rows * Add a custom column * Appending tables together * Hiding queries in reports * Fixing error issues * Basic maths operations 4 THE DATA MODEL * Table relationships * Relationship properties 5 MERGE QUERIES * Table join kinds * Merging tables 6 INSERTING DASHBOARD VISUALS * Things to keep in mind * Inserting maps * Formatting Maps * Inserting charts * Formatting Charts * Inserting a tree map * Inserting a table, matrix, and card * Controlling number formats * About report themes * Highlighting key points * Filter reports with slicers * Sync slicers across dashboards * Custom web visuals 7 PUBLISH AND SHARE REPORTS * Publishing to Power BI service * Editing online reports * Pinning visuals to a dashboard * What is Q&A? * Sharing dashboards * Exporting reports to PowerPoint * Exporting reports as PDF files 8 THE POWER QUERY EDITOR * Fill data up and down * Split column by delimiter * Add a conditional column * More custom columns * Merging columns 9 THE M FUNCTIONS * Inserting text functions * Insert an IF function * Create a query group 10 PIVOTING TABLES * Pivot a table * Pivot and append tables * Pivot but don't aggregate * Unpivot tables * Append mismatched headers 11 DATA MODELLING EXPANDED * Understanding relationships * Mark a date table 12 DAX NEW COLUMNS * New columns and measures * New column calculations * Insert a SWITCH function 13 INTRODUCTION TO DAX MEASURES * Common measure functions * Insert a SUM function * Insert a COUNTROWS function * Insert a DISTINCTCOUNT function * Insert a DIVIDE function * DAX rules 14 THE CALCULATE MEASURE * The syntax of CALCULATE * Insert a CALCULATE function * Control field summarisation * Things of note 15 THE SUMX MEASURE * X iterator functions * Anatomy of SUMX * Insert a SUMX function * When to use X functions 16 TIME INTELLIGENCE MEASURES * Importance of a calendar table * Insert a TOTALYTD function * Change financial year end date * Comparing historical data * Insert a DATEADD function 17 HIERARCHIES AND GROUPS * Mine data using hierarchies * Compare data in groups

Learn how to use this powerful tool to import and clean data and create some amazing visuals. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data.  It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. OBJECTIVES  By the end of the course you will be able to: * Import data from multiple data sources * Edit and transform data before importing * Create reports * Create different visualisations * Create data models * Build data relationships * Use the drill down features * Create measures * Use the Power BI Service * Build dashboards * Use the mobile app CONTENT ESSENTIALS Importing Data * Power BI Overview * Data sources * Importing data Transforming Your Data * Editing your data * Setting data types * Removing columns/rows * Choosing columns to keep * Setting header rows * Splitting columns Creating Reports * Creating and saving reports * Adding pages * Renaming pages * Interactivity * Refreshing your data Adding Columns * Columns from example * Custom columns * Conditional columns Append Queries * Importing folders * Setting up and using append queries Creating Chart Visualisations * Adding chart elements * Choosing chart types * Setting properties * Setting values, axis and legends * Using tooltips * Visual filters * Setting page and report filters Creating Tables, Cards, Gauges and Maps * Adding table elements * Adding maps * Working with cards * Working with matrices * KPIs and Gauges Conditional Formatting * Setting rules * Removing conditional formatting   WORKING WITH DATA MODELS Merge Queries * Setting up and using merge queries * Merging in columns of data Creating a Data Model * The data model * Multiple data tables * Connecting tables * Building relationships * Relationship types * Building visuals from multiple tables Unpivoting Data * Working with summary data * Unpivoting data Using Hierarchies * Using built in hierarchies * Drill down * Drill up * See next level * Expand a hierarchy * Create a new hierarchy Grouping * Grouping text fields * Grouping date and number fields Creating Measures * DAX functions * DAX syntax * Creating a new measure * Using quick measures Using the PowerBI Service * Shared workspaces * My workspace * Dashboards * Reports * Datasets * Drill down in dashboards * Focus mode * Using Q&A * Refreshing data * Using Quick Insights Power BI Mobile App * Using the Power BI Mobile App

Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content * Creating worksheets, formatting text * Simple and complex formulas * Handling rows and columns * Average, max and min functions and using charts. * Use of IF Formula * Summing Techniques * Cell References * Formula Linking * Tables and Bordering * Look up References (Vlookup, Hlookup, etc) * Data Validation * Conditional Formatting * Date & Time Formulas * Charts & Graphs * Protection & Security * Creating Pivot Table * Pivot Table Analysis

ADVANCED MICROSOFT EXCEL TRAINING COURSE ON BOOKKEEPING Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content * Creating worksheets, formatting text * Simple and complex formulas * Handling rows and columns * Average, max and min functions and using charts. * Use of IF Formula * Summing Techniques * Cell References * Formula Linking * Tables and Bordering * Look up References (Vlookup, Hlookup,etc) * Data Validation * Conditional Formatting * Date & Time Formulas * Charts & Graphs * Protection & Security * Creating Pivot Table * Pivot Table Analysis

Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. A comprehensive training course with up to date material to practice at home and during your class. You will also be provided a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental programme for professional Accountants. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills on excel is a must for any potential professional accountants. You will receive an attendance certificate once you complete the course successfully. EXCEL COURSE CONTENT * Creating worksheets, formatting text * Simple and complex formulas * Handling rows and columns * Autocomplete, using styles, headers and footers, * Average, max and min functions and using charts. * Use of IF Formula * Summing Techniques * Cell References * Formula Linking * Sumifs * Tables and Bordering * Look up References (Vlookup, Hlookup,etc) * Data Validation * Conditional Formatting * Date & Time Formulas * Charts & Graphs * Protection & Security * Creating Pivot Table * Pivot Table Analysis

Use some of the hidden statistical analysis tools within Excel to build complex data models. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. OBJECTIVES By the end of the course you will be able to: * Use Goal Seek * Create and view scenarios * Use Forecast Sheet * Create single and double input data tables * Create models using the solver * Install and use the Analysis Toolpak * Create and use array formulas * Use a range of advanced Financial and Statistical Excel functions  CONTENT USING WHAT IF ANALYSIS OPTIONS   * Using Goal Seek * Creating, saving and viewing scenarios * Generating a Forecast sheet SOLVER   * Creating models * Projecting scenarios with Solver USING DATA TABLES  * Creating single input data tables * Creating double input data tables * Projecting with data tables FINANCIAL FUNCTIONS  * PMT * FV * NPV ANALYSING DATA WITH ANALYSIS TOOLPAK  * Installing the Analysis Toolpak * Generating statistical analysis * Visualising data using Histograms ARRAY FORMULAS  * Using embedded Excel Array formulas * Create an Array formula * Multi and single cell Array formula * Using TRANSPOSE to flip rows or columns * Use the FREQUENCY Function * Use an array to count unique entries in a range DYNAMIC ARRAYS * Spilling data * Using the new dynamic array functions ADVANCE FUNCTIONS IN FORMULAS * Statistical functions: * MEAN, MEDIAN and MODE * RANK * LARGE and SMALL * MOD * PERCENTILE * Use the AGGREGATE function to sum data in ranges with errors