BASIC LEVEL DATA ANALYTICS WORKSHOP
Live-Online Training: N135,000
Classroom Training: N 165,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount
(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS SHOULD BRING THEIR LAPTOP)
Programme Description
This course will help businesses in increasing productivity by: Saving time and efforts of employees 90%, Reducing errors and chances of omission 95%, and extending your business intelligence investment 85%. It is very useful for financial recordings, daily business financial and data reporting, too many things to mentions.
Course Objectives
At end of this course participants will be able to:
- Create basic worksheets using Microsoft Excel 2016 and above.
- Perform calculations in an Excel worksheet.
- Modify an Excel worksheet.
- Modify the appearance of data within a worksheet.
- Manage Excel workbooks.
- Prepare an Executive Summary Report using global best practice.
- Print the content of an Excel worksheet.
Couse Content
DAY ONE
MODULE 1: Essentials Skills
Intro to Excel Ribbon
- The mouse
- Scrolling
- Keyboard shortcuts
- Windows desktop
- Run an App from start Menu
- Create an Excel blank document
- Maximize/minimize window
Excel user interface
- Title bar
- Men bar
- Ribbon bar
- Formular bar
- Data area – Columns & Rows
- Worksheet bar
- Status bar
- Columns, Rows and Cells
- Quick Access Toolbar
- Min toolbar
- Document properties
Printing
- To access the Print pane
- To Print a business report professionally
- Print a workbook
- Print active sheet
Organising files
- Create a folder
- Create a folder within a folder
- Hierarchy & travelling through folders/files
- Switch from one app to another
Saving your documents
- Save
- Save as
- Save in different file type
- Save a file one OneDrive
- Protect your data and keep the business running
Screen resolution
- Minimise/Restore a window
- Change screen resolution
- Exit Excel with a document open
Backstage view
- Run an App from the search box
- Open an existing document
- Create a new document
- Close a file
- Open a recent file
Organizing files
- Renaming, move and delete a file
Window help
- Open Office help
- Move and resize a window
DAY TWO
Module 2: Creating a worksheet and a Chart
1. Entering Text and Sum
- Selecting a Cell
- Entering Text
- Entering numbers
- Calculating a sum
- Using the Fill handle to copy text
- Using the Fill handle to formulas
- Entering a formula using a keyboard
Formatting a cell & worksheet
- Formatting a cell
- Using the Bold, Italic & underline commands
- Change the font
- Change the font size
- Change the font color
- Text alignment
- Format rows
- Cell styles
- Apply style
- To merge cells using the Merger & Center command
- Apply the number formats
- Modifying column width
- Use the name box to select cell
- Other ways to select cells
Add Charts
- Add a chart
- Apply a style to a chart
- To move a chart to a new sheet tab name
- To change the sheet tab name
Auto calculate area
- Use the auto calculate area to determine a maximum
Correct errors
- Correcting errors while entering data
- Undoing last entry
- Clearing a cell or range
- Clearing the entire worksheet
- Removal of circular reference & other worksheet errors.
DAY THREE
MODULE 3: Formulas, Functions and Formatting
Titles & fill
- Entering worksheet, columns and rows titles
- Flash Fill
- Autofill options
Entering formulas
- Ari thematic/Basic operations
- Order of Operations
- Entering formulas using Point & click
- Copy formulas using the fill handle
- Using the AUTOSUM button
- SUBTOTAL
- Range Finder
Formatting the worksheet
- To change the worksheet theme
- Merge and Centre
- Background color
- Apply border
- Applying accounting Dates, currency and percentage formats
- Conditional formatting
- Changing row height
Checking spelling
- Checking spelling worksheet
- Additional spelling checker
Printing the worksheet
- Change printing margins, header & orientation, fit page
- Print the worksheet
- Print a selection of it
- Displaying and printing the formulas