Ms Excel Professional Training
OBJECTIVES
As one of the most used computer software programs for businesses today, mastering Microsoft Excel is an important skill that workers should have. It is no wonder that companies and businesses demand that their staff learn Excel so that they can stay competitive.
Looking at it from the employer’s point of view, especially for those in the field of information technology system, Microsoft Excel is an essential end-user computing tool that can help perform a wide range of tasks. From making some of the mundane tasks more bearable through automation, to everyday functional tasks. Microsoft Excel is also used as a decision-making support for employers.
It isn’t surprising how Excel has been dominating the spreadsheet product industry with a share of more than 90 percent. Thanks to clever programming, businesses have relied on Excel to improve the productivity level of employees. Apart from that, Excel can also be used outside the corporate world.
At the end of the training Participants would be able to:
- Work effectively with large volumes of texts and numerical data in Excel, with ease;
- Design Excel-based templates for data collection, analysis and reporting;
- Exhibit mastery of a wide vocabulary of key concepts, functions, techniques and “power-tips” in this spreadsheet software; and
- Automate all manner of work activities/tasks in Excel, amongst others
OUTLINES
DAY 1
- Exploring the Microsoft Excel user interface
- Setting up a Workbook
- Modifying Workbooks (properties)
- Modifying Worksheets (properties)
- Customizing the Excel Program Window
- Database concept in Microsoft Excel
- Presence of header rows for data
- Presence of row and column consistency of data
- Reordering and summarizing data
- Sorting Data Lists
- Organizing Data into Levels
- Looking Up Information in a Data List
- Focusing on specific data using filters
- Limiting Data That Appears on the Screen
- Defining Valid Sets of Values for Ranges of Cells
- Advanced filter techniques
- Enhancing data integrity through data validation
- Create data validation
- Create and edit input messages and error alerts
- Dependent (advanced) data validation techniques
- Formatting
- Number formatting
- Alignment, font, border, etc
- Creating custom formats
- Application of Excel Functions in work activities
- Logical Functions: IF, AND, OR, NOT, etc
- Text Functions: UPPER, LOWER, PROPER, LEFT, RIGHT, MID, SEARCH, SUBSTITUTE, etc
- Tackling text problems: manipulating and formatting text as well as managing large volumes of text data
DAY 2
- Protection
- Protect workbook
- Protect workbook elements
- Protect worksheet elements
- Protect select cells in a worksheet
- Printing in Excel
- Adding Headers and Footers to Printed Pages
- Customizing Headers and Footers on printed pages
- Preparing Worksheets for Printing
- Setting print areas
- Print titles
- Use of conditional formatting in data analysis
- Advanced filter techniques
- Dependent (advanced) data validation techniques
- More Excel Functions
- Lookup Functions: VLOOKUP, HLOOKUP, CHOOSE, etc
- Dates and Time Functions: DATE, DATEVALUE, YEAR, MONTH, DAY, etc
- Named Ranges 1
- Naming ranges
- Editing range names and source
- Using named ranges
- Combining data from multiple sources
- Linking to Data in Other Worksheets and Workbooks
- Consolidating Multiple Sets of Data into a Single Workbook
- Grouping Multiple Sets of Data
- Use of Relative & Absolute referencing
- Analyzing alternative data sets (working with Goal Seek)
DAY 3
- Working with Pivot Tables
- Preparation pivot table data
- Creating pivot tables
- Editing pivot tables
- Grouping pivot table fields
- Showing and hiding Totals
- Using Pivot Table Slicer and Timeline [New!]
- Formatting pivot tables
- Working with calculated fields in pivot tables
- Creating pivot charts
- Creating Charts in line with best practices
- Find the appropriate chart for numerical data
- Creating a basic chart
- Manipulating charts (e.g. colour, 3D-form, etc)
- Changing Chart types
- Adding/Editing Chart titles, gridlines and labels
- Creating combination charts
- Introduction to New Features in Microsoft Excel 2013 [New!]
- New Functions e.g. ISFORMULA, IFNA, DAYS, ARABIC, etc
- Form Fill
- Quick Analysis tool
- Working with Data Models
- Power Pivot & Power View
- Introduction to DAX (i.e. Data Analysis Expressions)
- Understanding Data Models (including Relational Database Models)
- Loading data and models (e.g. from MS Excel workbooks, Access, Text Files, etc)
- Introduction to VBA and Macros
- Recording/Writing macros
- Running/Executing macros
- Application of Form Controls: combo boxes, scroll bars, check box, option box, etc
- Work-related case studies
DURATION
2 Days
DATE
10th - 11th June
FEE [₦]
70,000.00
All Available Courses
- Service Excellence – How to Give Exceptional Customer Service
- Administrative Functions and Office Management Skills
- Pre-retirement and Personal Financing
- Business Management and Strategy
- Computer Skills
- Financial Management
- Occupational Health Safety and Environment
- Mastering Human Resource Management
- Employee Performance Behaviour and attitude
- Leadership and Team Building
- Marketing Management
- Personal Skills Development (Managing Oneself for Peak Performance and Interpersonal Skills)
- Production and Service Process Management
- Teller Service Orientation program
- Selling Skills and Sales Management
- ISO 9001: 2015 Internal Auditors Training
- Facility Management Practise
- Time management: Tips to reduce stress and improve productivity
- Procurement and Contracts
- Business Writing and Communication Skills
- Accounting for Non Accountants
- Change Management- Making Organization Change Happen Effectively
- Negotiation Principles and Techniques
- Defensive Driving ( A Proactive Road Safety Training)
- Ms Excel Professional Training
- Environmental Impact Assessment Training
- Oil and Gas Health and Safety
- Project Management Training
- ISO 45001: 2018 Health and Safety Internal Audit Training
- Work at Heights
- Electrical Safety