+91 72087 69880 info@landdedutech.com
Follow us:
Basic Excel

Duration: 7 Hrs

INTRODUCTION

  1. An overview of the screen, navigation and basic spreadsheet concepts
  2. Various selection techniques
  3. Shortcut Keys

CUSTOMIZING EXCEL

  1. Customizing the Ribbon
  2. Using and Customizing AutoCorrect
  3. Changing Excel’s Default Options

USING BASIC FUNCTIONS

  1. Using Functions – Sum, Average, Max,Min, Count, Counta
  2. Absolute, Mixed and Relative Referencing

FORMATTING AND PROOFING

  1. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  2. Basic conditional formatting

MATHEMATICAL FUNCTIONS

  1. SumIf, SumIfsCountIf, CountIfsAverageIf, AverageIfs

PROTECTING EXCEL

  1. File Level Protection
  2. Workbook, Worksheet Protection

TEXT FUNCTIONS

  1. Upper, Lower, Proper
  2. Left, Mid, Right
  3. Trim, Len, Exact
  4. Concatenate
  5. Find, Substitute

DATE AND TIME FUNCTIONS

  1. Today, Now
  2. Day, Month, Year
  3. Date, Date if, DateAdd
  4. EOMonth, Weekday

ADVANCED PASTE SPECIAL TECHNIQUES

  1. Paste Formulas, Paste Formats
  2. Paste Validations
  3. Transpose Tables

New in Excel 2013 / 2016 & 365

  1. New Charts – Tree map & Waterfall
  2. Sunburst, Box and whisker Charts
  3. Combo Charts – Secondary Axis
  4. Adding Slicers Tool in Pivot & Tables
  5. Using Power Map and Power View
  6. Forecast Sheet
  7. Sparklines -Line, Column & Win/ Loss
  8. Using 3-D Map
  9. New Controls in Pivot Table – Field, Items and Sets
  10. Various Time Lines in Pivot Table
  11. Auto complete a data range and list
  12. Quick Analysis Tool
  13. Smart Lookup and manage Store

Sorting and FILTERING

  1. Filtering on Text, Numbers &Colors
  2. Sorting Options
  3. Advanced Filters on 15-20 different criteria(s)

PRINTING WORKBOOKS

  1. Setting Up Print Area
  2. Customizing Headers & Footers
  3. Designing the structure of a template
  4. Print Titles –Repeat Rows / Columns