Excel Learning Point 365
Nearby schools & colleges
Hathazari
University of Chittagong
University of Chittagong
Among the computer programs which exist, Microsoft Excel is one of the most important because of the
Operating as usual
$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
$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
$Accounting functions in Microsoft Excel
$Finance functions in Microsoft Excel
Free Enroll (One day left)
https://www.udemy.com/course/excel-for-business-users/?couponCode=A110B6AFF600175653C1
Microsoft Excel for Finance, Accounting & Financial Analysis Excel tips & tricks for Accounting, Finance and Financial Analysis. Learn from the Bestselling Accounting Instructor
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.
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
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.........
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.
Click here to claim your Sponsored Listing.
Videos (show all)
Location
Category
Contact the school
Telephone
Website
Address
Chittagong University Road
Chittagong
4331
Sailors Colony 1, CEPZ, Bandar Thana
Chittagong
Noubahini School & College, Chattogram নৌবাহিনী স্কুল ও কলেজ, ?
Chittagong Cantonment , Biozid
Chittagong, 4209
ALLAH AMAaY GYAAN DAaO.....This is the most prestegious college in chittagong .....
Jamal Khan
Chittagong
Online tuition for classes 9-12 (National Curriculum). One-to-one care on Higher Mathematics & Physics.
Chittagong
This is the official page of the Bandarban University Computer Science & Engineering Club(BUCSEC),a campus-based science organization of Bandarban University.
Chittagong, 1990
জ্ঞানে কর্মে সৃজনে ঐতিহ্যে চট্টগ্রাম কলেজ।
Chittagong
“Teaching the world to be careful is a constructive service worthy of God’s great gift of life.
House-04, Lane-04, A-Block, Halishahar
Chittagong
A Complete information Point for Business Studies Students
EAST DELTA UNIVERSITY
Chittagong, 4209
Providing students with a platform to develop their understanding of economic and business issues
East Rampur, Halishahar
Chittagong
Way To Jannah Academy is an online educational institution. Our ultimate goal is to enter Jannah.