fbpx

MS Excel For Business

PART 1
INTRODUCTION
3 Topics
MS EXCEL OVERVIEW
DATA ENTRY AND MANIPULATION
FORMATTING, SET PRINT AREA, SAVE YOUR WORK
MS EXCEL FUNCTIONS & CHARTS AND TABLES, DROPDOWN LISTS, AND CONDITIONAL FORMATTING
12 Topics
INTRODUCTION TO THE SECTION
INTRODUCTION TO EXCEL FUNCTIONS AND ROWS
THE IF FUNCTION
THE SUM, SUMIF,SUMIFS
HOW TO USE THE AVERAGE, AVERAGE IF, FUNCTIONS
HOW TO USE THE COUNT, COUNTIF, COUNTIFS, COUNTA, FUNSTIONS
Text efficient FUNCTIONS ( LEFT, RIGHT)
VLOOKUP AND DATA VALIDATION
MATCH AND INDEX FUNCTION
THE IFERROR FUNCTION
CHARTS, PIVOT CHARTS, PIVOT TABLES & HOW YOU CAN BUILD A DASHBOARD IN MS EXCEL ( APPLYING EXCEL FUNCTIONS AND TECHNIQUES)
BUILDING A NAVIGATION BAR & HOW TO USE LINKS AND BUILDING BOTTONS IN MS EXCEL
Part 2
VBA & MACROS IN MS EXCEL
2 Topics
INTRODUCTION TO MACROS
INITIALIZATION TO VBA
PART 3
PRACTICAL CASE STUDY 1 (BUILDING A STOCK MANAGEMENT SYSTEM IN MS EXCEL)
7 Topics
PRESENTATION OF THE CASE STUDY
BUILDING THE WORKSHEETS IN WHICH THE PROGRAM WILL BE CREATED
AUTOMATING THE SALES INVOICE WITH THE USE OF VLOOKUP,ROW,IF,IFERROR FUNCTION
BUILDING THE STOCK-CARD
USING THE VBA CODE TO AUTOMATE THE SALES INVOICE
CONVERTING THE INVOICE TO PDF USING THE VBA CODE
CONDITIONAL FORMATTING FOR THE STOCK CARD
PRACTICAL CASE STUDY 2 (BUILDING AN ACCOUNTING SYSTEM FOLLOWING THE OHADA ACCOUNTING SYSTEM)
6 Topics
PART 1: CREATING THE JOURNAL & THE ACCOUNTING PLAN
PART 2: ACCOUNTING ENTRIES AND BUILDING THE LEDGER
PART 3: CREATING A DETAILED LEDGER ACCOUNT
PART 4: BUILDING THE TRAIL BALANCE
PART 5: BUILDING THE INCOME STATEMENT WITH THE USE OF PIVOT TABLES
PART 6: BUILDING THE BALANCE SHEET WITH THE USE OF PIVOT TABLES
Final quiz
Previous Topic
Next Topic

THE IFERROR FUNCTION

MS Excel For Business MS EXCEL FUNCTIONS & CHARTS AND TABLES, DROPDOWN LISTS, AND CONDITIONAL FORMATTING THE IFERROR FUNCTION
Previous Topic
Back to Lesson
Next Topic

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts

Please allow a few minutes for this process to complete.

Report

You have already reported this .