OptimaTrain

Practical Excel 2016 for the Workplace – Fundamentals (ILT)

0 STUDENTS ENROLLED

    COURSE DESCRIPTION

    This introductory course covers the fundamentals of Microsoft Excel 2016. It assumes you have used Excel, at least at an elementary level, such as opening and saving an Excel file. This course will drastically increase your productivity and broaden your Excel skills.

    The course begins with the Excel user interface: the tabs and ribbons, the backstage view, and the Quick Access Toolbar. It then teaches you methods for performing common Excel tasks, such as moving around large worksheets, selecting ranges, copying and pasting, working with formulas, creating and modifying charts, and printing. It also teaches you best spreadsheet practices for making your spreadsheets attractive and understandable by others. Throughout, the focus is not just on performing common tasks in Excel, but performing them efficiently.

    Category: Office Productivity/Microsoft

    Duration: 1-2 Days

    What are the requirements?

    • Microsoft Office 2016

    What am I going to get from this course?

    • An understanding of the Excel user interface, including changes to Excel since 2007
    • Efficiency tips on moving around worksheets and selecting large ranges
    • Efficiency tips on copying, cutting, and selecting formulas and ranges
    • How to manipulate rows, columns, and worksheets
    • How to take control of printing worksheets
    • How to format efficiently and effectively
    • How to work effectively with formulas, including auditing for correctness
    • How to create and modify charts effectively
    • How to use common but powerful Excel functions, including IF and VLOOKUP
    • Best practices for creating attractive and understandable spreadsheets

    What is the target audience?

    • Any beginning Excel users who want to become more efficient and take their Excel skills to the next level

    Lesson Plan

    Introduction to Course
    Welcome to Fundamentals Course
    Intro to Optima Train Tutorial
    Evolution of Excel
    Changes in Excel
    Excel User Interface
    Intro to Excel User Interface
    Tabs and Ribbons
    Customizing Ribbons
    File Menu
    Quick Access Toolbar
    Opening Recent Files
    Excel Options
    File Extensions
    Single Document Interface
    Excel Basics
    Intro to Excel Basics
    Intro to Moving and Selecting
    Going Home to Cell A1
    Splitting the Screen
    Selecting a Range with Keys
    Selecting a Range by Pointing
    Selecting Multiple Ranges
    Go To Options
    Copying, Cutting, & Pasting
    Intro to Copying, Cutting, Pasting
    Copying and Pasting
    Cutting and Pasting
    Paste Special Options
    Transposing a Range
    Office Clipboard
    Other Basic Tools
    Intro to Other Basic Tools
    Undoing Actions
    Right-Clicking
    Shortcut Keys
    Number Formats
    Manipulating Rows, Columns
    Manipulating Worksheets
    Printing
    Cell Borders
    Shapes and Pictures
    Filling a Series
    Sorting and Custom Lists
    Adding Hyperlinks
    Templates
    Formulas
    Working with Formulas
    Relative, Absolute Addresses
    Calculation Options
    AutoSum Button
    Error Codes
    Range Names 1
    Charts
    Intro to Charts
    Creating a Chart
    Modifying a Chart
    Locating a Chart
    Sparklines
    Functions
    Intro to Functions
    Function Help
    Intro to Basic Summarizing Functions
    SUM, AVERAGE, PRODUCT
    COUNT, COUNTA, COUNTBLANK
    SUMPRODUCT
    Intro to Two Essential Functions
    IF
    VLOOKUP
    Spreadsheet Best Practices
    Intro to Spreadsheet Best Practices
    Documenting Your Work
    Themes
    Styles
    Conditional Formatting
    Conclusion to Course
    Conclusion to Fundamentals Course

    Course Reviews

    N.A

    ratings
    • 1 stars0
    • 2 stars0
    • 3 stars0
    • 4 stars0
    • 5 stars0

    No Reviews found for this course.