Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments
Modular laparoscopy course with stepwise curriculum. At home laparoscopy trainer for the duration of the course with hands on sessions followed by final assessment away day over 5 months. Integrated online curriculum via the CCMIG website.
Develop your technical report writing and presentation skills with EnergyEdge's course designed for oil & gas professionals. Sign up now!
Dog trainer, beginner lever for dogs 10 months and older. This 6 week course where the classes encompasses a comprehensive range of essential skills and behaviours. You will attend 6 x 45-minute training classes Ruby's Yard, The Boat Yard, Slack’s Avenue, Atherstone, England, CV9 2AR.
Enhance your knowledge in marginal field development and planning with EnergyEdge's course. Enroll now to gain valuable insights.
Dive deep into seismic stratigraphic interpretation in various basin settings with EnergyEdge's specialized course. Enroll in our classroom training today!
Dive deep into petrophysics, log analysis, LWD, and wireline techniques with EnergyEdge's specialized course. Enroll today!
CPD accredited Level 3 Train the Trainer, Speaking & Presenting Skills course. Delivered online (Zoom) by a live tutor. Exam and Certificate fee included in the price.