Excel Learning Point 365

Among the computer programs which exist, Microsoft Excel is one of the most important because of the

Operating as usual

07/03/2021
07/03/2021
07/03/2021
Microsoft Excel -Basic Excel/ Advanced Excel Formulas 25/11/2020


$Learn how to work with the most popular microsoft Excel functions
$Build Basic Excel apps from scratch with different functions
$Be able to work with different Excel function types such as date and time, finance and many others

Free Enroll (One day left)
https://www.udemy.com/course/microsoft-excel-basic-excel-advanced-excel-formulas/?ranMID=39197&ranEAID=ZVa%2FfYdMEMA&ranSiteID=ZVa_fYdMEMA-02gPn6UR3nIJR85kWppJ0g&LSNPUBID=ZVa%2FfYdMEMA&utm_source=aff-campaign&utm_medium=udemyads&couponCode=00DB0029DA8B83B1BF5F

Microsoft Excel -Basic Excel/ Advanced Excel Formulas Learn more than 80+ Excel function/Excel formulas/Excel tips for Excel 2007 to Excel 2019 with Excel examples

Master all the MS Excel Macros and the basics of Excel VBA 25/11/2020


$Create plenty of small projects to learn the basics of VBA
$Understand VBA programming structure and concepts
$Learn the best way to write a VBA code on Excel
$Understand how to use the macro recorder
$Be able to autome different tasks with VBA on Excel
$Enhance your current Excel projects with VBA programming

Free Enroll (Ten hours left)
https://www.udemy.com/course/master-all-the-ms-excel-macros-and-the-basics-of-excel-vba/?ranMID=39197&ranEAID=ZVa%2FfYdMEMA&ranSiteID=ZVa_fYdMEMA-02gPn6UR3nK_CHPjmldCYQ&LSNPUBID=ZVa%2FfYdMEMA&utm_source=aff-campaign&utm_medium=udemyads&couponCode=04CEF68ABF308744B587

Master all the MS Excel Macros and the basics of Excel VBA Learn automation of tasks with Excel Macros and Excel VBA With different Excel Projects

22/06/2020


Select any cell within the range.

Select Data > Filter.

Filter button

Select the column header arrow Filter arrow .

Select Text Filters or Number Filters, and then select a comparison, like Between.

Number Filters Between

Enter the filter criteria and select OK.

Custom AutoFilter dialog box

Filter data in a table

When you Create and format tables, filter controls are automatically added to the table headers.

An Excel table showing built-in filters

Select the column header arrow Filter drop-down arrow for the column you want to filter.

Uncheck (Select All) and select the boxes you want to show.

Filter Gallery

Click OK.

The column header arrow Filter drop-down arrow changes to a Applied filter icon Filter icon. Select this icon to change or clear the filter.

11/06/2020

05/06/2020


05/04/2020


31/03/2020


30/03/2020


29/03/2020


27/03/2020

MS Office Excel Essentials | Weekend Course

Course Overview:
This Basic to Advanced Microsoft Excel 2013 Basic and Advanced Essentials course focuses rigorously on developing your expertise on the following functions of MS Excel:

-Start Up and Interface
-Formatting Cell Contents
-Basic Formula
-If Statements
-Lookup Functions
-Advanced formulas and functions
-Named ranges
-Resolving formula errors
-Consolidating data, removing duplicates, configuring data validation, and transposing data
-Using outlining, grouping, and subtotal tools
-Working with scenarios
-Using data analysis tools (such as Solver and Goal Seek)
-Creating and using Pivot Tables and Pivot Charts
-Using Power Pivot to integrate data from several different sources
-Recording, editing, and using macros

||Course Outline:

Class No and Course Content:

Class-1
Start Up and Interface
Formatting Cell Contents
Editing a Cell
Formatting a Worksheet
Advanced Sheet Options
Printing

Class-2
Basic Formula
Defining and Auditing Formula
If Statements
Lookup Functions
More Functions
Working with Lists
Advanced Formats and Filters
Data Tools

Class-3
Tables
Slicers
Inserting Objects
Sparkline’s
Charts
Advanced Charts

Class-4
Intro to Pivot Tables
Advanced Pivot tables
Protecting Your Workbook
Sharing your Workbook

Class-5
Case Study

Class-6
Macro Basics
Developing Macros

Class 7-20
Topic will be Announced, on the way of course running

-If you are interested
Instructions:
1. Download zoom app from Google or play store (mobile)
2. Mute your volume unless you have a question.
3. Please don't make laugh if I did something wrong. Because all of the things are new for me.
4. If I go very fast, let me know.
5. If you're discounted , please connect with the same ID.
6. Duration of Classes: 02 hours (with 5 minutes break)
7. There will be pre-assignment and post assignments.
8. After each class, there will be assignments for skills practice.

||Class Starts: 27th February 26, 2020. Time (1 pm to 4 pm)Room no. 122.(Free Class)
||Class Schedule: 12th,19th,26th March; 2nd, 9th, 16th, 23rd ,30th April, 2020.
||Time 1 pm to 4 pm.


1. You have to attend all the classes.
2. After 2 normal classes there will be a case study class.
3. If you face a problem, download team viewer, I'm here to help. Team viewer which is an app that can be used to work collaborately in a single laptop.
4. If you miss the class, there will be a video record for you.
5. There will be a weekly challenge exam. Who can manage to submit first of all reward point's will be added.
6. Last but not least, please don’t share these excel materials for any other purposes. These materials are like asset to me and very important. Use it only to learn and then spread your knowledge.
7. Please pay your fee's timely.

Course Fee: Will be announce soon.
Trainer:
Mushleh Uddin
Mobile: 01789489372



27/03/2020


The Excel dashboard is an interesting one as it is made up of many sparklines. The Excel dashboard is arranged in financial quarters. These sparklines are not charts at all but a fudge into the world of using formatting to graphically indicate a position in Excel. The Excel dashboard works well as a visual display of each of the metrics being displayed. It is clean and clear and has conditional formatting rules to change the colour of the lines in each table. These Excel dashboards are very easy to create and maintain.

Want To Learn? Join with us.........

27/03/2020

Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spreadsheet program in many business activities, classwork and even personal data organisation. Excel was first released in the year 1985. Since then, it has played a vital role in performing formula based arithmetic and calculations, and other activities that may require mathematical calculations. Many businesses, personal and institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for different applications. The importance of MS Excel can be seen in the different departmental units it is used as follows.
1. Graphing, 2. Data organisation, 3. Programming, 4.Basic Financial Accounting,5. Tracking Product Sales,etc.

Want your school to be the top-listed School/college in Chittagong?

Click here to claim your Sponsored Listing.

Videos (show all)

#ExcelLearningPoint365
Move or Copy Worksheet

Location

Category

Telephone

Website

Address


Chittagong University Road
Chittagong
4331
Other Education in Chittagong (show all)
Noubahini School & College, Chattogram Noubahini School & College, Chattogram
Sailors Colony 1, CEPZ, Bandar Thana
Chittagong

Noubahini School & College, Chattogram নৌবাহিনী স্কুল ও কলেজ, ?

CHITTAGONG CANTONMENT PUBLIC COLLEGE CHITTAGONG CANTONMENT PUBLIC COLLEGE
Chittagong Cantonment , Biozid
Chittagong, 4209

ALLAH AMAaY GYAAN DAaO.....This is the most prestegious college in chittagong .....

BASE - Your BASE Lies Here BASE - Your BASE Lies Here
Chittagong, 4000

127 Momin Road, Opposite Kadam Mobarok

Innovative Learning Innovative Learning
Jamal Khan
Chittagong

Online tuition for classes 9-12 (National Curriculum). One-to-one care on Higher Mathematics & Physics.

Bandarban University Computer Science & Engineering Club Bandarban University Computer Science & Engineering Club
Chittagong

This is the official page of the Bandarban University Computer Science & Engineering Club(BUCSEC),a campus-based science organization of Bandarban University.

National University of Bangladesh Chattogram Gov College National University of Bangladesh Chattogram Gov College
Chittagong, 1990

জ্ঞানে কর্মে সৃজনে ঐতিহ্যে চট্টগ্রাম কলেজ।

Bangla &BD.Studies care. Bangla &BD.Studies care.
Panchlish
Chittagong

A Coaching For O'Level & SSC Bangla & BD.Studies/BGS

Khan Safety Academy Khan Safety Academy
Chittagong

“Teaching the world to be careful is a constructive service worthy of God’s great gift of life.

Accounting Information Points Accounting Information Points
House-04, Lane-04, A-Block, Halishahar
Chittagong

A Complete information Point for Business Studies Students

Target School Target School
Chittagong

Hi,Am here to show you just enlighteing way to be unique in your life.

EDU ECON Acumen Society EDU ECON Acumen Society
EAST DELTA UNIVERSITY
Chittagong, 4209

Providing students with a platform to develop their understanding of economic and business issues

Way To Jannah Academy Way To Jannah Academy
East Rampur, Halishahar
Chittagong

Way To Jannah Academy is an online educational institution. Our ultimate goal is to enter Jannah.