Show navigation

Available in:

Online Manual

Microsoft® Excel®

Get the tips and tricks to customize Excel® and boost your productivity. Start using the full power of Excel®, and learn cool Excel® tips that will make you the go-to person in your office. These reference materials will focus on the five Fs of Excel®: formatting, fills, formulas, functions and filters. You will learn how to organize and optimize worksheets and workbooks; analyze Excel® data through scenario manager, subtotals, pivot tables and charts; and discover the invaluable use of the SUM, AVERAGE, COUNT, TODAY, PMT, VLOOKUP, CONCATENATION and IF error functions. These reference materials will guide you through the creation of a budget and expense workbook as well as creating a financial workbook. In addition, they will cover best practices for using, analyzing and manipulating data in tables and databases and also tips on setting-up workbooks for printing and viewing. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week using Microsoft® Excel®. Upon completion of this course, you will be able to: •Create an Excel® workbook with several worksheets •Use productive shortcuts and time saving features •Increase productivity through fills and custom lists •Build formulas and functions •Creating and editing charts •Analyze data through scenario manager, pivot tables and subtotals •Construct formulas and functions, including SUM, VLOOKUP, CONCATENATION and PMT •Customize Excel® for efficiency and ease-of-use •Save time through creating and editing macros Learning Objectives •You will be able to discuss formatting. •You will be able to explain autofill and the filling series. •You will be able to identify functions. •You will be able to describe filters and sorts.
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Agenda

Lesson 1: Introduction to the Excel® Environment
  • Using the Interface, and Tips and Tricks
  • Using Autocalculate and the Status Bar
  • Creating a Workbook and Renaming Worksheets With Tab Colors
  • Tips and Tricks – Keyboard Shortcuts and Quick Access Toolbar
Lesson 2: Formatting
  • Merge and Center, Alignments
  • Orientation and Special Formats
  • Custom Formatting
  • Comments – Inserting, Editing, Viewing and Printing Comments
Lesson 3: Autofill and Filling Series
  • Using the Autofill Option For
    • Text
    • Dates
    • Numbers
    • Custom Lists
    • Formulas and Functions
Lesson 4: Formulas
  • Syntax and Symbols for Formulas
  • Creating Formulas
  • Overview of Relative, Absolute and 3-D References
  • Create a Difference Formula
Lesson 5: Functions
  • Create Autosum Function
  • Create Average Function
  • Create Count Function
  • Use Today Function
Lesson 6: Filters and Sorts
  • Introduction to Creating and Importing Databases in Excel®
  • Filtering for One or More Criteria
  • Sorting by One or Multiple Criteria
  • Important Gotcha's in Sorting, Filtering and Using Excel® as a Database
Lesson 7: Worksheet Organization, Excel® Options and Autocorrect
  • Worksheet Organization – Moving, Copying, Coloring and Grouping
  • Setting Important Options in Excel®
  • Using Autocorrect
Lesson 8: Excel® as a Database: A Financial Workbook
  • Using Freeze Panes and Split Panes
  • Creating a Loan Calculator With the PMT Function and Financial Formulas
  • Apply and Use the Name Box and Name Manager for Navigation, Formulas/Functions and Other Productive Features
  • Analyzing Financial Data With the Scenario Manager
Lesson 9: Data Analysis Using Excel's® Pivot Tables and Subtotals
  • Analyze and Manipulate Data Through Pivot Table Reports
  • Analyze Data Using Various (Sum, Average and Count) Functions in Pivot Tables
  • Create a Pivot Chart
  • Add, Edit and Remove Subtotals in a Worksheet
Lesson 10: Charts
  • Understand the Gotcha's With Charts and How to Create Them With Ease
  • Create, Edit and Customize a Pie Chart and Column/Bar Chart
Lesson 11: More Functions
  • VLookup/HLookup
  • Concatenation and Text-to-Columns
  • Date Functions
  • IF, THEN, ELSE
Lesson 12: Macros and Custom Command Buttons
  • Creating Various Macros, Including a Formatting Macro and Multiple Sorts
  • Editing a Macro
  • Running Macros Through Keyboard Shortcuts and Your Custom Buttons
Overview of Excel 2013 and Excel® Web App
  • What's New in Excel® 2013
  • Using Excel's® Web App and Office 365 on Any Device
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Credits

Online Manual

This program does NOT qualify, nor meet the National Standard for NASBA accreditation.

Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Faculty

Greg Creech

Greg Creech

Techedutainment Services, Inc.

  • President/owner of Techedutainment Services, Inc.
  • Presenter on technology, humor/music, and career and stress management
  • 2009 Association of Continuing Higher Education Faculty Award for Southern Region for work at Emory University
  • 2007 University of Continuing Education Association top noncredit programs for the Southern Region
  • Microsoft® Certified Application Specialist – Instructor
  • CompTIA Certified Technical Trainer + and A+ Systems Technician
  • B.A. degree in political science, cum laude, University of South Carolina
  • Can be contacted at 404-299-1706, [email protected], or www.gregcreech.com
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today
With This Course

Access to all training products for one year
$699/year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.

Product ID: 390646
Published 2013
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!