Are you in the calculation, tables and data entry circles? If yes, visit LBC.
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft trainee you will guided with a step by step through the beginner level. The learning will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics. MS Excel provides many analytical tools for the accurate analysis and comparison of large amounts of data. The advanced sorting and filtering techniques allows you to sort out large amount of data so that it will be easier for you to find out the required information. Also, filtering removes unwanted or repeated data and helps to save time and effort.
OBJECTIVE
This course aims to provide skills and knowledge which will allow the attendee to Learn MS Excel tools, Techniques and create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver, and create and use macros. Microsoft Excel is a spreadsheet developed by Microsoft and it can be used in different Operating systems like Microsoft Windows, iOS, Android, etc.
Content
Introduction to Excel: Getting Started
Entering Data
Using Formulas
Formatting Worksheets
Modifying Columns and Rows
Editing Workbooks
Printing Worksheets
Applying Cell Styles
Working with Constant Values and Formulas
Merging Cells
Learning Outcomes
By the end of the Course period learners should be able to:
Create effective spreadsheets
Manage large sets of data
Master the use of some of Excel’s most popular and highly sought after functions.
Create dynamic report with Excel PivotTables
Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks.
Pedagogy
Logan Trainers use up to date training techniques and variety of training methods to give all participants the best opportunities for learning, including: Practical sessions, Group discussions Tutorials. Presentation / Lectures Demonstrations. Reading materials provided for example Learning guides and Individual assessments using practical Online Assessment software, remedial class and revision sessions.
Who should atttend
Any public and private enterprise personnel, with interests to take Excel skills from beginner to advanced level and beyond, then this course is for you.