31 Excel Tips with Case Studies training centre in Bangladesh

New

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

Syed Saniat Ahmmad
  • 24 Aug - 7 Sep 2022

Practical examples, exercises & case studies with ...

IT
Md. Feroz Kibria
  • 26 - 27 Aug 2022 (2 Days)

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

IT
Md. Feroz Kibria
  • 9 - 10 Sep 2022 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

IT
Syed Saniat Ahmmad
  • 22 Sep - 4 Oct 2022

Practical examples, exercises & case studies with ...

IT
Anybody who needs Microsoft Excel at work.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.



social link fb social link fb social link fb