Microsoft Excel Class – Intermediate
$1699.99 - One Day Class
Add More Students:
$60 per each Additional Student
$60 per each Additional Student
6hr Class with 1hr Break
Questions?
(312) 818-5515
How Does it Work?
Request
Request a tutoring session.
Get Confirmation
Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.
Done!
That's it! Enjoy your session at your location!
Intermediate Excel Course Includes:
Calculating Data with Advanced Formulas
- Manage Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Calculate Data in a Table or Worksheet
Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
Analyzing Data Using PivotTables and PivotCharts
- Create a PivotTable Report
- Analyze Data Using PivotCharts
Inserting Graphic Objects
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
Customizing and Enhancing Workbooks and the Excel Environment
- Customize the Excel Environment
- Customize Workbooks
- Manage Themes
- Create and Use Templates
* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
Microsoft Excel Class – Introduction
$1599.99 - One Day Class
Add More Students:
$60 per each Additional Student
$60 per each Additional Student
6hr Class with 1hr Break
Questions?
(312) 818-5515
How Does it Work?
Request
Request a tutoring session.
Get Confirmation
Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.
Done!
That's it! Enjoy your session at your location!
Microsoft Excel Introduction Course Includes
- Starting Microsoft Excel
- The Excel screen
- Using the ribbon
- Using keytip badges
- Minimising the ribbon
- Using shortcut menus
- Launching dialog boxes
- Customising the quick access toolbar
- The office button
- Using the office button
- The status bar
- Customising the status bar
- Exiting safely from Microsoft Excel
Creating a new workbook
- Understanding workbooks
- Using the blank workbook template
- Typing text into a worksheet
- The ‘Save As’ dialog box
- Saving a new workbook
- Typing numbers into a worksheet
- Typing simple formulas in a worksheet
- Easy formulas
- Typing dates in a worksheet
- Easy formatting
- Checking spelling in a worksheet
- Making and saving changes
- Printing a worksheet
- Safely closing a workbook
Working with workbooks
- Opening an existing workbook
- Moving about a worksheet
- Moving about a workbook
- Going to a specific location
- The ‘Open” dialog box
Editing in a workbook
- Understanding data editing
- Overwriting cells contents
- Editing longer cell entries
- Editing formulas
- Editing functions
- Clearing a cell
- Deleting in a worksheet
- Undoing and redoing operations
Formulas and functions
- Understanding formulas
- Creating formulas that add
- Creating formulas that subtract
- Formulas that multiply and divide
- Understanding functions
- Using the SUM function to add
- Summing non-contiguous ranges
- Calculating an average
- Finding a maximum value
- Finding a minimum value
- More complex formulas
- What If formulas
Formula referencing
- Absolute versus relative referencing
- Relative formulas
- Problems with relative formulas
- Creating absolute references
- Creating mixed references
Selecting ranges
- Understanding ranges
- Selecting ranges
- Selecting non-contiguous ranges
- Using special selection techniques
- Selecting larger ranges
- Selecting rows
- Selecting columns
- Viewing range calculation
- Creating an input range
Copying Excel data
- Understanding copying in Microsoft Excel
- Using fill for quick copying
- Copying from cell to another
- Copying from one cell to a range
- Copying from one range to another
- Copying relative formulas
- Copying to a non-contiguous range
- Copying to another worksheet
- Copying to another workbook
Font formatting
- Understanding font formatting
- Working with live preview
- Changing fonts
- Changing font size
- Growing and shrinking fonts
- Making cells bold
- Italicising text
- Underlining text
- Changing font colours
- Changing background colours
- Using the format painter
- Applying strikethrough
- Subscripting text
- Superscripting text
Cell alignment
- Understanding cell alignment
- Aligning right
- Aligning to the centre
- Aligning left
- Aligning top
- Aligning bottom
- Aligning to the middle
- Rotating text
- Indenting cells
- Wrapping and merging text
- Merging and centering
- Merging cells
- Unmerging cells
Row and column formatting
- Approximating column widths
- Setting precise column widths
- Setting the default column width
- Approximating row height
- Setting precise row heights
- Hiding rows and columns
- Unhiding rows and columns
Printing:
- Understanding printing
- Previewing before you print
- Performing a quick print
- Selecting a printer
- Printing a range
- Printing an entire workbook
- Specifying the number of copies
- The ‘Print’ dialog box
* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
HTML Introduction Class
$439.99 - One Day Class
Add More Students:
$60 per each Additional Student
$60 per each Additional Student
6hr Class with 1hr Break
Questions?
(312) 818-5515
How it Works?
Request
Request a tutoring session.
Get Confirmation
Our team member will review your request and get back to you shortly to finalize your appointment. If we are booked for the date/time you specified in your request we'll work with you to find a different date and time that suits you.
Done!
That's it! Enjoy your session at your location!
* 1 student is allowed per tutoring session. If you need more participants rate changes will apply and we need to be notified beforehand.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
* The client must provide suitable and safe work environment for the tutor to be able to provide the training.
Call Us: (312) 818-5515
Average Salaries – City of Chicago Fire Police Department EarningsMarch 21, 2017 - 1:56 am- Average Salaries – City of Chicago Fire Department EarningsMarch 14, 2017 - 4:51 am
Ultimate Google Sheets VLOOKUP Tutorial SeriesMarch 14, 2017 - 4:44 am- Google Sheets SPLIT Function Tutorial – Similar to Text to Columns in ExcelMarch 5, 2017 - 11:46 am
How to Pull Data From Other SpreadSheets using Google Sheets IMPORTRANGE FunctionMarch 5, 2017 - 11:42 am
Locations Serving: Chicago, Loop, Downtown, North, North-East, North-West and West Suburbs, including Evanston, Northbrook, Schaumburg, Hoffman Estates and Naperville IL.