NYC: Beginner Excel Corporate Training

Description

Learn Excel calculations, functions, charts, formatting and printing in a workshop for beginners.

Hands-on learning
Each concept includes instruction, a demonstration and independent practice. Keep the course materials for reference.

Excel tutorial videos
After Excel Level I, access beginner video tutorials on a computer, smartphone or tablet.

Key Topics Covered at a Glance

• Get acquainted with the Excel software interface and data input methods
• Discover core formulas and fundamental built-in functions
• Apply professional formatting and execute printing. Construct various chart types, such as line, column, and pie visualizations
• Explore helpful strategies and techniques for streamlined spreadsheet administration
• Complete a comprehensive project that consolidates essential lesson topics

Complete Course Outline

Getting Started

• The Application Interface
• A comprehensive overview of the Microsoft Excel user interface and its primary components

• Managing Spreadsheet Sheets
• Learn to control and modify worksheet components and structure

• Information Entering Processes
• Investigates and clarifies multiple approaches to inputting and managing data

• Managing Table Rows and Columns
• Add new rows or columns, eliminate existing ones, conceal them, or arrange them into organized groups

Function and Formula Development

• Smart Fill Capabilities
• Demonstrates Excel's powerful functionality for identifying and continuing data sequences

• Mathematical Operations
• Execute mathematical computations and apply the correct Order of Operations principles

• Sum and Aggregation Functions
• Examine the five most important functions: Sum for totals, Average for mean values, Max for highest values, Min for lowest values, and Count Numbers for cell quantity

• Fixed Cell Addressing
• Transform a cell reference into a permanent constant, which is essential for particular computational situations

• Conditional Verification
• Performs validation checks to determine if stated conditions are satisfied or unsatisfied

• Character String Manipulation
• Introduces functions designed for adjusting and transforming textual information in spreadsheets

• Advanced Multi-parameter Functions
• More sophisticated functions that require multiple separate inputs or arguments

Visual Formatting and Presentation

• Visual Enhancement Techniques
• Adding visual effects and styling to an Excel file to deliver clear visual guidance

• Standardized Cell Formatting
• Apply standardized visual treatments to particular categories of cells or numeric values

• Rules-Based Automatic Formatting
• Set up automatic formatting that is applied based on predetermined requirements

Graphing and Data Tables

• Converting to Data Tables
• Understand the unique capabilities and advantages that emerge when spreadsheet information is structured as a Table

• Vertical Bar Chart
• Create a Vertical Bar chart to display and examine data visually

• Trend Line Chart
• Create a Trend Line chart and compact Spark lines to display and examine data visually

• Circular Distribution Chart
• Create a Circular Distribution chart to display and examine data visually

Advanced Spreadsheet Management

• Lock Specific Window Areas
• Maintain visibility of a designated area while scrolling through the rest of the spreadsheet

• Output to Physical or Digital Format
• Best practices and approaches for producing physical or digital copies of your spreadsheets

• Display Modes for Worksheets
• Modify the way your spreadsheet displays information based on your preferences

• Pre-Designed Spreadsheet Formats
• Leverage existing spreadsheet designs and formats to begin building your own files quickly

• Productivity Tips and Shortcuts
• Key keyboard combinations and advanced Excel techniques for increased efficiency

Culminating Projects and Assessments

• Capstone Assignments
• Complete assignments at the end of the course to practice and reinforce important concepts from the training

Organizational training
Group vouchers let employees choose weeknight, weekday or weekend classes live online or at our Manhattan location. Larger purchases include a voucher management portal. Employees select sessions by skill level, schedule and location.

Certified instructors teach practical workplace tasks, with course resources yours to keep. Private curricula can be customized for your office, our Midtown Manhattan venue or live online delivery.

Note About Scheduling:

• The course schedule incorporates a one-hour lunch break in the middle of the day.
• We can arrange the training at your office location within the greater New York metropolitan region at no extra charge.