Master the basics of Excel-Level 1


OBJECTIVES




OBJECTIVES
  • Become familiar with Excel's work environment
  • Understand how to operate the menu and Excel tools
  • Establish best practices for creating tables
  • How to make consistent data entries
  • Know the collage options and how to duplicate data
  • Well navigate the screen
  • Be familiar with the basis of printing
  • Learn the basics of Excel's mathematical language


    DETAILED TRAINING COURSE CONTENTS
    • Presentation of Excel's working interface
    • Presentation of Excel's menu and tools
    • Know and use Excel's 3 sliders
    • Know the key manipulations of Excel
      • Selection
      • Editing a cell
      • Use the context menu
      • The cell addresses
      • Validate data inputs
      • Adjust and standardize the width of rows and columns
    • Learn the tools favoring the formatting of cell contents
      • Choose the right digital format of a cell
    • Use tools facilitating the consultation of large charts on screen
      • How to fraction a chart on screen to view information
    • Know the printing tools to print charts
    • The best practices to create charts
    • The foundations of Excel's mathematical language
    • Create automated custom lists to allow entry of uniform data
    • Use Paste Special
    • Know the data recopying options
    • Creation of simple calculations
    • Formatting tables
    • Organize information in a workbook

      TRAINERS


      Mélanie Drainville

      Marlène Villeneuve

      Jean-Philippe Claude




      Newsletter
      Stay tuned for new services and training