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
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
Delivered in London or OnlineLondonorOnlineFlexible Dates
This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact.
This course will help participants:
Using Slide Master
Create a presentation using a template
Insert slides and change the layout
Manage slides and control formats
Enhance slides using animation, pictures, charts and graphics
Work with tables, rows, cells and columns
Create and control paragraph lists
Insert titles and labels
Effectively use slide show controls and presenter view
Print slides, handouts and notes
1 Introduction to PowerPoint
Navigating the features
Creating a simple presentation
Inserting new slides and changing layouts
Creating speaker notes
2 Using Layouts in Slide Master
Editing templates in slide master
Adding a design theme
Adding transitions, pictures and logos
Using Slide Show View
3 Drawing shapes and SmartArt
Using Drawing Tool Formats
Creating shapes
Aligning shapes and stacking order
Creating a cycle graphic
Creating an organisation chart
4 Animation
Visually enhancing slides with animation
Using text and object animation
Adding animation to lists
Making animation work for you
5 Presenting
Confidently running a presentation
Using presenter view
Using the slide show controls
Delivered in Harpenden or UK Wide or OnlineHarpenden or UK WideorOnlineFlexible Dates
Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing!
This course will help participants:
Nest formulas
Get the most from pivot tables
Use conditional formatting
Write array formulas
Explore the lookup functions
Calculate by criteria
Use 'goal seek' and 'scenario manager' for what-if analysis
Record macros
1 Nesting formulas
Principles of nesting formulas together
Using IF with AND or OR to answer questions
Nesting an AND function in an IF
Nesting an OR function in an IF
2 Advanced pivot table reports
Grouping dates, numerical and text items
Running percentage analyse
Running analyses to compare data
Inserting Field calculations
Finishing off with a user-friendly dashboard
3 Advanced conditional formatting
Colour table rows based on criteria in it
Applying colour to approaching dates
Exploring the different rule types
4 Lookup functions
Going beyond the VLOOKUP function
Lookups that retrieve data from left or right
The versatile INDEX and MATCH functions
Retrieving data from columns with duplicates
5 Calculate by criteria
Using SUMIFS to sum by criteria
Finding an average by criteria with AVERAGEIFS
Use SUMPRODUCT to multiply then add different values
6 What-if analysis
Use Goal Seek to meet targets
Forecast reports with the Scenario Manager
7 Recording Macros
Macro security
Understanding a Relative References macro
Recording, running and editing macros
Saving files as Macro Enabled Workbooks
Introduction to VBA code
Making macros available across workbooks
Add a macro button to the Quick Access toolbar
Delivered in Harpenden or UK Wide or OnlineHarpenden or UK WideorOnlineFlexible Dates
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
Delivered in Harpenden or UK Wide or OnlineHarpenden or UK WideorOnlineFlexible Dates
Price on Enquiry
Power BI - introduction to intermediate (2 days) (In-House)
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
Delivered in Harpenden or UK Wide or OnlineHarpenden or UK WideorOnlineFlexible Dates
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
Delivered in Harpenden or UK Wide or OnlineHarpenden or UK WideorOnlineFlexible Dates