Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    Only €10,99/month after trial. Cancel anytime.

    Microsoft Excel for Beginners and Intermediates
    Microsoft Excel for Beginners and Intermediates
    Microsoft Excel for Beginners and Intermediates
    Ebook88 pages45 minutes

    Microsoft Excel for Beginners and Intermediates

    By Fredrick Ezeh

    ()

    Read preview

    About this ebook

    The Microsoft Excel (Ms-Excel) application is one of the many applications in the Microsoft Office package. Ms-Excel is used in offices, schools, and organizations to create financial and accounting sheets and documentation such as balanced sheet, profit, and loss profit. You can also add some graphics and designs in your worksheet or documents.

     

    Course Objectives

    In this Ms-Excel course, we will utilize a practical or hands-on approach to show how you can create simple Excel documents or worksheets or workbook with pre-formatted texts, tables and adding some graphics and designs. You will learn the skills of editing texts, formatting texts, creating tables, adding designs to your workbook. You will also learn to do some financial calculations at the end of this course.

     

    Pre-Requirements and Target Audience

    The course is designed for both beginners who do not have any prior background in Ms-Excel, and for intermediate level people who also wish to extend their practical/hand-on skills and knowledge.

    To achieve or fully take advantage of this course, you need to have some prior knowledge Windows operating system environments.

    It is important you have a laptop or desktop computer with the Ms-Excel application installed, preferably, a laptop with Windows 10 and with Office365.

     

    LanguageEnglish
    PublisherFredrick Ezeh
    Release dateNov 16, 2020
    ISBN9798201380779
    Microsoft Excel for Beginners and Intermediates

    Read more from Fredrick Ezeh

    Related to Microsoft Excel for Beginners and Intermediates

    Related ebooks

    Computers For You

    View More
    View More

    Related podcast episodes

    Related articles

    • Article

      Make Office Better

      Sep 22, 2021

      Make Office Better
      2 min read

    • Article

      See Ways To Illustrate Your Data

      Sep 6, 2021

      Microsoft has launched a tool in Excel that provides suggestions on how to illustrate your data. To use it, you’ll either need to be running Excel 2019 or the online version of Excel at www.snipca.com/39295 (it works with free accounts – click ‘Creat

      1 min read

    • Article

      Miscrosoft Excel

      Feb 8, 2021

      Miscrosoft Excel
      5 min read

    • Article

      Make Office Better

      May 19, 2021

      LIBREOFFICE CALC When you’re working with a large spreadsheet, you may find yourself repeatedly selecting the same group of cells. LibreOffice Calc makes this easier by letting you save your selections, then quickly access them in a dropdown menu. Fi

      1 min read

    • Article

      Make Office better

      Oct 14, 2024

      Make Office better
      2 min read

    • Article

      Excel and Calc

      Aug 12, 2019

      Excel and Calc
      5 min read

    • Article

      Make Office Better

      Dec 4, 2024

      LibreOffice 24.8, released in August, added the XMATCH function to Calc, making it a more credible alternative to Excel. At its simplest XMATCH lets you find the position of a specific item within a range of cells. But you can perform more complex ta

      2 min read

    • Article

      Make Office Better

      Jun 2, 2021

      MICROSOFT EXCEL Tick boxes in documents are very handy for recording attendance at a meeting, marking items that are out on loan and for many other lists, but you may struggle when trying to use them in spreadsheets. In Excel, you first need to enabl

      2 min read

    • Article

      Make Office Better

      Apr 7, 2021

      LIBREOFFICE WRITER & CALC LibreOffice automatically applies properties to each document you save, such as your name and how long you’ve spent editing it. To review, edit or add to these properties before saving, open LibreOffice Writer or Calc, selec

      2 min read

    • Article

      Make Office Better

      Aug 14, 2024

      Make Office Better
      1 min read

    • Article

      Make Office Better

      Nov 9, 2022

      Make Office Better
      2 min read

    • Article

      Make Office Better

      Aug 25, 2021

      MICROSOFT WORD & EXCEL Regular Wikipedia users should consider installing an Office add-in that adds content to your your documents and spreadsheets. First, open Word or Excel, then click the Insert menu, followed by ‘Get Add-ins’. In the screen that

      2 min read

    • Article

      Create An Attractive Data Dashboard In Excel

      Sep 22, 2021

      What you need: Windows 7, 8.1 or 10; Excel 2010 onwards Time required: 20 minutes A dashboard is a great way to visualise the data in your Excel spreadsheets, so you can track and analyse the information they contain. Dashboards can include charts, g

      3 min read

    • Article

      Make Office Better

      Dec 21, 2022

      Make Office Better
      2 min read

    • Article

      Make Office Better

      Jul 31, 2024

      Make Office Better
      2 min read

    • Article

      Merge Two Membership Spreadsheets

      May 11, 2022

      Running a small club is an admin challenge in itself, but what happens when two clubs merge and you need to create a single master Excel sheet for members? Thankfully, Excel has tools to help you manage this process, although you’ll need to do some w

      2 min read

    • Article

      Make Office better

      May 22, 2023

      Presentations with lots of slides can be tricky to navigate. To make things easier, try adding a ‘table of contents’ slide at the start. First, select the View tab, then click Outline View – this displays a list of all your slides down the left side

      2 min read

    • Article

      Make Office Better

      Mar 10, 2021

      LIBREOFFICE CALC & MICROSOFT EXCEL Calc and Excel both let you generate random numbers. The RAND() formula returns a random number between 0 and 1, while RANDBETWEEN(x, y) lets you specify a range for the random numbers (replace the ‘x’ with the lowe

      2 min read

    • Article

      Make Office Better

      Jul 14, 2021

      MICROSOFT POWERPOINT PowerPoint lets you add speaker notes to each slide in a presentation. These notes will be visible on your computer when you’re presenting, but won’t be shown on the screen you’re presenting with. However, should someone ask for

      1 min read

    • Article

      Make Office Better

      Mar 24, 2021

      MICROSOFT EXCEL Microsoft has just updated the online version of Excel (officially known as ‘Excel for the web’, www.snipca.com/37634), adding a range of new features that help bring it in line with the traditional offline version. One of the most us

      2 min read

    Related categories

    Reviews for Microsoft Excel for Beginners and Intermediates

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      Microsoft Excel for Beginners and Intermediates - Fredrick Ezeh

      Fredrick Ezeh

      Power-Tech Computers Trainings (PTCT)

      © Copyright 2020

      COURSE STRUCTURE

      CHAPTER 1: INTRODUCTION TO EXCEL ENVIRONMENT

      ›  What is Microsoft Excel (Ms-Excel)?

      ›  Starting Excel

      ›  Components of the Ms-Excel Window (From Office 365) - Getting to know the Excel Environment

      ––––––––

      CHAPTER 2: WORKBOOK, WORKSHEETS AND CELLS

      ›  Creating New (Blank) Workbooks

      ›  Creating Workbooks Using Templates

      ›  Saving Workbooks

      ›  Creating Backups or Renaming Saved Workbooks (Using Save As)

      ›  Closing Workbooks

      ›  Opening Workbooks

      ›  Adding Worksheets to a Workbook

      ›  Naming Worksheets

      ›  Moving and Copying Worksheets within a Workbook

      ›  Deleting/Removing Worksheets From a Workbook

      ›  Selecting, Moving and Deleting Cells

      ›  Adjusting Column and Row Sizes

      ›  Changing Cell Alignment

      ›  Printing Workbooks

      ›  Exiting Excel

      CHAPTER 3: ENTERING AND EDITING TEXTS

      ›  Entering Data In a Worksheet

      ›  Working with AutoComplete

      ›  Selecting Texts

      ›  Moving, Copying, and Pasting Texts

      ›  Using Undo and Redo Commands

      ›  Using Find and Replace Commands

      ›  Using Goto Command

      ––––––––

      CHAPTER 4: FORMATTING TEXT, LAYOUT AND DESIGNS

      ›  Font-Level Formatting

      ›  Aligning Text

      ›  Using Indentations

      ›  Using Format Painter

      ›  Using Superscripts and Subscripts

      ›  Using Single Strikethrough

      ›  Changing Text Orientation

      ›  Wrapping Text

      ›  Working with Page Setup (Page, Margins, Header/Footer)

      ›  Adding Borders and Shading (Fill)

      ––––––––

      CHAPTER 5: CHARTS, SHAPES AND PICTURES

      ›  Creating/Inserting a Chart

      ›  Features/Elements of a Chart 

      ›  Modifying the Chart Title, Axis Titles

      ›  Modifying Chart Data

      ›  Changing Chart Types and Style

      ›  Inserting Shapes, Pictures, and Icons

      ›  To Print a Chart Without Printing the Worksheet

      ––––––––

      CHAPTER 6: FORMULAS AND FUNCTIONS

      ›  Introduction to Formula

      ›  Adding Two Cells

      ›  Adding a Long List

      ›  Fixing Mistakes or Errors in a Formula

      ›  Copying Formula

      ›  Using AutoCalculate

      ›  Using Functions

      ›  Using Financial Functions

      ›  Using the IF Function

      ›  Using Dates in Functions 

      MICROSOFT® EXCEL QUICK REFERENCE

      CHAPTER ONE

      INTRODUCTION TO EXCEL ENVIRONMENT

      ›  What is Microsoft Excel (Ms-Excel)?

      ›  Starting Excel

      ›  Components of the Ms-Excel Window (From Office 365) - Getting to know the Excel Environment

      This section of Microsoft Excel Quick Reference gets you started with some fundamental tasks that you will use frequently in Excel. You can use the procedures and ideas that you learn here in many of your Excel operations.

      What is Microsoft Excel (Ms-Excel)?

      Microsoft Excel is a spreadsheet application program created by Microsoft. It helps you do some calculations (financial and otherwise), graphics, tables and macro programming using Visual Basic for Applications (VBA).

      All work is done in a workbook. The pages within workbooks are called worksheets (simply called sheets). There can be as many or as few worksheets within a workbook as you need.

      Starting Ms-Excel

      You can start Excel in several ways. These are:

      - Option 1: Start Ms-Excel Using the Start/Windows Button

      Click Start (Windows ) button and a list of programs pops-up

      Look for the Excel logo and click it.

      If a window pops-up, under New section, click Blank Workbook, and a new empty Excel Workbook will be opened. Otherwise, a blank Workbook will be opened.

      - Option 2: Starting Ms-Excel Using the Search Box

      Move and click in the Type here to search box near the windows logo at the bottom left of your computer or laptop.

      Type Excel and a separate window with a few suggested programs or apps pops-up

      Look for the Excel app and logo , and click it, and a new window pops-up.

      Under New section, click Blank Workbook, and a new empty Excel Workbook will be opened.

      Components of the Ms-Excel Window (From Office 365) - Getting to know the Excel Environment

      When the Ms-Excel application is opened, the environment looks like the window shown below.

      Figure 1.1: The Ms-Excel Window or Workbook (From Ms-Office 365)

      The next image shows the components of the Excel

      Enjoying the preview?
      Page 1 of 1