55 Useful Tips for MS Excel training centre in Bangladesh

New

55 Useful Tips for MS Excel

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

Contents of Training:

Convert Amount into Words Automatically # Excel Security Protection # Excel Worksheet Locking and Hiding # Sort Excel Sheets/Worksheets # Convert Text to Upper/Proper Case # Create a Worksheet Calendar # Creating a Worksheet Index # Automatically Add Date Into Cell # Create Custom Excel Menu Items # Disable Cut Copy In Excel # Find Number Between 2 Numbers # Find the Difference Between Two Dates # Embedding Objects # Text Hyperlink # Image Hyperlink # Conditional Formatting # Using Names # Using Comments # Absolute References # Relative References # Validations # Customized Messaging # Data Sorting # Data Filtering # Auto Fill Items # Masking Entries # Common Keyboard Shortcuts # Using Goal Seek # Change Tab color # Change Currency Symbol # Drop down pick list # VLOOKUP formula # Using Macros # Automatically Run Excel Macros Upon Opening Excel # Automatically Run Excel Macros Upon Data Entry # Protect/Lock Excel VBA Code # Worksheets as Web pages # Importing Text Data # Concatenation # Text to Columns # Freeze panes # AutoCorrect options # Auto-Recover # Excel Errors Some Useful Functions, And Many 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.



social link fb social link fb social link fb