- Location: Montrose Place, Cnr Pasita & Bella Rosa Street, Rosenpark Bellville,
- Duration: 1 Day
Course details
This one-day workshop is designed to help delegates to understand the importance of databases and to use it optimally in Excel. They will also be introduced to Pivot Tables concepts, from basic to advanced.
Course Outline
Module 1
- Databases
- Creating a Database
- Applying a Table Style to a Database
- Naming a Database
- Format & Edit a Database
- Sorting a Database
- Numbers & Alphanumerics
- Sorting in a Special Order
- Multiple Sorts
Module 2
- Find and Edit Data
- Find and Edit Data across Several Sheets
- AutoFilter
- Top Ten AutoFilter
- Custom Filter (And/Or)
- Advanced Filter
- Using the Advanced Filter to Copy Data to an Extract Range
- Use the Advanced Filter to Extract info to a Different Sheet
- Filter Unique Records Only (Duplicates)
Module 3
- PivotTable Terms
- Create PivotTables
- Modify PivotTables
- Adding Data Fields to a PivotTable
- Hiding Data Fields in a PivotTable
- Unhiding Data
- Removing Data Fields from a PivotTable
- Grouping Items in a Field
- Create Report Filters
- Create Separate Pages
- Display Report Filters on Separate Sheets
- Format a PivotTable (Numbers / Tables)
- Changing the Data Source Range
- Using Datatables to create PivotTables
- Calculations in a PivotTable
- Create a Calculated Field
- Refresh the PivotTable Data
- Extract PivotTable Data
- Showing Underlying Details
- Report Layouts
- Insert Blank Rows in a Report
- Switch Field Headers On and Off
- Switch Subtotals On and Off
- Chart a PivotTable
- Formatting Pivot Charts
- Changing Pivot Chart Options
Course Location
About Presentation Software Training
Presentation Software Training is a dynamic and innovative training centre committed to providing our clients with the best service. We specialise in Computer Skills, Staff Development Workshops (Soft Skills) and Occupational Health and Safety training courses. Short courses with Long Term Benefits.
Furthermore we develop and deliver tailor-made training to respond to organisational specific training needs. With years of experience in training and business presentations, Marilee Laubscher, the founder member is in a position to advise,, train and assess individual andcompany needs.
Presentation Software Training is a name you can rely on when it comes to training. We have been offering short courses to the business sector and the general community for the past 20 years.
See all Presentation Software Training courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Intermediate Certificate New Skills AcademyZAR 435
ZAR 5,414Duration: Upto 10 Hours - ZAR 380Duration: Upto 1 Hour
