Setup Menus in Admin Panel

A basic level of Excel understanding is crucial for most office roles. Microsoft Excel's fundamental knowledge will enable you to identify trends and organise and sort data into meaningful categories.

Course Instructor
Duration

4 hours, 29 minutes

Last updated

February 11, 2023

5
Students

32

PRIVATE

More about the course

You can also perform human resources functions, such as sorting worked hours and organising employee profiles and expenses, which help businesses better understand the structure and activities of their workforce. Excel is the preferred tool for business professionals to analyse and display data.

You will be able to do the following after completing this course:

  • Navigate the interface, including creating and saving workbooks, quickly accessing commands, and selecting and entering data
  • Insert and delete rows and columns
  • Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
  • Use multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
  • Perform calculations using formulas and functions
  • Apply formatting to text, numbers, and cells, including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
  • Manage multiple worksheets within a workbook, including adding, removing, renaming, reordering, copying, and colour-coding worksheets
  • Customize your instance of Excel, including adding Groups to the Ribbon and modifying the Quick Access Toolbar.

Is this course for you?

Anyone who has never used Excel or re-entering the workforce with only a rudimentary understanding of the software can sharpen their basic skills from this excel course. A basic level of Excel understanding is crucial for most office roles. This includes office managers, personal assistants and secretaries. Microsoft Excel is essential for anyone involved in accounting, reporting and planning. This beginner's course is recommended for anyone using Excel at home or work for uncomplicated reasons, such as tracking simple expenditures or calculating sums or totals.

Learning excel will help you understand what consists of individual cells can be used to build functions, formulas, tables, and graphs that easily organise and analyse large amounts of information and data. Anyone who wants to learn the most widely used software can explore this introductory excel course. Individuals or professionals like bankers, accountants, business analysts, marketing professionals, scientists, and entrepreneurs can build skills in using Excel consistently. You can enhance your practical knowledge with a complete overview of Excel's most common features and how to use them.

Why Choose Mastering Excel 2019 - Basics 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 successfully 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
    • Navigating the Interface. 00:09:00
    • Selecting Data. 00:09:00
    • Using Commands. 00:07:00
    • Creating a New Workbook. 00:08:00
    • Entering Cell Data. 00:08:00
    • Using AutoFill. 00:07:00
    • Using Flash Fill. 00:05:00
    • using Excel Help. 00:02:00
    • Creating Formulas. 00:08:00
    • Inserting Functions. 00:08:00
    • Copying Formulas and Functions. 00:07:00
    • Using Absolute Reference 00:10:00
    • Inserting and Deleting Cells.. 00:09:00
    • Searching and Replacing. 00:08:00
    • Using Proofing and Research Tools 00:07:00
    • Applying Text Format 00:09:00
    • Applying Number Formats. 00:07:00
    • Customizing Number Formats. 00:08:00
    • Aligning Cell Contents. 00:07:00
    • Applying Cell Styles. 00:05:00
    • Applying Themes. 00:04:00
    • Inserting Hyperlinks. 00:07:00
    • Applying Conditional Formatting 00:07:00
    • Applying Conditional Formatting to Text and Dates. 00:08:00
    • Applying Comparitive Analysis Formatting 00:07:00
    • Using Templates 00:06:00
    • Printing Workbooks. 00:04:00
    • Setting the Page Layout. 00:07:00
    • Inserting page Breaks. 00:09:00
    • Configuring Headers and Footers, Part 1. 00:05:00
    • Configuring Headers and Footers, Part 2. 00:04:00
    • Managing Worksheets, Part 1. 00:05:00
    • Managing Worksheets, Part 2. 00:08:00
    • Creating a Custom View. 00:04:00
    • Managing Worksheet Views. 00:06:00
    • Managing Workbook Views. 00:06:00
    • Managing Workbook Properties 00:04:00
    • Customizing General Options. 00:04:00
    • Customizing the Ribbon. 00:07:00
    • Customizing the Quick Access Toolbar. 00:07: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