WORKSHOP DETAILS
Microsoft Excel (Beginner - Intermediate) |
|---|
Take your data analysis and spreadsheet skills to the next level with our Microsoft Excel training. Whether you’re a beginner or an Intermediate user, our courses cover essential functions, data visualisation, pivot tables and more. Unlock the full potential of Excel and make data-driven decisions with confidence.
Each booking is for one individual workshop that run for a four-hour duration on the selected delivery date of your choosing. Workshops for Excel commence at 10am - 2.30pm with half hour allocated for lunch at 12.30. Light refreshments are provided with a warm welcoming environment that is sure to enhance your learning experience. Delivery location is at Tai Tokerau Trades Training – 17 Hannah Street, Whangārei 0110. |
Course Content |
|---|
Microsoft Excel (Beginner-Intermediate) Section 1: Getting Started • Microsoft Excel Overview • Accessibility • Terminology • Templates • Workbook Navigation Section 2: Date Entry and Formatting • Auto Fill • Undo, Redo and View settings • Selecting, Highlighting, Moving Data • Cut, Copy, Paste • Rows, Columns, • Text Formatting • Cell Formatting • Merging Cells • Format Painer Section 3: Data Management • Freeze Panes • Manipulating Text with Functions • Removing Duplicates • Search, Find and Replace • Combining Data Using CONCATENATE • Text to Columns • Spellcheck Section 4: Introduction to Formulas and Function • Simple Calculations • Common In-built Formulas Team Rooms • Using IF Function • Using SUMIF and COUNTIF • ROUND and WORKDAY Functions Section 5: Introduction to Data Analysis • Sorting and Filtering Data • Tables • Range Names • Data Validation • Pivot Tables • Conditional Formatting • Charts |
Further Information
Upcoming Dates 2024
Choose one of the following options:
July
Tuesday 9th
Tuesday 23rd
August
Tuesday 6th
Tuesday 20th
September
Tuesday 10th
Monday 16th
Thursday 26th
Booking Information
Once an online booking form has been submitted you will receive and email confirmation of the booking request and payment information.
For group booking [minimum of 5 attendees] alternative date requests can be submitted via the enquiry form on the Elevate Training - Aotearoa home page.
Booking Full Terms and Conditions can be found at the bottom of this Course Details page.
Online Booking Option
Microsoft Excel (Beginner-Intermediate) is also offered through an Online delivery via MS Teams.
On Demand Learning Option
Delivery Information coming soon....
Need More Information - Submit a Microsoft Excel Enquiry
Booking Terms and Conditions
Course workshops may be cancelled, postponed or have their content changed if required at the discretion of Elevate Training - Aotearoa
See our full Terms and conditions.
Latest New Events
