Advanced Excel – Leadway Training And Technology Institute

Welcome to the platform for quality computer accounting, management and IT training with worldview content

Advanced Excel Training

Excel is the world’s one of most popular and widely used spreadsheet program. Gaining advanced skills on how to work on excel as an advanced user with Leadway Training shows that you’ve taken one of the best professional Excel training courses available. Excel courses are comprehensive training with up to date material to practice at home and during your class. Advanced Excel courses are offered through classroom and online live. You will also be provided a step by step e-manual of all the tricks you can do using Excel spreadsheets to gain better management reporting, financial planning and budgeting skills.

Excel spread sheets are the most powerful tool, extensively used for financial reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market if you want to be successful.

This advanced Microsoft Excel training course will teach you how to use the advanced features of Excel to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.

This course is instructor led, and involves lots of examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks.

N85000

N 75,000

Manuals, Quality Training, Assessment, Real live Business/Accounting Case Studies, Exams, Certificate
Training delivered by Experienced Microsoft Excel Trainers Analysts
4week course (Intensive Practical Training)
Flexible time, weekdays and weekends training Available
Form N2,000

Popular

What are the course objectives? (what trainees can do with Advanced Excel)

At the end of this training trainees will be confident to:

Create and use defined names in a workbook
Work with logical function in Excel
Use a variety of data validation techniques
Use a range of lookup and reference functions
Create summaries in your spreadsheets using subtotals
Understand and create simple Pivot Tables
Construct and operate Pivot Tables using some of the more advanced techniques
Use the Data Consolidation feature to combine data from several workbooks into one
Create and work with scenarios and the Scenario Manager
Use Solver to solve more complex and intricate problems
Import data into Excel and export data from Excel
Create and use a range of controls in a worksheet
Create recorded macros in Excel
Import data into Excel and export data from Excel
– Run Budget and forecasting
– Design all-inclusive bookkeeping, ledgers and linking of Financial Accounting reports
– Design and run comprehensive payroll platform
– Manage Business Dashboard and Analysis
– Loan repayment and tracking
– Calculating IRR of project
– Inventory Management and analysis
– Sales And Purchase analysis
– Graphical presentation of data
– Imprest system management
– Financial Analysis
– Sorting and filtering of business data
– Production cost analysis
– Sharing of excel files etc.

Who should do this course?

Chartered Accountants, Accountants, Auditors
Graduates or Undergraduates of Accounting, Economics, Insurance, Management and other related courses or jobs.
Civil servants, Business owners, Entrepreneurs,
Finance Managers, Cashier, Consultants
Corp Members (NYSC), Retail managers
Financial Analysts, Statisticians, Project Managers, Project Evaluators
Business, Analysts, Sales/Purchase Managers
Organizations and businesses that want to upgrade their staff skills organisational and analytical skills.

PREREQUISITE:
Desire to upgrade one’s skill base/career path to becoming a computer accountant and your laptop. Note, there are also Laptops in the training centre for student’s use.

TO REGISTER,
Make payment to:
Account Name: Leadway Training And Technology Institute
Current Account No: 0655601884
Bank Name: Guaranty Trust Bank (GTB)

For Details call: 0706-300-2998
Email us on: info@leadwaytraininghub.com or leadwaytechnology@gmail.comto:

Course Content

LEVEL I

EXCEL INTRODUCTION

An overview of the screen, navigation and basic spreadsheet concepts
Various selection techniques
Shortcut Keys

CUSTOMIZING EXCEL

Changing Excel’s Default Options
Creating a Custom AutoFill List
Creating a Custom Number Format
Customizing Excel Review
Customizing the Quick Access Toolbar
Customizing the Ribbon
Using and Customizing AutoCorrect

FORMATTING AND PROOFING

Currency Format
Format Painter
Formatting Dates
Custom and Special Formats
Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
Basic conditional formatting

ENTERING DATA

Entering, Editing and Deleting Text, Numbers, Dates
Inserting, Deleting and Hiding Rows & Columns
Inserting, Deleting, Moving and Copying Sheets
Moving and Copying data
Using Auto Lists
Using navigation techniques

ADVANCED PASTE SPECIAL TECHNIQUES

Add / Subtract / Multiply / Divide
Merging Data using Skip Blanks
Paste Conditional Formats
Paste Formats
Paste Formulas
Paste Validations
Transpose Tables

CONDITIONAL FORMATTING

Creating Basic Conditional Formats
Dynamic Formatting using Formulas in Conditional Formatting
Managing Conditions Created
Sorting And Filtering data
Sort data as per value, colour, icons
Filter based on Font/Cell colour
Turning Auto Filter off
Use subtotal features and work with database functions

DATA PRESENTATION WITH CHARTS

Bar Charts / Pie Charts / Line Charts
Modifying and formatting existing

DATA ANALYSIS USING SPARKLINES

Line Sparkline
Column Sparkline
Win/Loss Sparkline

PROTECTING EXCEL

File Level Protection
Setting Permissions for Specific Tasks
Sheet & Cell Level Protection

DATA ANALYSIS REPORT WITH PIVOT TABLES & PIVOT CHARTS

Analyzing and generating reports of large data using
Creating PivotTables, editing and updating changes in
Using Slicers in Pivot Table
Creating Pivot Chart

UNDERSTANDING REFERENCES

Relative, Absolute & Mixed reference
Referencing different workbooks & Merging

MANIPULATING DATES

Dates formats
Extracting Day, Month or Year from a date value
Extracting Day, Month or Year from a date value using TEXT Formula
Extracting end month from a date value

LEVEL II

ADVANCED EXCEL FORMULAS

Logical Functions
Ifs and Nested Ifs Statements
AND, OR and NOT Functions
Error handling using IFERROR, ISNA and ISERROR

TEXT FORMULAS

CONCATENATE
FIND V/S SEARCH
LEFT, RIGHT, MID
UPPER, PROPER, LOWEER

LOOKUP FORMULAS

VLOOKUP & HLOOKUP
INDEX & MATCH
SUMPRODUCT

LINKING CELLS AND WORKBOOKS FOR ACCOUNTING REPORTS

Consolidating data, linking cells in different workbooks
Utilizing Dynamic Named Ranges for writing formulas and functions

DATA VALIDATIONS AND PROTECTION

Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Creating a Dropdown list and others
Number, Date & Time Validation
Text and List Validation
Custom validations based on formula for a cell
Dynamic Dropdown List Creation using Data Validation – Dependency List

WHAT-IF ANALYSIS

Data Tables
Goal Seek
Scenario Analysis

GROUPING & SUBTOTALSDATA VALIDATION

Dynamic Dropdown List Creation using Data Validation
Handling Invalid Inputs
List Validation
Number, Date & Time Validation
Text Validation

EXCEL DASHBOARD

Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard
Adding Tables to Dashboard
Bar Charts / Pie Charts / Line Charts
Planning a Dashboard

FINANCIAL ANALYSIS AND FORMULAS

Project Appraisal
- Using IRR
- Using NPV
Loan Modelling
- Modelling instalments
- Modelling loan balances
- Making a decision between a flat-rate v/s reducing balance priced loans
- Effective interest rates

BUDGETING UNDER SCENARIOS

Introductions to planning scenarios; Best Case, Base Case & Worst-Case Scenarios
Perform statistical analysis with the Analysis ToolPak,
Create interactive data with Power
Use of Combo Box and CHOOSE function to automate scenario analysis
Build a scenario-based budget model

EXCEL MACROS AND VBA FOR PROGRAMMING

Introduction to Excel Macros
Recording and Running a Macro
Absolute vs Relative
Assigning Buttons to Macros
Assigning Macros to an Auto Shape and to an icon on a Tool bar
Sheet Controls and User Form Controls
Deleting a Macro

Other Information

The course is organized in modules and each module covers a reasonable content to enable participants connect and progress successively in the next modules

Venue

Abuja Training Center: Suite 315, Third Floor, Anbeez Plaza, Ndola Crescent, Opp. Old Corporate Affairs Commission, Wuse Zone 5, Abuja.

What does the training Pack contain?

Certificate of completion.
Training materials (Hard copy)
Training Manuals
Real life Business simulations/mock exams
Students Workbook and Project Templates
Real-life application and understanding
Certified and Experienced trainers
Conducive learning environment

Contact or join our live chat below or call 07063002998, WhatsApp 07063002998

Pay Training fee before training start date or starting of the training
Visit Register and complete the registration form.
Upon confirmation of your registration, an electronic receipt will be sent to your mail.
Commence your training at Leadway Training and Technology Institute venue or use our online classes platform.