At Baruch College
|
+ |
|
|
|
Microsoft Word 2013 - Basic |
Microsoft Excel 2013 - Basic |
|
This course covers the basic features of Word 2013. Learn
how to navigate documents, enter, edit and format text, as well as convert
various file formats. You will also learn how to create tables, graphics,
headers and footers, as well as proof/print documents. Students enrolling in
this course must have mouse and keyboard proficiency navigating the Windows
environment. |
This course covers the basic functions and features of
Excel 2013. You will learn how to navigate workbooks, use absolute and
relative references as well as SmartArt and conditional formatting.
Navigation and printing strategies for larger workbooks are covered as well
as charting. Students enrolling in this course must have mouse and keyboard
proficiency using the Windows environment. |
|
Job Hunting Tip: When
and How to Follow Up After an Interview Programming Tip: |
|
|
MS Excel 2013 - VBA Programming |
Microsoft Access 2013 – Basic |
|
Experienced Excel 2013 users will gain hands-on experience
using Visual Basic for Applications to create programs that run in response
to specific conditions. You will develop
control structures, user screens to accept and validate data entry as well as
debug code errors. Prerequisite: Microsoft Excel 2013 Advanced or equivalent
experience. YOU MUST UNDERSTAND ABSOLUTE REFERENCES AND NAMED RANGES TO
SUCCEED IN THIS COURSE. |
This course covers
the basic data management features of Access 2013. After an introduction to
the Access environment, you will design and create databases, tables, and
fields. Sorting, filtering, setting field properties and creating data entry
rules are covered. You will also create queries, forms, and reports. Students
enrolling in this course must have mouse and keyboard proficiency navigating
the Windows environment. |
|
Career Tips: |
|
|
Microsoft Project 2013 |
Microsoft PowerPoint 2013 |
|
This class covers the elements of project planning,
establishing resources and task assignments. Project plan formatting,
tracking progress, working multiple projects and integrating MS Project with
other programs; fine-tuning task and resources; optimizing project plans;
coordinating resource pools; and consolidating projects. Prerequisite:
Students enrolling in this course must have mouse and keyboard proficiency
navigating the Windows environment, expertise working with the clipboard,
files, folders, and zipped folders. |
This
course covers the features of PowerPoint 2013; creating, editing and
formatting presentations. You will use drawing objects,
work with graphics, tables and charts. Templates, themes, slide masters, and
transition effects will also be covered. Finally, you will proof, run, and
print presentations. Prerequisite: Personal Computers An Introduction or
equivalent knowledge. Students enrolling in this course must have mouse and
keyboard proficiency navigating the Windows environment. |
|
On-The-Job Tip: |
|
|
Microsoft Word 2013 – Intermediate |
Microsoft Word 2013 – Advanced |
|
This course builds on the skills covered in Word 2013
Basic. Here you will work with styles, sections, and columns and will use the
Navigation pane to work with outlines. Formatting tables, graphics, labels
and envelopes are also covered. You will also learn how to use document
templates and Web features. Prerequisite: Word 2013 Basic or equivalent
experience. |
In this class you will perform mail merges, create forms,
master documents and PDF files. Tables
of contents, indices and cross-references are also covered. You will create
macros, customize the ribbon, the quick access toolbar and add footnotes,
endnotes and figures to documents. Prerequisite: Word 2013 Intermediate or
equivalent experience. |
|
Visit
www.baruched.com for more classes |
|
|
Microsoft Excel 2013 – Intermediate |
Microsoft Excel 2013 – Advanced |
|
This course builds on the material in the Excel 2013 Basic
course. In this class you will use styles, themes and backgrounds and
integrate them into larger workbooks. You will also create outlines and
subtotals, apply cell names, and work with tables. This course will also
cover advanced charting, Sparklines and templates.
Prerequisite: Excel 2013 Basic or equivalent experience. |
In this class you will work with advanced functions such
as vlookup, hlookup,
match and index. Learn various ways of validating numeric and text data to
avoid input errors. You will import and export various data types and work
with pivot tables and macros. Goal Seek, Solver and conditional formatting
are also covered. Prerequisite: Excel 2013 Intermediate or equivalent
experience. |
|
Microsoft Access 2013 – Intermediate |
Microsoft Access 2013 – Advanced |
|
This course builds on the skills covered in Access 2013
Basic. Here you will learn about managing table relationships and enforcing
referential integrity. You will create lookup fields, subdatasheets, join
queries, and summary values. Adding objects to forms and creating advanced
form types are also covered. Finally, you will create advanced reports,
charts and PivotTables. Prerequisite: Access 2013 Basic or Equivalent
experience. |
In this class you will learn how to query tables using
SQL, create crosstab, parameter, and action queries. In addition to learning
how to create macros, you will import, export, and link various database
objects. You will add hyperlink fields; optimize, split, and protect
databases. Setting application-wide Access options and properties are also
covered. Prerequisites: Access 2013 Intermediate or equivalent experience. |
|
Enroll now at www.baruched.com or call 646-312-5000 |
|