670 Courses in Nottingham delivered Live Online

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

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

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

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