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.
DurationBasic 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]
Providing software training since 1991, the Computer Resource Center is located in the Hyde Park neighborhood on the near South Side of Chicago. It offers instruction for the most popular software programs.
Including Microsoft Office (Word, Excel, PowerPoint, Access, and Outlook) as well as Adobe Creative Cloud (Photoshop, Illustrator, InDesign, Acrobat, and Dreamweaver). One-on-one training is available at our office in Hyde Park or virtual group training can be provided using Zoom.
This comprehensive hands-on course teaches you how to use Microsoft Visio to create professional diagrams to visualise complex systems, sharpen communication and fine tune business processes. You will practice building both simple and complex diagrams, using templates, shapes and Smartshapes.
The leader in creating spreadsheets and data presentations. Topics include basic worksheet navigation, entry techniques, cell references, using the command groups and settings, formulas and functions, charts and graphs, and simple database operations.Â
This course is a follow-up to the Access 4-day Intensive and is designed to teach the skills needed in order to program databases in Microsoft Access.
In addition to basic formatting you'll learn how to cut & paste, copy and paste, set margins, line spacing, justification, add graphics, add borders & shading, add bullets & numbers, run Spell Checker & Grammar Checker, use the Thesaurus, add Special Symbols, use Find & Replace, and more!
Using a spreadsheet has become a part of a lot of people’s work. But it is also where many struggle due to not having the necessary skills to use it correctly.This 2-day course will give you confidence and skills to use an Excel spreadsheet to enter, change and analyse information necessary to do...
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the USA, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan