MS Excel Advanced and MS Access Basic

Learn to work with MS Excel and MS Access in this interactive training by Level Up Learning where you will cover all the essential aspects and features of these highly useful applications. 

Topics:

Formulas

• Creating Formulas
• Copying Formulas
• Operators
• Using Operators In Formulas
• Formula Error Messages

Text Functions

• Left; Right; Mid; Len
• Lower; Upper;
• Concatenate

Math & Trig

• Sum; Sum if; Sum ifs;
• Product

Logical Functions

• Using the If Function;
• And; Or funtions

Statistical Functions

• Max, Min Function
• Large, Small Function
• Count, Average Functions

Charts

• Inserting different chart types.
• Resizing and deleting a Chart
• Chart Title or Labels
• Chart Background Color
• Column, Bar, Line or Pie Slice Colors
• Copying and Moving Charts

Setup & Printing Issues

• Worksheet Margins
• Worksheet Orientation
• Worksheet Page Size
• Headers and Footers
• Header and Footer Fields
• Scaling Your Worksheet to Fit a Page(s)
• Printing Titles On Every Page
• Printing the Row and Column Headings
• Spell Checking
• Previewing a Worksheet
• Viewing Workbooks Side By Side
• Printing Options

Input Tables

• One-Input Data Tables
• Two-Input Data Tables.

Manipulating Worksheets

• Copying or Moving Worksheets
• Splitting a Window.
• Hiding Rows, Columns & Worksheets.

Paste Special Options

• Using Paste Special to Add, Subtract, Multiply & Divide.
• Using Paste Special ‘Values’.
• Using Paste Special Transpose Option.

Pivot Tables

• Using a Pivot Table.
• Filtering and Sorting Data
• Grouping Data

Hyperlinks

• Inserting a Hyperlink.
• Editing a Hyperlink
• Removing a Hyperlink

Linking & Embedding

• Linking Data within a Worksheet.
• Linking Cells between Worksheets within a Workbook.
• Linking Data between Workbooks.
• Linking Data from Excel to a Word Document.
• Linking an Excel Chart to a Word Document.
• Updating, Locking and Breaking Links.

Sorting and Filtering Data

• Sorting Data by Multiple Columns
• Custom Sorts
• Customized List
• AutoFilter.
• Top 10 AutoFilter.
• Advanced Filter Criteria.
• Sub-Totaling.
• Removing Subtotals.
• Expanding and Collapsing Outline Detail.

Tracking and Reviewing Changes

• Enabling or Disabling 'Track Changes'.
• Sharing, Comparing and Merging Worksheets.

Scenarios

• Scenario Manager.
• Scenario Summary Reports.

Validating

• Whole Number; Decimal Number.
• List; Date; Time; Text Length
• Validation Input Message and Error Alert.
• Removing Data Validation.

Passwords & Security Issues

• Password Protection.
• Password Protecting Cells and Worksheets.
• Hiding Formulas.
• Un-Hiding Formulas.