NO PAYPAL, NO PROBLEM! Contact us at 09771031800 or www.facebook.com/InsightsManila for other payment methods.
The Basic to Advanced MS Excel course will level up your skill in order to efficiently process data in the spreadsheet. This course goes beyond VLOOKUP-- you will learn to look up data regardless of data orientation. You will also learn how to make advanced pivot table features such as Calculated Fields, Slicers, etc. Excel 2007, Excel 2010, Excel 2013, Excel 2016
Notes:
1. Bring own laptop
2. Lunch included
3. Handouts and certificate will be given
Module 1: Quick Review of Basic Functions
Text Functions UPPER LOWER PROPER LEFT RIGHT MID CONCATENATE
Basic Logical Statements IF
Basic Math Functions SUM AVERAGE
Basic Lookup Functions VLOOKUP
Combining Functions
Module 2: Advanced Excel Functions
Text Functions TRIM, SUBSTITUTE
Combing Logical Tests using AND and OR
Advanced Math Functions SUMIFS, COUNTIFS, AVERAGEIFS
Advanced Lookup Functions: INDEX and MATCH
Module 3: Advanced Data Tools
Creating Own Conditional Formatting
Data Validation with Formulas
Subtotal Tool
Module 4: Advanced PivotTables
Review of Basic PivotTables
Grouping
Slicers
Calculated Fields
PivotCharts
If time permits: Macro Recording
Tickets left at the box office for collection may be picked up on the day, during the hour before the performance starts. Please take the credit card used to make the booking and the Ticketmaster booking reference number as proof of purchase.
Ticketmaster UK: 0870 154 40 40, International: 00 44 161 385 3500
Monday - Saturday 10:00 - 18:00 and occasionally on Sunday.
Infra red hearing system with no deposit required. For special needs seating please call 0844 412 4648. Disabled toilet situated in the rear Stalls with ground level access There is no limit to the amount of Guide Dogs (within reason of course)
ANATOMY LAB LIVE | CONTAGION
Anatomy Lab LIVE is returning for 2020 with CONTAGION.
INFECTION - DINNER - DISSECTION
‘The post-antibiotic era is dawning’
The nationally acclaimed dinner and dissection experience attracted headlines around the world and after three amazing sell out tours we’re back for 2020 with Contagion.
Anatomy Lab LIVE 2020 ‘contagion’ is going to be really exciting. The 2020 event will delve into how infections affect the organs and tissues of the human body.We’ve only had antibiotics for just over 80 years and we’re already facing the stark reality of their overuse. As strains of bacteria evolve with resistance, how will we treat the infections of the future? We’ll be asking are the Hollywood style apocalypses possible? How are infections transmitted and what do they do to the body?We invite you to suit up, and step into a fully working decontamination tent where you’ll work with real specimens to learn more about infectious diseases, their affect on the body and how science is preparing for when things inevitably go wrong.
“We're really excited to release the contagion tour in 2020. This will be a perfect blend of infotainment that will promise and unforgettable night like never before. We urge you to get your tickets as soon as possible as the last three tours have sold out within a few hours! ” Samuel Piri
Who can attend?
The event delivers in-depth content aimed at those studying anatomy, physiology or pathology at undergraduate level and for those who are already practicing healthcare professionals. The event is also a great experience for any person who is interested in the human body, disease or medicine on the whole. The wider general public are also encourage to attend.
How do I get a ticket?
New for 2020.... bookings can be secured for a 33% deposit. If you choose the installment plan, we will email you before each deadline to remind you to pay the next installment on this event listing. Deposits are non refundable and must be paid on booking (before 1st July 2019). The remaining balance must be paid before the 30th August.
Deposit £30 + later installment £60
Standard tickets £81.99
NHS ticket £72.99
NUS tickets £72.99
Group tickets for 10 people, (prosecco reception, upgraded nitrile glove packs, Anatomy lab live notebook and pencils) £919.00 (or £879 for a table of NHS staff, students, armed forces employees, University Staff or Teachers)
Overnight Package for 2 people includes prosecco meet and greet, upgraded nitrile gloves and a room for two people (double or twin) and breakfast £350.00
Full details and terms and conditions can be found online.
You will receive a certificate for attending which can be used for your own CPD.
This is a highly recommended event which made headline global news. We recommend booking tickets early as they will sell out.
Student and NHS discount available (proof will be required for admission into the venue).
The meal option is chicken or vegetarian, you will need to contact Anatomy Lab Live after purchasing the ticket to request a vegetarian meal. Chicken will be served by default.
NB: All tickets are non-transferable and non-refundable.
Cash, Visa, MasterCard, American Express, Discover
Located at the South Box Office and opens 2 hours prior to event and will remain open until 1 hour after each event starts. Customer must present credit card used for the purchase, photo I.D, and Ticketmaster account confirmation number.
Main Number : 954-835-8000 Panthers Groups, Suites and Ticket Packages : 954-835-7825 Concert and Event Tickets: 954-835-7469 For the Metro by T-Mobile Orange Bowl Basketball Classic call 305-341-4701
Mon - Fri: 9:00am - 5:00pm Sat - Sun: CLOSED, except when an event is taking place on that day. Event day hours (Sat - Sun):12noon to 1 hour after event starts.
The center is an accessible venue.
All major credit cards
Collect from the Waterfront Box Office located in the foyer during the hour prior to performance.Take the credit card and Ticketmaster reference number.
02890 334455
Hours: 10am-5pm Mon-Sat (or until 9pm on event nights). Closed on Sundays and public holidays (except event days when patrons should check with Box Office for opening hours).
* The venue is accessible to wheelchair users and those with special needs. * Please call the Box Office number: 00 44 2890 334455 for further details For any additional accessible information please take a look at the venues disabled access guide http://www.waterfront.co.uk/visitor/disabledaccess.aspx
All Major Credit Cards
Will Call Is Open For Pick Up 2 Hours Prior To The Event Start Time
Toll Free Box Office Number : 877 632-7400
10:00AM - 8:00PM
This Venue Offers Accessible Seating In All Price Levels. Please contact the box office at 877-632-7400 for accessible seating. Accessible Seating May Be Purchased at the Box Office
This course is ideal for
This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes.
What you will learn
Build complex calculations with advanced functions.
Link, export and consolidate data.
Limit data entry and build complex models with Lookup functions.
Analyse data with simple PivotTables and PivotCharts.
Create and modify Macros.
Topics covered in this training course
Protecting your data
Workbook protection
Protecting cells
Protecting structure
Circular references
Locating and deleting circular references
When circular references are necessary
Formula error checking
Range names
Defining range names
Using names in formulas
Navigating with names
Using named constants
Documenting range names
Functions
Math and rounding functions
The AND function
The OR function
Nested IF function
The VLOOKUP function
The HLOOKUP function
Transposing data
Concatenating functions
INDEX and MATCH functions
Using help for functions
Data Validation
Limiting cell values
Creating drop-down cell lists
Validation error messages
What-if analysis tools
Using goal seek
Importing data
Importing CSV files
Text import wizard
Workbook linking
Workbook linking
Dealing with broken links
Data consolidation
Consolidation by cell position
Consolidation by headings
Exporting data
Saving as a different file type
Exporting to Word
Pasting data with a link
Copying a graph with a link
PivotTable reports
Create a PivotTable
Rearranging data
Applying filters
Adding fields
Modify field settings
Refreshing data
Formatting a PivotTable
PivotCharts
Creating a PivotChart
Filtering a PivotChart
Macros
Recording a Macro
Editing a Macro
Relative/Absolute Recording
Stepping through a Macro
Macro buttons
Customising the toolbar
Writing a line of code
Deleting a Macro
Cash and All Major Credit Cards
MUST HAVE PHOTO I.D. & CREDIT CARD USED TO PURCHASE TICKETS WHEN PICKING UP WILL CALL TICKETS
702-693-6143 1-855-234-7469 Group Sales (20+)
Opens one hour prior to the first show and closes a half hour after the last show.
To better accommodate your needs the box office has requested that special seating accommodations be solicited through their representatives
Cash - Visa - MasterCard - American Express - Discover
The Will Call Booth at Highmark Stadium is located in between gates 3 and 4. Guests may pick up their pre-paid tickets on game day. This location is open 4 hours prior to kickoff. PROPER PHOTO IDENTIFICATION IS REQUIRED. Tickets will only be released to the person who purchased the tickets.
1-877-BB-TICKS (228-4257)
Box Office Hours Season Hours: 9am - 5pm, Monday - Friday 9am - 1pm, Saturdays before home games Open 4 hours prior to kick off on game days through the end of the 3rd Quarter Off Season Hours: 9am - 5pm, Monday - Friday For Buffalo Bills Tickets Only.
Available at the Box Office and through Ticketmaster. Phone #: 1-877-BB-TICKS (228-4257) https://www.buffalobills.com/tickets/policies