Setup Menus in Admin Panel

An intermediate-level Microsoft Excel covering more text, date, lookup and math functions expands to formula auditing to efficiently complete complicated excel tasks with a career guideline for anyone with any skillset to analyse your data or finances in detail.

Course Instructor
Duration

5 hours, 7 minutes

Last updated

February 11, 2023

5
Students

33

PRIVATE

More about the course

This course on improving formatting, organising data, highlighting essential information and creating formulas/links between sheets will improve your accuracy and productivity and help you better understand critical features to enhance efficiency.

These skills are essential for anyone going into investments, banking, or consulting and will also be helpful for administrators or those who track or analyse a lot of data.

Also, someone new to the workforce will find that employers are looking for candidates with at least intermediate Excel skills.

MS Excel Intermediate course is designed for anyone who works with Excel in the workplace. An industry-renowned entrepreneur with a tech background developed this roadmap to reduce cost and sharpen efficiency in any business sector.

You will be able to do the following by the end of this course

  • Create and use named ranges
  • Sort and filter columns of data
  • Create and modify charts and graphics
  • Create a PivotTable for the group and summarize data
  • Insert functions into spreadsheets, including Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
  • Create and modify Tables, and apply advanced Conditional Formatting
  • Apply advanced charting tools
  • Apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines

Is this course for you?

This intermediate course is designed for those who work with Excel in the workplace and primarily for those who want to improve their skills with this program. Explore this intermediate Microsoft Excel course if you have used Excel before and want to expand your knowledge. You’ll be able to skill in improving formatting, organising data, highlighting essential information and creating formulas/links between sheets. Improve your accuracy and productivity by utilising list management, handling large worksheets more effectively and enhancing the formatting of your spreadsheet data by using conditional formulas. Enhance your understanding of key features.

Why Choose Mastering Excel 2019 - Intermediate course?

  • Conducted by industry experts
  • Get Instant E-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified professionals
  • Self-paced learning and laptop, tablet, smartphone-friendly
  • Tutor Support

Certification

Upon completing this course, an instant e-certificate will be generated free of charge. The digital version of the course transcript is available for £2.99. We can post the printed copy of the certificate and the transcript to your address. A delivery charge of £4.99 (UK) & £12.99 (Outside the UK) is applied to this service.

Industry Expert Instructor

Rated Excellent on Trustpilot

Course Content

    • Introduction FREE 00:02:00
    • Using Named Ranges, Part 1 00:05:00
    • Using Named Ranges, Part 2 00:06:00
    • Using Named Ranges, Part 3 00:05:00
    • Working with Date Functions, Part 1 00:09:00
    • Working with Date Functions, Part 2 00:05:00
    • Working with Date Functions, Part 3 00:04:00
    • Working with Time Functions 00:06:00
    • Working with Logical Functions 00:09:00
    • Working with Conditional Functions 00:08:00
    • Multiple Criteria Functions 00:05:00
    • Using Nested Functions 00:05:00
    • Using IFS and SWITCH Functions 00:06:00
    • Working with Text Functions, Part 1 00:05:00
    • Working with Text Functions, Part 2 00:05:00
    • Working with Text Functions, Part 3 00:04:00
    • Working with Text Functions, Part 4 00:09:00
    • Working with Math Functions 00:07:00
    • Sorting Data, Part 1 00:06:00
    • Sorting Data, Part 2 00:06:00
    • Filtering Data, Part 1 00:06:00
    • Filtering Data, Part 2 00:08:00
    • Filtering Data, Part 3 00:08:00
    • Querying with Database Functions 00:07:00
    • Using the Subtotal Function 00:05:00
    • Using the Subtotal Feature 00:07:00
    • Creating Tables 00:07:00
    • Modifying Table Styles 00:07:00
    • Summarizing Data in Tables 00:05:00
    • Using the Quick Analysis Shortcut 00:02:00
    • Customizing Conditional Formatting 00:06:00
    • Using Formulas with Conditional Formatting 00:06:00
    • Creating Charts 00:06:00
    • Using Chart Types 00:02:00
    • Changing Chart Data Source 00:07:00
    • Adding Chart Elements 00:10:00
    • Formatting a Chart 00:05:00
    • Using Advanced Chart Features 00:04:00
    • Applying Trendlines 00:05:00
    • Creating a Chart Template 00:03:00
    • Inserting Graphics 00:09:00
    • Modifying Graphics, Part 1 00:06:00
    • Modifying Graphics, Part 2 00:07:00
    • Creating a PivotTable 00:12:00
    • Summarizing Data in a PivotTable 00:08:00
    • Grouping Data in a PivotTable 00:06:00
    • Formatting a PivotTable 00:07:00
    • Selecting and Moving PivotTables 00:03:00
    • Changing PivotTable Options 00:08:00
    • Adding Calculated Fields 00:02:00
    • Presenting Data with PivotCharts 00:04:00
    • Using Timeline Slicers 00:02:00
    • What’s Next? 00:00:00
    • Get Your Certificate & Transcript 00:00:00

Course Reviews

© 2024 Course Central | website design & Maintenance by: menulane

Setup Menus in Admin Panel