24/02/2023
Welcome to our rising sun Academy we delight to let you know that we are going to launch a new course on excel. We will provide hands on training regarding excel and here is our Course Modules for next batch:
MODULE 1
1.1 Introduction
1.2 Overview
MODULE 2
2.1 Combine what you can enter in a cell
2.2 Relative and Absolute Cell Referencing
2.3 Entering Formula
2.4 Order of Operations
2.5 Date Serial Numbers
MODULE 3
3.1 Copy and Drag
3.2 Working with rows and columns
3.3 Working with sheets
MODULE 4
4.1 Functions
4.2 SUM Function
4.3 Copy and Drag Formula
4.4 More Basic Functions
4.5 Named Ranges
4.6 Names Constants and Formula
4.7 Shortcuts
4.8 More Shortcuts
MODULE 5
5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
5.5 Conditional Formatting Pre-Configured
5.6 Conditional Formatting with Formula
5.7 Conditional Formatting Dialogue Box Formula Trick
5.8 Drop Down List
MODULE 6
6.1 Icons Shapes and Formatting
6.2 Printing Page Layout
6.3 Printing Headers Footers
MODULE 7
7.1 Data Sort
7.2 Filtering
7.3 Tables
7.4 Text to Columns
7.5 Flash Fill
7.6 Data Validation
7.7 Group and Outline
7.8 Freeze Panes
MODULE 8
8.1 Relative and Absolute Referencing
8.2 VLOOKUP
8.3 Index Match
8.4 XLOOKUP
8.5 IF
8.6 Nested If
8.7 Countif Countifs
8.8 SUMIF SUMIFS
8.9 LEN
8.10 RIGHT LEFT MID
8.11 SEARCH
8.12 Common Error Types
8.13 IFERROR
MODULE 9
9.1 Chart Basics
9.2 Chart Series and Column Charts
9.3 Bar Charts
9.4 Pie Charts
9.5 Composite Charts
MODULE 10
10.1 Power Query Intro
10.2 Power Query Consolidation
10.3 Pivot Tables
10.4 Setting up a Pivot Table
10.5 Pivot Table Field Settings
10.6 Pivot Table Calculated Fields
10.7 Pivot Table Groupings
10.8 Pivot Table Slicers and Timelines
10.9.1 Dashboards Part 1
10.9.2 Dashboards Part 2
MODULE 11
11.1 What is a macro?
11.2 Recording a Macro
11.3 Relative and Absolute Macros
MODULE 12
Project on Management Reporting through excel
