• 9815770276
  • noreply@example.com
  • SCO No: 126-127, 4th Floor, Sector 34-A, Chandigarh (UT)

MIS Training in Chandigarh

MIS Training in Chandigarh: This course is basically designed to help you to write macros in Excel using the programming language Visual Basic Application (VBA). The recorded macro can be edited to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks.

MIS Training in Chandigarh

One can write his own functions and procedures, design forms, and work with add-ins. We provide the best MIS training in Chandigarh.  It’s 100% practical training with a live project. Best SEO and Google Ads course training in Chandigarh.

APPLICATIONS OF THIS COURSE:

  • Excel is used for preparing Company profiles in the form of Charts and Graphs.
  • Excel stores the accounting spreadsheets in Electronic form.

What is the Advanced PPC course in Digital Marketing?

CONTENT:

Module 1: Getting Started

Understanding the Excel screen
Navigating a spreadsheet
Understanding worksheets, columns, rows, and cells
Saving, opening, and closing workbooks

Module 2: Formatting a Spreadsheet

Changing column widths and row heights
Changing alignment of cells
Undoing and redoing actions
Formatting numbers
Clearing formats
Applying borders to cells
Merging cells

Module 3: Formulas and Functions

Entering formulas
Copying data and formulas
Using Auto Sum
Understanding functions
Using simple aggregate functions (Sum, Count, Average, Min, Max)
Copying formulas
Applying conditions in a formula (The IF function)
Working with ranges

Module 4: Editing Features

Using cut, copy, and paste operations
Using paste special with values
Selection techniques
Navigation techniques

Module 5: Working with Large Worksheets

Freezing and unfreezing panes
Splitting windows
Inserting page breaks for printing

Module 6: Working with Charts

Creating charts using Chart Wizard
Creating different types of charts
Including titles and values in charts
Formatting of charts

Module 7: Previewing and Printing

Previewing worksheets
Page setup
Printing of worksheets on multiple pages
Repeating rows and columns for multiple pages
Printing multiple worksheets

Module 8: Simple Database Operations

Sorting tables
Filtering data with auto filter
Referring to data from other worksheets

LESSONS FEATURES:

  • Increased capacity, high-end formatting options, and a mapping feature give you powerful ways to analyze your data visually.
  • Explore the power of the Internet from your familiar Microsoft Excel spreadsheet.
  • When you want to analyze data from outside Microsoft Excel, there’s no need to retype. With a few keystrokes, you can bring the data right onto your worksheet.
  • Excel has three components that perform in three different manners:
    1. The Spreadsheet.
    2. The Datasheet.
    3. The Chart.
  • Create formulas on worksheets. It’s easy and fast.
  • Enhanced formatting and layout features help you get the printed report or online form with the look you want.
  • You can quickly find the information you need and create automatic subtotals of your data.

If you want to learn a digital marketing course then contact the best digital marketing course training institute in Chnadigarh.

Leave a Reply

Your email address will not be published. Required fields are marked *