catraining

 

Microsoft Partner
Microsoft Excel Database Tools

Audience: Those who need to use database tools to manage information stored in Excel worksheets. This course covers data sorting, creating forms to add, delete and change data. And how to use search criteria to generate reports.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsft Excel Database Tools training course is delivered at our training centre in London situated close to Liverpool Street station, training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Capture data for analysis
    • Manage the screen display
    • Create formulas to aggregate data
    • Enter data using the Data Form
    • Sort data
    • Calculate SubTotals
    • Use different methods of filtering data

  • Course Outline
    print this page
    Module 1: Data capture
    • Data Validation
    • Excel Ranges or Tables?
    • Converting a range to a table
    • Using Text to Columns to split data
    • Remove Duplicates
    Module 2: Managing the display
    • Freeze Panes to lock the header rows or left-hand columns
    • Grouping data to hide and show columns
    Module 3: Data formulas
    • Structured formulas
    • SUMIFS and COUNTIFS
    • DSUM, DCOUNT, DCOUNTA, DMIN, DMAX
    Module 4: Data Form
    • Entering and editing records with Excel’s Data Form
     
    Module 5: Sorting
    • Multiple-key sorts
    • Sorting using a Custom List
    • Sorting columns
    • Sorting based on cellcolour, font colour or icon
    • Removing space characters
    Module 6: SubTotals
    • Single and multiple-level Subtotals
    • Using the Outlining symbols
    Module 7: Filtering
    • AutoFilter
    • Creating simple and compound criteria for filtering data
    • Filtering tools for Text, Number and Date fields
    • Using Advanced Filter to overcome the limitations of AutoFilter by using complex and calculated criteria
     
      Microsoft

Call us now for further information Tel:08001601666