670 Courses in Coventry delivered Live Online

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

LOOKING FOR: ADULT FICTION, SCIENCE FICTION / FANTASY After several years spent within publishing houses Bookouture, Canelo, Avon, One More Chapter and Head of Zeus, Hannah Todd became a Literary Agent at the Madeleine Milburn Literary, TV & Film Agency, before joining Janklow & Nesbit in January 2025. Her clients include Kirsty Greenwood, Charlie Gallagher and Leah Mercer. Hannah is keen to see commercial fiction across the board, but with a particular focus on romance, Science Fiction/Fantasy & mystery novels. She is drawn to books with exemplary characterisation, voice and strength of feeling. But don't let your characterisation overshadow the need for impeccable plot and if you can make her laugh or cry then you're onto a winner! Across the full light-dark spectrum Hannah especially loves SFF that features an unlikely band of heroes, like the Six of Crows series by Leigh Bardugo, Scott Lynch's Gentleman Bastard series, Becky Chambers' The Long Way to a Small Angry Planet, T. Kingfisher's Nettle and Bone,and the cosy themes/settings offered by Heather Fawcett and TJ Klune. Hannah's advice is make sure you have a clear USP and hook: If you are sending your reader to a magical academy, or if we're riding dragons or waving wands, that's great! But what makes your book feel different and fresh? An excellent voice is key, but what else makes your take on these tropes stand out? An example of a phenomenal book that has turned the magical academy trope on its head, with layers of excellent world building, a unique magic system and plot twists galore is The Will of the Many by James Islington. If you have something crafted this beautifully then Hannah wants to see it! Romantasy of varying spice levels, accessible to both romance and fantasy readers, is on Hannah's wishlist. And you can whisk her away with contemporary romance novels, romcoms, sweeping love stories that redefine the genre. Romcoms with great disability rep and LGBTQIA+ stories that focus on the joy of falling in love are high on Hannah's agenda. She particularly loves Emily Henry, Laura Wood and Abby Jiminez. Think more Nicholas Sparks than Sally Rooney, and Bonnie Garmus rather than Gabrielle Zevin. In this space, she is a big fan of Emma Donoghue, Bonnie Garmus and Jojo Moyes. Meet with Hannah to discuss your crime and high-concept thrillers with an unsettling ‘it-could-happen-to-me’ feeling, coupled with a twist that's unseen until its delivery. The book she most wants to find in this space is something like Three Hours by Rosamund Lupton in both its themes (real-world emotional suspense) and its execution. A mystery series that feels like a real 'romp' is something she loves to escape with too. With regards to all genres, Hannah is particularly interested in voices from underrepresented backgrounds: such as writers of colour, indigenous communities, the LGBTQIA+ community, and those with disabilities. Hannah does not the right agent to give advice on: Re-imaginings of the classics Books that feature characters putting on Shakespeare plays! Historical fiction Children's, middle-grade and YA Hannah would like you to submit a covering letter, one page synopsis and the first 5,000 words of your completed manuscript in a single word document. (In addition to the paid sessions, Hannah is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 4th August 2025

Expand your Excel knowledge and learn how to structure and analyse large data sets.

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers