Microsoft Excel Training

The best Microsoft Excel training in Coimbatore is here. Microsoft Excel is a technical and software capability holding a unique value in the job career.

Microsoft Excel placement opportunities are in evergreen demand in the market. Spark Databox’s Microsoft Excel training in Coimbatore is a comprehensive course that provides an honest view of the new and improved features available in Microsoft Excel.

Curriculum:

• Section 1: Introduction to Microsoft Excel
  •  Introduction
  •  How to Get the Most Out of This Course
  •  Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
  •  Using Excel Templates to Save Time and Effort
• Section 2: Creating Your First Excel Document
  •  Saving Your Document Where You Can Find It
  •  Entering Data and Navigating Around the Cells
  •  Creating Simple Formulas to Do Powerful Calculations
  •  Working with Workbooks and Worksheets
  •  Put Your Knowledge to Work - Create Your First Excel Document
• Section 3: Create a Kitchen Remodel Cost Worksheet
  •  Introduction - Creating and Formatting Your Heading
  •  Formatting Subheadings and Columns and Alphabetizing Lists
  •  Entering and Formatting Numbers
  •  Create Formulas to Quickly Calculate Your Costs
  •  Formatting - Grids and Spacing
• Section 4: Introduction to Excel Formulas and Functions
  •  Introduction to Excel Formulas and Functions
  •  What is a Formula and What Can It Do for You?
  •  What is a Function and What Does IT Do?
• Section 5: 3 Things to Know Before You Start Using Functions
  •  The Anatomy of a Formula
  •  Quickly Select Cells to Use in Your Formula
  •  Absolute vs. Relative Cell References
• Section 6: How to Use the 7 Most Popular Excel Functions
  •  How to Use the Downloads to Learn Functions Faster
  •  AVERAGE and AVERAGE Functions
  •  COUNT, COUNTA and COUNTBLANK Functions
  •  IF Functions
  •  SUMIF and SUMIFS Functions
  •  COUNTIF and COUNTIFS Functions
  •  VLOOKUP Function
  •  LEFT, RIGHT, and MID Functions
• Section 7: Other Popular Excel Functions
  •  CONCATENATE - Combining Text
  •  LEN - Length of Text
  •  FIND and SEARCH
  •  MIN and MAX
  •  AND and OR
  •  ROUND, CEILING, and FLOOR
  •  TODAY and NOW
  •  CONDITIONAL FORMATTING
  •  ALT Shortcut Keys for INDEX/MATCH Lecture
  •  INDEX and MATCH
  •  UPPER, LOWER, and PROPER
• Section 8: Creating Charts from Your Spreadsheet
  •  Introduction - How to Create a Chart
  •  Format Your Chart
  •  Create a Bar Chart
  •  Create a Pie Chart
  •  Create a Line Chart
• Section 9: Pivot Tables and Pivot Charts
  •  Introduction to Pivot Tables - Preparing Your Data
  •  How to Create a Pivot Table
  •  Put Your Pivot Table to Work
  •  Pivot Charts Download
  •  Pivot Charts