Discover Classes. Earn Rewards.
Course Details
Price:
$265 12 seats left
Start Date:

Fri, Oct 04, 8:00am ET - 4:00pm ET

Location:
Interactive Online Classroom
Share:
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 9
System Requirements: To ensure a successful experience, Anywhere LIVE OLT students must have access to a system that meets system requirements.

System Requirements:
  • Windows 7 or later
  • 2 GHz processor or faster
  • 4 GB RAM or more
  • Internet Explorer (IE) 10.0, Firefox, or Chrome
  • Cookies and Session Cookies enabled
  • Dual monitors or two computers - Display – 1280x1024 minimum resolution and High Color (16 bit) display definition
  • VOIP headset with a noise cancelling mic
  • A quiet and private office free from distractions during class sessions
  • ActiveX – Permission to load an ActiveX applet
  • Although Java is not required, the download process is easier if Java is installed and the Web browser supports Java
  • Wired Broadband Internet connection (a minimum of 2.5 Mbps) – experience may vary based on connection speed
  • If your network has a Corporate VPN, you must not be connected to it when you connect to your class
  • You must check both Adobe Connect and LogMeIn prior to class from the system(s) you will be attending, from at the location(s) you will be physically located
Class Delivery: LIVE Online Training (LIVE OLT)
When you attend a LIVE Online Training Class from TLG Learning -- your instructor will be teaching the course LIVE from a remote training center, but your learning experience will be VIRTUALLY the same as if your trainer was present in the room with you.
  • You will hear your remote instructor's live lecture in real time.
  • You will see your remote instructor's slide presentations and demonstrations.
  • You will ask questions and hear questions asked by other students.
  • You will complete your labs exactly as you would in an in-person class.

What you'll learn in this excel class:

Learn the basic functions and features of Excel. Topics include how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. Also learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, printing, and how to manage large workbooks.

Pre-requisite(s): At least one year experience using Windows 10, 8, or 7

Course Outline

Lesson 1 : Getting started
  • Spreadsheet terminology 
  • The Excel environment 
  • Getting help 
  • Navigating a worksheet
Lesson 2 : Entering and editing data
  • Entering and editing text and values 
  • Entering and editing formulas 
  • Working with pictures 
  • Saving and updating workbooks
Lesson 3 : Modifying a worksheet
  • Moving and copying data 
  • Moving and copying formulas 
  • Absolute and relative references 
  • Inserting and deleting ranges, rows, and columns
Lesson 4 : Using functions
  • Entering functions 
  • AutoSum 
  • Other common functions
Lesson 5 : Formatting
  • Text formatting 
  • Row and column formatting 
  • Number formatting 
  • Conditional formatting 
  • Additional formatting options
Lesson 6 : Printing
  • Preparing to print 
  • Page Setup options 
  • Printing worksheets
Lesson 7 : Managing large workbooks
  • Viewing large worksheets 
  • Printing large worksheets 
  • Working with multiple worksheets
Lesson 8 : Appendix - Templates and settings
----note: appendix content is not covered in the one day course
  • Changing application settings 
  • Using built-in templates 
  • Creating and managing templates
Lesson 9 : Appendix - Graphics and screenshots
----note: appendix content is not covered in the one day course
  • Conditional formatting with graphics 
  • SmartArt graphics 
  • Screenshots

Still have questions? Ask the community.

Refund Policy
Open Enrollment Desktop Applications Classes -- You may reschedule or cancel your enrollment in a Desktop Applications class at no charge with at least five (5) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel your registration you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Open Enrollment Technical Training Classes with Level TT1, TT2 or TT3 Tech Pricing -- You may reschedule or cancel your enrollment in a Technical Training Class with Level TT1, TT2 or TT3 Tech Pricing at no charge with at least ten (10) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.
Start Dates (1)
Start Date Time Teacher # Sessions Price
8:00am ET - 4:00pm ET TBD 1 $265

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2650 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at TLG Learning (1)

Similar Classes

School: TLG Learning

TLG Learning

For over 20 years, TLG Learning has been trusted by premier companies and government agencies.

We provide complete learning solutions on Microsoft, F5 Networks, ITIL, Cisco, Citrix, CompTIA, VM Ware, Adobe, Project Management, Business Skills, and more.

During the past 3 years, 99% of over 10,000 TLG...

Read more about TLG Learning

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...