Essential Excel Formulas & Functions

G Com Solutions provide scheduledPower BI trainingin London as well as on-site Power BI courses all over the UK. At G Com Solutions, we are great believers in the philosophy of learning by doing. Our courses are designed to be relevant to our clients requirements and are delivered with a practical, hands-on approach which challenges delegates and reinforces the topics being taught.Whether you need Power BI training as a Power BI specialist or as one of the many people who need Power BI training to improve their skills for career advancement, G Com Solutions courses can help you.

G Com Solutions Limited

<P CLASS="MsoNormal"><SPAN STYLE="line-height: 1.6em;">Understanding Excel formulas is essential if you plan to create sophisticated and reliable spreadsheet solutions.</SPAN></P>
<P CLASS="MsoNormal">If you feel less than confident about how Excel formulas work, and how to create your own formulas from scratch, then this is the course your need! Essential Excel Formulas and Functions by G Com Solutions examines all of the key elements which go together to make up an Excel formula. The course uses real-world examples to illustrate how to build formulas that solve problems and give meaning to your data.</P>
<P CLASS="MsoNormal">Here are just some of the techniques you will master:</P>
<UL>
<LI>You will learn how to create robust formulas which can safely be copied into thousands of rows.</LI>
<LI>You will gain an understanding of relative, mixed and absolute references; and when to use, and when not use, those pesky dollar signs.</LI>
<LI>You will learn how to use Excel’s text functions to clean up and modify data, prior to creating reports.</LI>
<LI>You will become familiar with the use of conditional functions to add power and flexibility to your Excel models.</LI>
<LI>And you will learn how to use lookup functions to pull in key information from other worksheets.</LI>
</UL>
<P>The course is held in Peterborough at the following address:</P>
<P>Pinnacle House<BR> 4-5 Newark Rd<BR> Peterborough<BR> PE1 5WS.</P>
<H2>Course Outline</H2>
<H3>Building formulas</H3>
<P>Entering and editing formulas, Understanding operator precedence, Copying and moving formulas, Understanding relative reference format, Understanding absolute reference format, Copying a formula without adjusting relative references , Displaying Worksheet Formulas , Working with range names in formulas , Pasting a name into a formula , Applying names to formulas, Understanding external references</P>
<H3>Working with functions</H3>
<P>Inserting functions, Supplying function arguments, Supplying range arguments, Inserting nested functions</P>
<H3>Text functions</H3>
<P>Converting text, LOWER(), UPPER(), PROPER(), Extracting a substring, LEFT(), RIGHT(), MID(), Concatenation, Creating customer account numbers</P>
<H3>Logical functions</H3>
<P>Using the IF() function, Working with nested IF()s, Using AND, OR and NOT</P>
<H3>Lookup functions</H3>
<P>Creating lookup tables, Using VLOOKUP() and HLOOKUP(), Using range lookups, Finding exact matches, Using the CHOOSE() function</P>
<H3>Date and time functions</H3>
<P>How Excel handles dates and times, Construction dates with the DATE() function, Extracting date elements with DAY(), MONTH(), and YEAR() , Isolating the day, month and year , Determining the day of the week, Calculating the tme between two dates using DATEDIF(), Calculating elapsed time , Creating time sheets</P>
<H3>Maths functions</H3>
<P>ROUND() and MROUND() , ROUNDDOWN() and ROUNDUP() , CEILING() and FLOOR() , EVEN() and ODD() , INT() and TRUNC() , Using RANDBETWEEN() to generate data, Using RANDBETWEEN() to generate date and time values</P>
<H3>Database functions</H3>
<P>How database functions work, Defining the Excel database, Defining the criteria area, Using AND and OR with your criteria, The DSUM() function, The DAVERAGE() function, The DCOUNT() function, DMIN() and DMAX(), The DGET() function</P>
<H3>Dealing with errors</H3>
<P>Understanding Excel error values, #DIV/0!, #NAME, #REF, #NULL!, #N/A, Using conditionals to anticipate error values, Using IFERROR(), Using the formula error checker, Auditing a worksheet, Tracing cell precedents and dependents, Evaluating formulas, Watching cell values</P>

Peterborough

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Essential Excel Formulas & Functions

More events from G Com Solutions Limited

Discover more events from G Com Solutions Limited, from Business to other experiences you might love.

Still looking for the right event?

Explore all events in Peterborough and filter by date, category, and more to find the perfect fit.

Essential Excel Formulas & Functions

More events from G Com Solutions Limited

Discover more events from G Com Solutions Limited, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Peterborough and filter by date, category, and more to find the perfect fit.