Excel

by Computer Resource Center Claim Listing

Basic spreadsheet navigation, entering and editing data, formatting, and introduction to formulas and functions (simple math, sum, average). Covers working with multiple sheets and data sorting/filtering.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Computer Resource Center Logo

img Duration

Please Enquire

Course Details

Basic spreadsheet navigation, entering and editing data, formatting, and introduction to formulas and functions (simple math, sum, average). Covers working with multiple sheets and data sorting/filtering.

Chart wizard is introduced (as time permits). Students learn how to format a table for impressive printouts, including fonts, lines, borders, shades, headers and footers, and sizing to fit. [Recommended 2 to 3 hours]

Excel Formulas and Functions (Intermediate). Assumes you know everything mentioned above. Session is geared toward moving users past "sum," with more advanced formulas such as those used to calculate percent distributions (including absolute cell references) and functions covering a variety of areas (date/time, financial, text, statistical).

Focuses on more advanced math ("if" statements; count, counta, countif; math with date/time; calculating interest; depreciation). Includes links across multiple tables and to other files and programs. Graphing is covered in detail, as well as sparklines and use of themes. Finally students learn how to link tables for automatic updates. [Recommended 2 to 3 hours]

Excel Power Features. Session begins with Excel shortcuts such as Flash Fill and forecast sheets. Next, database functions such as text-to-columns, concatenate, proper, filters, and grouping/subtotals are explained. Session includes with tools such as data validation (including creating drop-down menus), consolidate, goal seek, and scenarios (storing multiple numbers within one cell). [Recommended 2 to 3 hours]

Excel Pivot Tables and Vlookups. This session is entirely devoted to two operations. Pivot tables are explained, first with a simple consolidated table, then with a more complex set of data. Pivot tables are then displayed as pivot charts, and analyzed with the Excel slicer and timeline features.

It concludes with an introduction to Vlookups and Hlookups, which are functions that makes Excel search for a certain value in a column or row in order to return a specific value. [Recommended 2 hours]

  • Chicago Branch

    1525 East 53rd Street, Suite 930, Chicago

Check out more MS Excel courses in USA

PD Training Logo

Microsoft Office 365 Lync Essentials Training

Microsoft Office 365 Lync is the instant communications component of Microsoft Office 365. Learn how to use Lync for online meetings, instant messaging, audio and video calls and other functions by attending PD Training’s Microsoft Office 365 Lync Essentials Training course.

by PD Training [Claim Listing ]
American Graphic Institute Logo

Access Training

Learn Microsoft Access foundations in this introductory Access course. This course teaches the essentials of Access and working with relational databases.

by American Graphic Institute [Claim Listing ]
Softek Services Logo

Introduction to Microsoft Word

This instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to create and edit documents, format text, and format pages in Microsoft Word.

by Softek Services [Claim Listing ]
The Code Academy Logo

MOS: Word 2016

In this course, you will learn fundamental Word 2016 skills. You will: Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.

by The Code Academy [Claim Listing ]
Lehman College Logo

Microsoft Excel (Part 1)

Microsoft Excel is a spreadsheet program that is a must for accountants, office workers, and marketing managers. Personal uses include budgeting and data tracking.

by Lehman College [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy