HOME | ABOUT US | CONTACT |

Register Button

Excel Basics



Date: December 21 - 22, 2020
Time: 12:30 p.m. EDT; 11:30 a.m. CDT; 10:30 a.m. MDT; 9:30 a.m. PDT; 8:30 a.m. AKDT
Duration: 4 Hours/Day, plus self-paced on demand
Location: ONLINE - VIRTUAL TRAINING AND SELF-PACED ON DEMAND
Tuition:   $925

Attend this LIVE, ONLINE TRAINING presented by our expert, who will be using all the interactive training tools used in the classroom and more. Youíll be able to ask questions, respond to polls, and collaborate with others. Donít let anything interrupt your training needs. Join us online and experience a different way of learning! Please click here for Virtual Training FAQs.

This unique hybrid class covers all the essentials of Microsoft Excel. Our tech-savvy instructor will lead you through a two-day crash course in Excel where youíll come out feeling like an Excel pro! This introductory class will include topics such as the Flash Fill feature, using formulas and functions, inserting PivotTables and PivotCharts and customizing the interface. Material is also included on how to format text, data and workbooks; insert art and objects; and chart data.

This class is perfect for first-time Excel users or those who want to learn some new tips and tricks. As an added bonus, registrants will receive access to our curated list of self-paced on demand classes to keep the momentum going. These online courses can be accessed from any device at any time, day or night.

T O P I C S   I N C L U D E
The Basics
  • How to sign in
  • Parts of a workbook
  • Opening, creating and saving workbooks
Entering and Working with Data
  • How to enter, select and delete data
  • Undo and redo functions
  • Inserting rows and columns
  • Merging and splitting cells
  • Find and replace function
  • Hiding cells
Using Basic Excel Tools
  • Cell references and formulas
  • Basic formulas
  • Organizing data
Timesavers
  • Autofill
  • Flash fill
  • AutoSum
  • AutoComplete
  • Auto Calculate
Formatting Text
  • Changing font, size and color
  • Applying text effects and borders
  • Font tab
  • Format cells dialog
Formatting Data
  • Adjust text wrapping
  • Adjust cell alignment
  • Text direction
  • Number formatting
Formatting the Workbook
  • Cell styles
  • Format data as a table
  • Workbook themes
  • Page breaks
  • Background images
Inserting Art and Objects
  • SmartArt
  • Text boxes
  • Equations
Charting Data
  • Creating sparklines and timelines
  • PivotTables
  • PivotCharts
  • Slicers
Viewing, Printing and Sharing Your Workbook
  • Saving as PDF or XPS
  • Emailing a workbook
  • OneDrive
Customizing the Interface
  • Changing the ribbon display options
  • Customize Quick Access toolbar
  • Creating custom ribbon tabs

*Topics subject to change.

Click here to find out how you can bring a Falmouth Institute seminar to your location!
© Copyright 2019 | Terms of Use | Privacy Policy