Скачать или смотреть EXCEL for CA Articleship | Part-1 | Basics and Data Entry | @CommerceAim

Welcome to CommerceAim Youtube Channel

In this Excel course we will share all the formulas, technique that you should now in the Excel for CA Articleship.

This is a completely free course on Youtube, so please share with your friends.

Time stamps
00:00:00 - Introduction to Series
00:00:30 - Scope and Approach
00:00:57 - Structure of Course
00:01:27 - Today’s Lesson Plan
00:01:57 - Starting Excel Course
00:02:28 - Saving a File
00:03:25 - Renaming and Relocating
00:04:27 - Naming Sheets
00:05:20 - Excel’s Utility
00:06:15 - Excel Interface Overview
00:06:41 - Understanding Columns Rows
00:07:46 - Cells and Name Box
00:08:52 - Formula Bar Explanation
00:09:21 - Importance of Data
00:10:20 - Lesson Objectives
00:10:53 - Excel Shortcuts Introduction
00:11:54 - Using Shortcuts Formatting
00:13:28 - Benefits of Shortcuts
00:14:22 - Data Types Articleship
00:15:58 - Differentiating Data Types
00:17:29 - Practical Exercise Introduction
00:19:11 - Data Entry Example
00:20:22 - Setting Up Balance Sheet
00:21:30 - Creating Column Headers
00:22:28 - Adjusting Column Row
00:23:32 - Data Entry Technique
00:25:36 - Editing Cells
00:26:44 - Continuing Data Entry
00:27:25 - Formatting the Table
00:28:49 - Calculating Variance
00:29:53 - Calculating Percentage Variance
00:31:34 - Adding Indian Formatting
00:33:24 - Assignment Recap Closing
00:34:00 - Final Notes

Important links
For study content, test series subscribe to your Telegram channel
CA Foundation: https://t.me/CommerceAimCAF
CA Intermediate: https://t.me/CommerceAimInter

To buy Lectures, attempt test visit
https://commerceaim.vercel.app