Excel Reporting - Basic

Excel Reporting - Basic

Why take Excel Training?

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.

Brief about topic

1. Excel Basics

  • Getting Started with Excel 2010
  • Explore Window
  • BackStage View in Excel
  • Entering Values in Excel
  • Save Workbook
  • Create Worksheet
  • Copy Worksheet
  • Hiding Worksheet
  • Delete Worksheet
  • Close Worksheet
  • Open Worksheet 

 

2.Editing Workbook

  • Insert Data
  • Select Data
  • Delete Data
  • Move Data
  • Rows& Columns
  • Copy & Paste
  • Find and Replace
  • Spell Check
  • Zoom in -Out
  • Special Symbols
  • Insert Comment
  • Add Text Box
  • Undo Changes

 

3. Formatting Cells

  • Setting Cell Type
  • Setting Fonts
  • Text Decoration
  • Rotate Cells
  • Setting Colors
  • Text Alignments
  • Merge & Wrap
  • Borders & Shapes
  • Apply Formatting

 

4. Formatting Worksheets

  • Sheets Options
  • Adjust Margins
  • Page Orientation
  • Header and Footer
  • Insert Page Break
  • Set Background
  • Freeze Panes
  • Conditional Format

 

5. Working with Formulas

  • Create Formulas
  • Copy Formulas
  • Formula Reference
  • Using Functions
  • Built In Functions

 

6.  Advanced Operations

  • Data Filtering
  • Data Sorting
  • Using Range
  • Data Validation
  • Using Style
  • Using Templates
  • Using Macros
  • Adding Graphics
  • Cross Referencing
  • Printing Worksheet
  • Email Worksheet
  • Translate Worksheet
  • Workbook Security
  • Data Table
  • Pivot Table
  • Simple Charts:- Creation, Addition and Modification, Formatting of Charts
  • Pivot Charts         
  • Keyboard Shortcuts

  • Training Course can help you develop the right skills needed to be a qualified professional and get high-paying jobs in top MNCs.

  • Microsoft’s Excel leading the market share with over 750 million users worldwide – comScore.com

  • Excel is used by Finance, Sales, Marketing, HR among other departments

  • Deep Excel expertise is a much sought-after skill around the world

Instructor-led live online classes

OFFER ! Pay an 'Early Bird' deposit now and save 10% on the final price!

Early Bird Offer

  • 08

    Jun

    Mon - Tue ( 4 Weeks )

    7:00 PM - 9:00 PM

    • 40% off

      16,667

    10,001
40% Off till 12-Jun

Live Classes

On-time scheduled virtual classes with limited trainer-student ratio.

Expert Trainers

Best industry experts with years of online training experience.

Tailored Course

Based on your expertise and goals we design course for you.

Flexible Schedule

Learn at your schedule , time zone and convenience.

Get Certified

Receive a certificate to confirm the level of your skills in a professional context.

Indu

The course was great the instructor was beyond my expectations. Thank you Trainers for giving me this course.

Danut Yatpiyakuk

Good programs.

×

Get A Quote

Please fill your details. Fields marked with mandatory are mandatory

(Allowed types : PDF, DOC, XLS, JPEG, GIF, PNG )

Privacy Policy : We hate SPAM and promise to keep your email address safe.