31 Excel Tips with Case Studies training centre in Bangladesh

Forgot password?
Sign in with
New
Caution

31 Excel Tips with Case Studies

Introduction

Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. This course will enable you to maximize the potential of the powerful Microsoft Excel software to produce more professional business information. The course covers some useful tips of Microsoft Excel commonly used in the workplace.

Methodology

The course combines theory and practice by mixing lectures and exercises throughout the session(s). Participants will have to sit for an assessment test at the end of the training.

Contents of Training:

#Solving Case-studies After Learning and Applying 31 ExcelTips
#Convert Amount into Words Automatically
#Operating Macros
# Using Names/Ranges
#Pivot Table # Excel Subtotals
#VLOOKUP Formula
# SumIF Function
# Advance CountIF Function
# Conditional Formatting
# Using Goal Seek
# Create Custom Excel Menu Items
# Sort Excel Sheets/Worksheets
#Convert Text to Upper/Proper Case
#Create a Worksheet Calendar
# Creating a Worksheet Index
#Input Validations by Range, List and Custom Message
#Find the Difference Between Two Dates with Parameters
# Embedding Objects
# Using Hyperlink
#Absolute and Relative References
#Linking Worksheet and Workbooks
#Data Sorting
#Data Filtering
# Common Keyboard Shortcuts
#Locking and Protecting Excel Worksheet
#Change Currency Symbol (Global and Local)
#Importing Text Data
#Joining Text of Different Cells
#Splitting Text of One Cell to Columns # And more…

Related Courses

Price 4,500 Tk + VAT
Syed Saniat Ahmmad
  • 24 Aug - 7 Sep 2022

Practical examples, exercises & case studies with ...

IT
Online Training Register Wishlist
Price 4,500 Tk + VAT
Md. Feroz Kibria
  • 26 - 27 Aug 2022 (2 Days)

Day to day HR and Admin data analysis, reporting, tools and ...

IT
Offline Training Register Wishlist
Price 1,500 Tk + VAT
Md. Feroz Kibria
  • 9 - 10 Sep 2022 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

IT
Online Training Register Wishlist
Price 4,000 Tk + VAT
Syed Saniat Ahmmad
  • 22 Sep - 4 Oct 2022

Practical examples, exercises & case studies with ...

IT
Online Training Register Wishlist

Who can Attend

Anybody who needs Microsoft Excel at work.

Boarding

Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.



Bdjobs eLearning, a division of Bdjobs.com Limited, started its operation in 2005. Currently it is the largest professional training house in the country that runs training ........ more

Get Email Alert

We'll email you updates on job trends, new courses, study tips and more.

About Bdjobs eLearning

Courses by Industry

Courses by Functional Area

Courses by Type

social link fb social link fb social link fb