Microsoft Excel - Basic & Intermediate
Details
MICROSOFT EXCEL - BASIC AND INTERMEDIATE
Training Objectives
- To expose participants to the capabilities and functionalities of Microsoft excel.
- To stimulate interest, curiosity, and ability in using all the available features of the excel tools.
- To help participants build the capability of using Microsoft excel to improve their personal effectiveness also improve productivity at the workplace.
- To increase the capacity and speed of usage of MS Excel as a powerful tool in driving efficiency, productivity, and professionalism in business
Mode of Delivery
Instructor-led hands-on practical demonstration and learning. Each participant is expected to work individually on a computer.
Outline
- General Overview of Microsoft Excel [Excel 2003 (version 11), Excel 2007 (version 12), Excel 2010 (version 14), Excel 2013 (version 15), Excel 2016]
- Introduction to Spreadsheets
- Understanding Microsoft Excel
- Excel Workbook Windows
- Basic Spreadsheet Skills
- Excel Help System
- Opening and Closing Workbooks
- Understanding Workbook File Formats
- Creating New Workbooks
- Selecting Cells
- Auto Sum and Auto Fill Function
- Cell Referencing and Request
- Formatting Cells
- Formatting Numbers
- Placing Cell Alignment
- Cell, Rows and Columns
- Understanding Worksheets
- Editing, Copying and Moving Cells
- Page Layouts in Excel
- Proofing Workbooks
- Basic Options, Ribbons and Toolbar
- Defining Names in Excel
- Sorting Data
- Using Excel Tables
- Filtering Data in Excel
- Understand Charts
- Chart Design Options and Tools
- Chart Format Tools
- Combo Charts
- Functions within Excel
- Understanding Date Function
- Information Functions
- Logical Functions
- Financial Functions
- Find and Replace
- Headers and Footers
- Adding Comments
- Conditional Formatting
Special Offer
20% Discount applicable on registration of a minimum of 4 participants.
Both offers are mutually exclusive
The course fee covers tuition, course materials, certificate and meals
Autusbridge Consulting Ltd is a leading training provider in Nigeria. We offer training programs in Sales, Marketing, Business Management, Microsoft Office tools and Data Analytics, Leadership, Finance and Financial Modelling Courses. We are an authorised training partner to the Institute of Sales Management, UK and Cambridge Professional Academy, UK; for the provision of Sales, Marketing and Business Operations certifications in Nigeria. Our certification programs are globally recognised for professional practice and career growth.
Our fast-growing clientele cuts across multinationals/blue chips, MSMEs and SMEs, governments and not-for-profit organisations. Our highly professional, technology-enhanced and industry-focused training contents and delivery methodology give us greater advantage amongst our peers. We have a rich faculty of training facilitators with relevant training and hands-on background from academia and professional practice.